Become an SQL Expert.
Starting with the basics, ending at mastery. We've got you covered every step of the way.
Get a Certificate That Means Something.
The Best Learning Environment.
And finally, our Course Material.
-
Chapter 1: Introduction to SQL
Get introduced to SQL by learning how to query Relational Database Tables, using concepts such as SELECT, ORDER BY, WHERE, and BETWEEN.
💻1: Introduction to SQL ... Start learning the most essential data skill.
💻2: SELECT ... SELECT is how we query data.
🧠3: Recall 1
💻4: LIMIT ... Hey, we don't want that many rows!
🧠5: Recall 2
💻6: SELECT... Columns ... Selecting particular columns.
💻7: ORDER BY ... Sorting!
🧠8: Recall 3
💻9: WHERE ... Which rows?
🧠10: Recall 4
💻11: BETWEEN ... Values within a range.
🧠12: Recall 5
💻13: AND / OR ... Logical querying.
🧠14: Recall 6
💻15: LIKE ... Pattern matching.
💻16: NOT / != ... Opposite!
💻17: IN ... Values in a list.
🧠18: Recall 7
💻19: AS ... It can be surprisingly useful to give things different names.
✏️20: Final Assessment
Chapter 2: Grouping and Subqueries
Utilize Advanced Querying techniques using Aggregates, Grouping, and Subqueries. Learn how to combine the results of multiple tables, truly encapturing the Relational Design.
💻1: Aggregate Functions ... They come up everywhere in data.
🧠2: Recall 1
💻3: GROUP BY ... Grouping the rows into bins.
🧠4: Recall 2
💻5: Subqueries ... A query in a query.
💻6: Subquery Practice ... It makes perfect!
🧠7: Recall 3
💻8: HAVING ... Like WHERE, but for groups.
✏️9: Final Assessment
Chapter 3: Joins
Take your SQL to the next level with Inner Joins, Left and Right Joins, and the Full Outer Join. Plus, learn how to deal with missing data and join multiple tables.
💻1: JOIN ... You've likely heard of it.
🧠2: Recall 1
💻3: Join Practice ... Before we get ahead of ourselve's...
🧠4: Recall 2
💻5: Missing Data / NULL Values ... Where'd the data go??
🧠6: Recall 3
💻7: LEFT / RIGHT / FULL OUTER JOIN ... We have 4 join types. Inner is by far the most useful.
🧠8: Recall 4
💻9: Three-way Joins ... You can join as much as you'd like!
✏️10: Final Assessment
Chapter 4: Advanced Selecting
Become an SQL Expert by learning all the tools that the Structured Query Language has to offer, including DISTINCT, CASE, and UNION. Plus, learn about critical SQL concepts such as Primary and Foriegn Key Relationships.
Chapter 5: Creating Relational Databases
Complete your SQL Adventure by learning advanced Database Theory and Design, and use SQL to create your own Real-World Relational Database.
💻1: Real-World Databases ... We're gonna need a bigger DB
💻2: One-to-One, One-to-Many, Many-to-Many ... ANOTHER REALLY REALLY IMPORTANT LESSON!
🧠3: Recall 1
💻4: CREATE TABLE ... Shockingly, it creates a table.
💻5: INSERT INTO ... This is how we add data.
🧠6: Recall 2
💻7: UPDATE... SET ... This is how we modify data.
🧠8: Recall 3
💻9: DELETE FROM / DROP TABLE ... With great power comes great responsibility!
💻10: Bonus! ... TBH you can probably skip this lesson.
✏️11: Final Assessment