Patrick Curtis – SQL For Data Analytics
50+ Lessons, 6+ Challenges, 3+ hours of video lessons
To Help you Thrive in the Most Prestigious Jobs on Wall Street…
HERE’S JUST SOME OF WHAT YOU’LL GET IN Patrick Curtis – SQL For Data Analytics
Introduction (7 video lessons)
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.
Selecting Data (7 video lessons)
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.
Conditional Statements (7 video lessons)
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.
Using Common Keywords (8 video lessons)
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…
Combining Tables (8 video lessons, 2 challenges)
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…
Filtering Data (8 video lessons, 3 challenges)
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.
Temporary Tables (4 video lessons, 1 challenge)
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…
Course Summary – Table Of Contents
Below you will find a list of the modules and lessons included in this course.
- Module 1: Introduction
- Module 2: Selecting Data
- Module 3: Conditional Statements
- Module 4: Using Common Keywords
- Module 5: Combining Tables
- Module 6: Filtering Data
- Module 7: Temporary Tables
- Module 8: Final Thoughts
Salepage: Patrick Curtis – SQL For Data Analytics
Find out more Business & Marketing Courses