Data with Danny
I enrolled in a SQL course called "Serious SQL" on the website Data with Danny. As the name implies, it is taught by Danny - who not only really understands his subject matter, but also has a great sense of humor.
I've started working through the course and I love how it's laid out. You start out by setting up your environment. Depending on which type of computer you're using, it could be a few simple steps (Mac) or many detailed steps (Windows). Thanksfully, I am taking the course on my MacBook Pro and was up and running within a half hour or so.
Once the setup is complete, you can begin working through the course, which is very hands-on. Best of all, you can use Danny's code as a starting point and experiment with your own code with no worries of breaking anything.
I'm still in the Data Exploration phase of the course. In this section, we learn the basics of SQL and how to explore our dataset. Things like:
- Selecting and sorting your data
- Record counts & distinct values
- Identifying duplicate records
- Summary statistics
- Distribution functions
Looking forward, I can see that we will be working on two case studies: Marketing Analytics and People Analytics, where we will get into some more advanced topics like JOINS, and WINDOW FUNCTIONS.
I'll make some more updates as I progress through the course, but so far, this course gets two thumbs up from me!