Category: Blog
-
Python Beginner Youtube Video: Part 1

365 Days of Daily Coding: Day 154 I have been occupied lately to finish some assessments so I was not able to post. I am back to catching up with my daily coding studies. I like to spend time watching SQL and Python video trainings in youtube these days. For today, I completed 2 hr…
-
Advanced SQL: Using JOINS

365 Days of SQL: Day 153 If you are reading this, thank you for dropping by. I hope so far my blogs have been motivational for you to keep rocking your journey. I hope you get whatever is it that you are hoping and wishing for. Puzzle #38: Reporting Elements I tried the solution in…
-
Advanced SQL: Using JOINS

365 Days of SQL: Day 152 Yay! 3 more puzzles to go and I wrap the advanced SQL puzzle. I am so elated beyond words. I have had lots of things in my mind about what to work on next after this. There’s: Continue SQL daily learning but this time I will cover on all…
-
Advanced SQL: Using JOINS

365 Days of SQL: Day 151 I read the puzzle for today and I was thinking to myself, “Oh my gosh!” This looks really tough. However, as I began solving the question, I realised that the solution was rather smooth. It did not come easy but it helped to play around a bit. Yay for…
-
Advanced SQL: Using IN

365 Days of SQL: Day 150 I have decided to also officially start another challenge i.e for Tableau. I think I am good in Tableau however, since I started right off without basics, I want to work on them. I had started to read the Tableau documentation from their official site. I will be posting…
-
Advanced SQL: Using NOT IN

365 Days of SQL: Day 149 The rain has finally stopped after continuously raining for the past 2 days. There’s been flooding in several places in KL. I was actually invited to a friend’s house but i did not go because it was raining. It was wise decision although I felt a bit bad for…
-
Advanced SQL: Using JOINS

365 Days of Daily Coding: Day 148 It’s been raining heaviliy since yesterday here in KL. There are few places where its flooded. I feel blessed that I am living in a place where I feel safe and I am warm. Such are blessings that is easily missed in our everyday lives. Puzzle #33: Deadlines…
-
Advance SQL: Using Windows function

365 Days of SQL: Day 147 There’s been some construction happening in the floor above and its making our lives very uncomfortable. One of the cons of living in a condo. It’s going to be like this until 31st Dec. Why did they have to select such timing? Ahh geezz! Puzzle #32: First and Last…
-
Advanced SQL: Using multiple methods to gauge the optimum solution

365 Days of Daily Coding: Day 146 Starting fairly late today for today’s blog as lot of things have been going on in my head these days. I don’t know if things will turn out well like I have been thinking but I know that I cannot and should not stay where I am. This…
-
Advance SQL: Computed Column

365 Days of Daily Coding: Day 145 I am starting fairly early today writing this blog. For the past few days, I was working on it during the evening time and gosh! by then I am famished and my brain has very less power to concentrate. I have decided to visit the gym today which…