Patrick Curtis – SQL For Data Analytics

In this module, we use In this module, we use 7 video lessons7 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  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 opportunitiesmany lucrative career opportunities available from learning programming skills. available from learning programming skills.

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

In this module, we use In this module, we use 7 video lessons7 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  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 applicationstep-by-step walkthrough and application using a company’s sales data. using a company’s sales data.

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

In this module, we use In this module, we use 8 video lessons8 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  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 knowledgechallenging exercises with video solutions that test your knowledge of SQL so far… of SQL so far…

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

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