Why Learn SQL?
The most important skill to master
I asked my network of 100k+ on LinkedIn what skill or tool Data Scientists & Analysts should learn first. SQL was by far the most popular answer, with more than 2x the votes of Python
The most in-demand tool
I asked 200+ hiring managers, recruiters, and leaders in the field "does your team utilize SQL?" and 97% said yes. SQL is in high-demand, and this will only continue to grow in the future
What Makes This Course Different?
Full Curriculum
- Welcome to SQL For Data Science & Analytics! (2:56)
- Join The SQL For Data Science & Analytics Slack Community!
- Share Your Journey
- What Is SQL And How Does It Work? (11:16)
- 3 Ways To Code SQL On The Course! (1:25)
- Getting Setup With SQL Workbench/J - Check Your Java Version (4:54)
- Getting Setup With SQL Workbench/J - Installation (14:12)
- Getting Setup With SQL Workbench/J - Take A Look Around (7:35)
- The DSI In-Browser SQL Editor (4:47)
- The Journey Into Data Science & Analytics
- The SELECT statement (PRACTICAL) (9:55)
- The SELECT Statement (Test Yourself)
- Applying selection conditions using the WHERE statement (PRACTICAL) (8:52)
- The WHERE Statement (Test Yourself)
- Aggregation functions and the GROUP BY statement (PRACTICAL) (10:08)
- Aggregation functions and the GROUP BY statement (Test Yourself)
- Conditional rules using CASE WHEN (PRACTICAL) (9:17)
- Conditional rules using CASE WHEN (Test Yourself)
- The use of WINDOW functions (PRACTICAL) (12:29)
- The use of WINDOW functions (Test Yourself)
- Joining tables using JOIN (PRACTICAL) (19:52)
- Joining tables using JOIN (Test Yourself)
- Stacking data using UNION and UNION ALL (PRACTICAL) (4:48)
- Executing multiple queries using TEMP TABLES and CTE (10:08)
- Executing multiple queries using TEMP TABLES and CTE (Test Yourself)
- Tips & Tricks 01 - Sub-Queries (Practical) (4:30)
- Tips & Tricks 02 - Using Lag & Lead (Practical) (7:01)
- Tips & Tricks 03 - Rounding Numeric Data (Practical) (2:10)
- Tips & Tricks 04 - Selecting Random Samples (Practical) (1:50)
- Tips & Tricks 05 - Working With Dates (Practical) (3:32)
- Tips & Tricks 06 - Working with Text (Practical) (4:48)
- Content Creator SQL Challenge 01: Dave Langer
- Content Creator SQL Challenge 02: Chris Perry
- Content Creator SQL Challenge 03: [Coming Soon]
- Content Creator SQL Challenge 04: [Coming Soon]
- Content Creator SQL Challenge 05: [Coming Soon]
- Content Creator SQL Challenge 06: [Coming Soon]
- Content Creator SQL Challenge 07: [Coming Soon]
- Content Creator SQL Challenge 08: [Coming Soon]
- Content Creator SQL Challenge 09: [Coming Soon]
- Content Creator SQL Challenge 10: [Coming Soon]
Modules & Benefits
Intro & Setup
Let's familiarize you with SQL, run through what it can do, and get you set up for learning & applying this amazing & powerful language!
Supportive Community
Join the community of learners to network, share successes, take on weekly challenges, and get expert support when you need it!
Get Coding!
Learn about & apply the most powerful SQL concepts for a successful career in Data Science & Analytics (+ challenges to hone your skills)
Real World SQL Tests
Get ahead of the competition! Take on 3x real-world SQL tests covering the most common interview questions (+ full video solutions)
Content Creator Challenges
Hone your skills even further with dedicated SQL challenges from your favourite SQL content creators (solutions provided)
Downloadable Resources
Learn on the go with the suite of downloadable learning resources, documents, and cheat-sheats to propel you on your SQL journey!
Meet Your Instructor
Hi, I'm Andrew - creator & lead instructor at Data Science Infinity.
My career spans 15+ years in Data Science & Analytics at companies including Amazon & Sony PlayStation.
I've interviewed & screened hundreds of Data Science candidates, and through this process have learned exactly what can differentiate a stand out & successful candidate from the rest.
I authored "The Essential A.I. & Data Science Handbook for Recruitment" which is available on Amazon, and have 6 Machine Learning patents to my name.
Now, my passion is teaching, and more specifically, helping thousands of students just like you, reach their potential and their goals in this exciting, future-proof, and lucrative field.
Support, Networking, & Challenges in the Private Group
Content Creator Challenges [ Coming Soon! ]
Prove Your Skills With The Certification
FAQs
What prerequisite knowledge, skills, or tools are required?
Basic knowledge of data & datasets. A modern laptop or computer (Windows or Mac) with internet connectivity
How long do I get access for?
You get unlimited access to all course materials
Are there quizzes to test my knowledge?
Yes, each concept is followed by a challenge to test your skills. There are also 3x real-world SQL tests + extra challenges from your favourite content creators!
Are there extra costs associated with this course?
No, your joining fee is a one time payment - that is all you will pay for lifetime access. We also use free & open-source software to connect to the data, and to code in.