100 Days of Learning - Day 5

Hello and welcome to my 100 Days of Learning challenge! As I mentioned yesterday, I'm starting to dig deeper into SQL for work. I found a course on Pluralsight that has been so helpful and really changed how I think about my SQL queries (link below).

My Learning Goals for today:

What I Completed:

  • I finished the course!

What I Learned:

Finishing out this course covered FROM, WHERE, GROUP BY, and HAVING clauses, and so much more. The examples in this course are so thorough and explain why different errors might occur in your queries (and really drill in execution order). I plan to revisit these and start to put together a series on SQL based on what I've learned.

I also signed up for CodeNewbie's 2022 Learn In Public Challenge, so maybe this SQL series will be my focus for that. It's about a month away, so we'll see if I've moved onto learning something different by then.

My Goals for Next Time:

  • Start the Pluralsight course on SQL Joins
    • When I finish these Pluralsight courses, I'm going to do a case study of the queries I've been using at work in my day-to-day, and then ask my developer to give me a deep dive on how the DB for one of our main projects is structured.

Thanks for joining me on this journey. If you're doing your own #100daysofcode, please share in the comments! I'd love to hear about what you're learning.