Category: Coding
-
Serious SQL with Danny – Day 12

365 Days of SQL: Day 172 Yo peeps! Hope you are having a good start of the day. I continued on to another lesson of the course. The course covers Windows function in detail, like too DETAIL! which is a good thing. I only covered half of the lesson as it was quite lengthy. One…
-
Serious SQL with Danny – Day 11

365 Days of Coding – Day 171 Hola everyone! Hope you have a fantastic start in APAC and a good rest of the day for people from other time zones. I have resumed my course and I am happy to share my today’s learning. I am currently viewing the Marketing Analytics case study under the…
-
Stack Overflow – Nested Group Function in Oracle

365 Days of Daily Coding – Day 170 Today, I have drifted off a bit from my usual SQL entries and decided to look at some of the questions asked in Stack Overflow. It also aligns with my wanting to view how other people approach questions that they face in their day-to-day work. At this…
-
Serious SQL with Danny – Day 10

365 Days of SQL: Day 169 I have been quite busy for the past two days. My little sister left for Australia today Her visa was approved on such a short notice that the entire family were on their edge. Anyway, she’s managed to fly and is going to be embarking on her new journey.…
-
Serious SQL – Data with Danny Day 9

365 Days of Daily Coding: Day 168 I had a bit of a focus issue today. Well, I did my meditation as I had intended to but I kinda strayed away from focus for the entire day. Well today, I learned about IN and NOT IN also alternatives for LEFT SEMI JOIN and ANTI JOIN.…
-
Serious SQL – Data with Danny Day 8

365 Days of Daily Coding – Day 167 Today was an ok day. I wish I was more productive. I think I better read some productivity books my boss was suggesting me especially on how not to get easily distracted and provide maximum focus. I will try meditation in the morning too. Probably go to…
-
Serious SQL – Data with Danny Day 7

365 Days of Daily Coding – Day 166 It’s been a productive day today. I have been reading a lot on SEO lately cause I have officially transitioned from a fintech industry to a digital commerce industry. My first job was at a digital commerce industry so I am quite familiar with the basic/foundational knowledge…
-
Serious SQL – Data with Danny Day 6

I am feeling quite tired today especially because it is that special part of the month. I think females will be able to easily relate. To add to my daily learnings, I reviewed the concept of Left Semi Join (WHERE EXISTS). This was an interesting join to know about especially because standard inner joins may…
-
UPDATE and another day of Serious SQL – Data with Danny Day 5

365 Days of Daily Coding: Day 164 Dear readers, today I am very proud to share that I have finally rejoined the workforce as a SEO Data Analyst. After months of contemplating and thinking and re-thinking, I have gotten something that I am happy with and to spend my day to day. With this, I…
-
Serious SQL – Data with Danny Day 4

365 Days of Daily Coding: Day 163 I had a wonderful day today. I just barely managed to finish the case study today. It was a good revision. Tomorrow, I am going to review all the contents from the lesson and move onto the next lesson which is going to be handson. That is exciting.…