DEV Community

Lauren Fosgett
Lauren Fosgett

Posted on

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.

Top comments (5)

Collapse
 
nftcryptomix profile image
nftcryptomix

I will watch you progress as I am learning too but I think I well far from where you are my fellow dev. I am actually doing a 12 hour bootcamp with CSS HTML and JavaScript. It literally took me all day just to go through 1 hour of the video lol but what I thought I saved I lost it all lol. Had to start all over again. What the good thing was I speed through it and I could read the code and see how div's class's id's work with css styleSheet , # and under stand psuedocode with div's better so I have a better picture how to layout my work and also look at other code and see the basics of their formate and be able to change code online with inspect element but the changes dont last but the possibilities are their to see and how cool flexbox. I thought I didn't learn much but that 1 hour was well worth doing again and also the next hour I went through fast too. My goal is to build a blockchain gaming ecosystem with a social media and ecommerse. Well thank you for your 100 Days of Leaning and I will be watching with interest :).

Collapse
 
lfosgett profile image
Lauren Fosgett

Thank you for sharing! That course you found sounds like an awesome start! I also recommend freecodecamp.com for hands-on exercises and lessons as well. The hours go by fast but they add up over time, you've got this.

Also, I second what Let's Code said about using something like codepen.io/ to save your work in if you'd like to revisit it later. It's great for saving code samples or even building out larger projects.

Collapse
 
nftcryptomix profile image
nftcryptomix

Yeah I have seen alot of the freeCodeCamp and have put them in box's to do later and I have at alot to go through lol and I love the hours. Yes I have code pen in the html css javaScript box. I have used 3 code editors and Iove Visual Studio but this time this codeSandBox which was new to me because of the tutor using it I thought I would give it a go and didnt think twice before I new it the whole day went by and I could see I only did about an hours work booooom turned the device off and low and behold go to turn the codeSandBox back on !!!!!!!!!!!!!!! NOOOOOOOO all gone. Thanks for your reply :).

Collapse
 
frontendengineer profile image
Let's Code

use version control like git so you don't lose anything.

if you want something simple that you will save your progress, use something like codepen or codesandbox.io

Collapse
 
nftcryptomix profile image
nftcryptomix

I used codeSandBox, it didn't save the stuff I thought if automatically saved all my work but it didnt. All good, I actually liked doing the course again because I picked it faster and I now know how important div's - classes and id's are with psuedoCode. Thanks for your reply :)