Patrick Curtis – SQL For Data Analytics

In this module, we use 7 video lessons to introduce databases and how SQL is integral to Data Analytics. This includes a module on the benefits of learning SQL from differentiation from peers to the many lucrative career opportunities available from learning programming skills.

In this module, we use 7 video lessons to explain how data is streamlined, connected, and stored in SQL using relational databases. We wrap up this module by learning the foundational code outline SELECT…FROM that is integral to start coding.

In this module, we use 7 video lessons to expand on our foundational code outline by learning new conditional modifiers that allow us to filter our data bse. This module includes a step-by-step walkthrough and application using a company’s sales data.

In this module, we use 8 video lessons to help explain several advanced data filtering and arithmetic techniques such as Distinct, Order by, and Count. This module also includes several benchmarking exercises with video solutions to make sure you keep practicing until you are very productive…

In this module, we use 8 video lessons to explore linking data across multiple data tables as well as using the left function to splice strings. This module also includes two challenging exercises with video solutions that test your knowledge of SQL so far…

In this module, we use 8 video lessons to go over the final filtering function we need to know: Having. We wrap up this module with guided walkthroughs of three challenging exercises that summate all the different skills we have learned in the course.

In this module, we use 4 video lessons to explore temporary tables and how they are useful in modifying linked data tables. This module also includes a capstone challenge that will surely test if you are a SQL pro…