SQL FOR DATA ANALYTICS
Introducing...
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 THIS COURSE
Introduction (7 video lessons)
In this module, we use7 video lessonsto 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 themany lucrative career opportunitiesavailable from learning programming skills.
Selecting Data (7 video lessons)
In this module, we use7 video lessonsto explain how data is streamlined, connected, and stored in SQL using relational databases. We wrap up this module by learning thefoundational code outlineSELECT...FROM that is integral to start coding.
Conditional Statements (7 video lessons)
In this module, we use7 video lessonsto expand on our foundational code outline by learning new conditional modifiers that allow us to filter our data bse. This module includes astep-by-step walkthrough and applicationusing a company's sales data.
Using Common Keywords (8 video lessons)
In this module, we use8 video lessonsto help explain several advanced data filtering and arithmetic techniques such as Distinct, Order by, and Count. This module also includes severalbenchmarking exercises确保你保持应用的视频解决方案ing until you are very productive...
Combining Tables (8 video lessons, 2 challenges)
In this module, we use8 video lessonsto explore linking data across multiple data tables as well as using the left function to splice strings. This module also includes twochallenging exercises with video solutions that test your knowledgeof SQL so far...
Filtering Data (8 video lessons, 3 challenges)
In this module, we use8 video lessonsto go over the final filtering function we need to know: Having. We wrap up this module withguided walkthroughs of three challenging exercisesthat summate all the different skills we have learned in the course.
Temporary Tables (4 video lessons, 1 challenge)
In this module, we use4 video lessonsto explore temporary tables and how they are useful in modifying linked data tables. This module also includes acapstone challengethat will surely test if you are a SQL pro...
WSO SQL for Data Analytics Course - Video Preview
Course Summary - Table of Contents
Below you will find a list of the modules and lessons included in this course.
- SQL Intro (1 Min)
- Intro to Databases (5 Min)
- What is SQL (4 Min)
- Why do we need to know SQL (3 Min)
- The required course resources (5 Min)
- Downloading MySQL (1 Min)
- Downloading the text editor and GUI (2 Min)
- Relational databases (5 Min)
- Uploading our database (4 Min)
- Introduction to the GUI (6 Min)
- The basic SQL outline (1 Min)
- SELECT FROM pt. I (3 Min)
- SELECT FROM pt. II (5 Min)
- SELECT FROM pt. III (6 Min)
- Intro to WHERE (4 Min)
- Utilizing WHERE (3 Min)
- Intro to AND OR (3 Min)
- Utilizing AND OR (4 Min)
- Intro to IN (2 Min)
- Using IN (3 Min)
- Pulling in ranges of data with BETWEEN (4 Min)
- Pulling unique values with DISTINCT pt. I (3 Min)
- Pulling unique values with DISTINCT pt. II (2 Min)
- Ordering our data with ORDER BY pt. I (5 Min)
- Ordering our data with ORDER BY pt. II (3 Min)
- Arithmetic Functions MIN MAX (5 Min)
- Arithmetic Functions COUNT SUM AVG (7 Min)
- Grouping our data with GROUP BY pt. I (3 Min)
- Grouping our data with GROUP BY pt. II (4 Min)
- Intro to connecting our tables (3 Min)
- How to join our tables (5 Min)
- Example of joining tables together (6 Min)
- Challenge 1 - Joining tables (3 Min)
- Challenge 1 - Joining tables (solution) (4 Min)
- Extracting data using LEFT (6 Min)
- Challenge 2 - LEFT MAX Joining Tables (3 Min)
- Challenge 2 - LEFT MAX Joining Tables (solution) (5 Min)
- Intro to utilizing HAVING (3 Min)
- Applying the HAVING clause (6 Min)
- Challenge 3 - HAVING (4 Min)
- Challenge 3 - HAVING (solution) (5 Min)
- Challenge 4 - GROUPING on multiple items (2 Min)
- Challenge 4 - GROUPING on multiple items (solution) (3 Min)
- Challenge 5 - Filting using WHERE (3 Min)
- Challenge 5 - Filting using WHERE (solution) (3 Min)
- Creating temporary tables pt. I (8 Min)
- Creating temporary tables pt. II (4 Min)
- Challenge 6 - Temporary Tables (2 Min)
- Challenge 6 - Temporary Tables (solution) (6 Min)
- Conclusion (1 Min)
- SQL Outro (1 Min)
我们的学生登陆和蓬勃发展的位置across all top Wall Street firms, including:
Don’t Take Our Word For It
Hear from a few of our57,000+ students...
Hear from a few of our57,000+ students...
In my last role, it was the first time that I have been exposed to larger databases in Oracle and VBA, and nowrealized through the course that a foundation in SQL would have made my life so much easier.I honestly found the course very helpful and well structured and I feel quite well prepared and comfortable to use SQL to retrieve data from databases through queries now. I think that the course will definitely help me in case I need to work with databases again in the future, which is highly likely due to thegrowing importance of large amounts of data and SQL being at the backbone of retrieving data efficiently.
Get the SQL for Data Analytics Course Certification
After completing the course, all students will be granted the WSO SQL for Data Analytics Course Certification. Use this certificate as a signal to employers that you have the technical SQL coding skills to immediately add value to your team.
Demonstrate that you have put in the work outside of university courses to make yourself more efficient and master the most critical program for success in finance careers. Easily share to LinkedIn and other social media sites to highlight your skills and strengthen your profile as a candidate.
How Much is Your
Finance Career Worth?
What You Get |
Value |
---|---|
WSO SQL for Data Analytics Course 50+ video lessons across 8 Modules taught by an expert Big 4 Auditor with a CPA... |
$500 |
6 Coding Challenges Gain realistic practice drilling the concepts taught in the course so that you can apply them in the real world. |
$450 |
24 Months of Unlimited Elite Support from Actual Finance Pros Have a technical question? Easily drop a comment into any lesson and get a response from a pro within 48hrs. |
$300 |
TOTAL VALUE |
$1,250 |
Get Unlimited Lifetime Access To The WSO SQL for Data Analytics Course For 93% Off
$1,250
$97
...or get access today for only $37
Secure checkout
100% Unconditional Money-Back Guarantee
12 Month Risk-Free Guarantee
Your investment is protected by our 12-Month Risk-Free Guarantee. If, for any reason, you don't think the WSO SQL for Data Analytics Course is right for you, just send us an email, and we'll refund every penny. No questions asked.In short, you get a great return on your investment, or you get your money back.It's that simple.