Category: Blog
-
Advanced SQL Challenge: Using LEVEL AND CONNECT BY
365 Days of Daily Coding Challenge: Day 105 I had a fantastic day today. I finished watching a Korean drama called “Hwarang”. Half of the time, I was pressing the right arrow key to finish the drama quickly lol. I also cooked momo which is one of the most popular fast food in Nepal. Every…
-
Advanced SQL Challenge: Using LISTAGG() again
365 Days of Daily Coding: Day 104 It’s TGIF. We have a long weekend since Monday is a public holiday. I am going to utilise my time to prepare for my tableau cert as well as on my long awaited data viz project. I just don’t understand what my roadblock is. I guess it is…
-
Advanced SQL Challenge: Using LISTAGG()
365 Days of Daily Coding: Day 103 I took leave today from work in the middle of the week. Normally, I prefer taking holiday on Friday so that I can enjoy longer weekends. I absolutely enjoyed it to the fullest. I like cleaning and completely decluttered my space from ever increasing hoardings of 3 years.…
-
Pandas and SQL Cook Book
365 Days of Daily Coding: Day 102 I have been reading a lot lately as I am trying to reduce my screen time. Too much screen time has been causing me headaches and eye pain. My latest read is a book called “Invisible Women: Exposing Data Bias in a World Designed for Men”. This piqued…
-
8 Weeks of SQL Challenge: Week 2
365 Days of Daily Coding: Day 101 Hello readers! I hope you had a good day. We are having lock down here in Kuala Lumpur. We are only allowed to travel a distance of 10km from our home for necessities and emergencies. I also hope that you all have either been vaccinated or waiting to…
-
8 Weeks of SQL Challenge: Week 1
365 Days of Daily Coding: Day 100 Wohooo! It’s Day 100. I am really happy with my progress. It’s been an amazing ride I must say. To continue off with yesterday’s challenge, I looked into implementing the last question in excel and I am extremely elated to announce that the results match perfectly. That means…
-
8 Weeks of SQL Challenge: Week 1
365 Days of Daily Coding: Day 99 I am pretty tired today. It’s kind of late too but I had wanted to finish checking if my queries from the Week 1 challenge that I completed yesterday were spitting the same results as in excel. In the process, it has also helped me to refresh memories…
-
8 Weeks of SQL Challenge: Week 1
365 Days of Daily Coding: Day 98 I have been working on this SQL challenge for a few days. The challenges here are like real case based scenarios which were totally fun to work on. At first, I wanted to be a serious SQL student and therefore, run the queries for the challenges in Oracle…
-
Advent of Code Day 1
365 Days of Daily Coding: Day 97 This blog has been posted after quite sometime. It’s not that I haven’t been working on coding. I just didn’t bother to post about what I had been learning. Since I have completed most of the questions in SQL pad (just have 1 question to solve there) and…
-
Codility Test: Challenge 2
365 Days of Daily Coding: Day 96 I was quite occupied with work today nontheless, I managed my productivity although I would have liked it to be much better. I am resuming my Korean classes from June which I am quite excited about. But first, I must recap everything I learned from the beginner and…
helokarma.blog 