Category: Blog
-
Advance SQL: Complex Puzzle
365 Days of SQL: Day 144 I took a day off today cause I had some personal things to run. I am super happy with my progress today and in general. I spent my day by relaxing and simply enjoying a nice Netflix movie called “Happiness”. I have recently started this challenge to post continuously…
-
Advance SQL: Using Running COUNT()
365 Days of Daily Coding: Day 143 “I am quite tired today. I just arrived home after celebrating my friend’s birthday. We went to a nice restaurant called “Blonde”. They sell fusion foods. I had BBQ lamb kebab that was served with rice. I would say it was ok. The meat was sort of caramelised…
-
Advance SQL: Using DELETE()
365 Days of Daily Coding: Day 142 I do not have oracle database installed in my laptop to truly work on the solution for today’s puzzle. I tried it several times for several hours however, I was not successful. Hence, the solution for today’s challenge is just done out of research. Perhaps, when I have…
-
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…
helokarma.blog 