Category: Blog
-
SQL Reading Day!
365 Days of Daily Coding: Day 134 I am feeling quite sick today. I think I might have a migraine. This is diminishing my ability to think properly and hence I have not worked on any advanced SQL puzzles today. In order to continue my streak of daily posting, I decided to read an article…
-
Advanced SQL: Complex one
365 Days of Daily Coding: Day 133 I am experiencing a bit of downtime today mainly because I think I might have a brain fog. Brain fog is when you cannot concentrate well and easily feel tired and fatigued. On a brighter note, I am actually quite excited for tomorrow since tomorrow is a public…
-
Advanced SQL: Using Cross Join
365 Days of Daily Coding: Day 131 Manifesting that today’s going to be a fantastic day. I complete most of the task I set out to do. I eat healthy today and most importantly go for a walk. All my wishes come true. All my fears, be gone. I am happy, healthy and grateful. I…
-
Advanced SQL: Using CASE
365 Days of Daily Coding: Day 131 I am having a lovely day today. I just started this awesome LinkedIn trend called #LinkedInHardMode where I have to create contents and post for 30 days straight. At first, I was quite hesitant. There were a lot of things that were going on in my head. Now…
-
Advanced SQL: Using LIST_AGG() and TO_CHAR()
365 Days of Daily Coding: Day 130 I woke up quite late today unlike normal days where I wake up before 6.30am. I guess I was very tired last night. I was trying to use all my might to trying to figure out how to build a data viz in tableau. I have a vision…
-
Advance SQL: RUNNING SUM in PL/SQL
365 Days of Daily Coding: Day 129 I am doing a data visualisation course from domestika. It was just so that I was scrolling my facebook’s newsfeed and I saw that they have black friday sale. I clicked on their ad since I was interested. I browsed few secs and saw the course. I was…
-
Advanced SQL: Using LEAD() and TRUNC()
365 Days of Daily Coding: Day 128 I had a slow start today. I was supposed to attend a friend’s wedding. Unfortunately, my visa is up for renewal and I do not have my passport with me. That means my movement is limited until I can get hold of my passport. Polices in Malaysia are…
-
Advanced SQL: Using CrossJoin
365 Days of Daily Coding: Day 127 I woke up quite early today and I think I did not get enough sleep in my opinion so I am feeling a bit dull this hour. I hope I can shake it off after I have my breakfast. I ordered egg, cheese and ham croissant from grab.…
-
Advanced SQL: Using Mean(), Median(), STATS_MODE(), MAX() and MIN()
365 Days of Daily Coding: Day 126 30 more puzzles to go for. Wow! I am realising that time flows so fast. I cannot wait to try the Serious SQL Questions. There are weekly training session happening for those who bought the course. The first session I couldn’t attend as I had a conflicting appointment…
-
Advanced SQL: Complex one!
365 Days of Daily Coding: Day 124 For the first time, after nearly 2 years I got to meet my colleagues. It was great to see them as there are few newcomers in my team whom prior to today, I had never met. It will be a while until I go back to office again.…
helokarma.blog 