Category: Coding
-
Advanced SQL: Using PIVOT()
365 Days of Daily Coding: Day 141 I am quite tired today. But I am mustering all my might and will power to complete today’s challenge. Something I realised today is that spending significant time in social media like Instagram, Facebook and Tiktok can rewire your brain that can lead to shortening attention span to…
-
Advance SQL: Using WINDOWS function
365 Days of Daily Coding: Day 140 I tried downloading the Virtual Box to install windows in my mac. The first time it was ok but then I faced some blockers and have not been able to accomplish the task yet. I tried almost 3-4 hours yeterday. I am gonna give a last try today.…
-
Advance SQL: Using BETWEEN
365 Days of Daily Coding: Day 139 Although I said that I wanted to continue working on my Tableau viz, I decided to instead focus on Alteryx. The problem I faced was that the installer is only compatible with Windows and I have to get a virtual machine with windows operating system to work on…
-
Advance SQL: Using CROSS JOIN
365 Days of Daily Coding: Day 138 I have been in delimma whether to continue working on my next data viz projects or learn alteryx. I am torn apart but my heart says data viz project so it is. As mentioned in my previous post, I will be using adobe illustrator this time around however,…
-
Advanced SQL: Using MAX() and INNERJOIN()
365 Days of Daily Coding: Day 137 I just recently finished a data viz project that I built in Tableau. I am thinking of making a blog post for the process. It is going to be a small post. I will be talking about where I sourced the data from, what were few design choices…
-
Advanced SQL: Using NOT IN()
365 Days of Daily Coding: Day 136 As I hear the bird singing, I feel extremely grateful today. May I always be reminded that the only thing guranteed in life is today and may I have the courage and the blessings to pursue and fulfil my passion, live my authentic self every second, every minute…
-
Advanced SQL: Using RANK()
365 Days of Daily Coding: Day 135 I woke up today feeling much energised and light headed. It was as if all the pressure points in my head was released and I felt much relaxed and at ease. Perhaps, its because I have been thinking a lot of things and its stressing me out. Puzzle…
-
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…
helokarma.blog 