Category: Coding
-
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.…
-
Advanced SQL: Using UNPIVOT()
365 Days of Daily Coding: Day 124 I am an early bird today. Yay! I just bought an alteryx course in udemy and I am happy to be working on it soon. One of my acquaintance says it’s an extremely easy tool to use and one can easily learn it in the matter of 2-3…
-
Advanced SQL: Using ROW_NUMBER()
365 Days of Daily Coding: Day 123 I still have 33 puzzles to go for until I can complete my advanced sql challenge. I am looking forward to completing all the puzzles and start working on Serious SQL by Danny Ma. I think from then on I am pretty much done with building my foundational…
-
Advanced SQL: Using Count
365 Days of Daily Coding: Day 122 It’s a lovely morning today. I live in an area where there is a small forest besides huge mass of buildings and you can often hear the birds chirping as its quiet. Reflecting back, I am where I have always wanted to be back when I young graduate…
helokarma.blog 