Certificate in SQL

• Course Overview and Learning Expectations
• Introduction to SQL and Databases
• Understanding SQL
• Understanding Relational Database Management Systems
• Understanding Database Tables
• Common SQL Rules and Conventions
• Overview of Popular Database Systems
• Understanding SQL Data Types
• Understanding SQL Operators
• Understanding Records and Rows
• Understanding Fields and Columns
• Understanding Database Keys
• Overview of SQL Structure

• Creating a New Database
• Creating Database Tables
• Inserting Data into Tables
• Using the SELECT Statement
• Filtering Data with the WHERE Clause
• Using Conjunctive Operators
• Intermediate SQL Concepts
• Using the LIKE Clause
• Using the TOP Clause
• Working with Additional Database Keys
• Retrieving Unique Records
• Sorting Query Results
• Understanding Database Normal Forms

• Introduction to SQL Practice Exercises
• SQL Practice Exercise 1.1
• SQL Practice Exercise 1.2
• SQL Practice Exercise 1.3
• SQL Practice Exercise 1.4
• SQL Practice Exercise 1.5
• SQL Practice Exercise 1.6
• SQL Practice Exercise 1.7
• SQL Practice Exercise 1.8
• SQL Practice Exercise 1.9
• SQL Practice Exercise 1.10

• SQL Practice Exercise 2.1
• SQL Practice Exercise 2.2
• SQL Practice Exercise 2.3
• SQL Practice Exercise 2.4
• SQL Practice Exercise 2.5
• SQL Practice Exercise 2.6
• SQL Practice Exercise 2.7
• SQL Practice Exercise 2.8
• SQL Practice Exercise 2.9
• SQL Practice Exercise 2.10

• SQL Practice Exercise 3.1
• SQL Practice Exercise 3.2
• SQL Practice Exercise 3.3
• SQL Practice Exercise 3.4
• SQL Practice Exercise 3.5
• SQL Practice Exercise 3.6
• SQL Practice Exercise 3.7
• SQL Practice Exercise 3.8
• SQL Practice Exercise 3.9
• SQL Practice Exercise 3.10

• SQL Practice Exercise 4.1
• SQL Practice Exercise 4.2
• SQL Practice Exercise 4.3
• SQL Practice Exercise 4.4
• SQL Practice Exercise 4.5
• SQL Practice Exercise 4.6
• SQL Practice Exercise 4.7
• SQL Practice Exercise 4.8
• SQL Practice Exercise 4.9
• SQL Practice Exercise 4.10

• SQL Practice Exercise 5.1
• SQL Practice Exercise 5.2
• SQL Practice Exercise 5.3
• SQL Practice Exercise 5.4
• SQL Practice Exercise 5.5
• SQL Practice Exercise 5.6
• SQL Practice Exercise 5.7
• SQL Practice Exercise 5.8
• SQL Practice Exercise 5.9
• SQL Practice Exercise 5.10
• SQL Course Review
• Final Course Message

Yes, and everything you need is free. The demonstrations use Microsoft SQL Server with SQL Server Management Studio, and the course walks through the setup. You can follow along in another database if you prefer, and the notes flag the handful of places where the syntax differs.

The basics are friendlier than most people expect. Queries read almost like English, and because every lesson has you writing them, they stick.

The core of SQL is the same everywhere, and that core is what you learn. The demonstrations are in Microsoft SQL Server, so a few things are Microsoft-specific: TOP is the clearest example, where MySQL and PostgreSQL use LIMIT instead. The notes say so wherever it comes up.

Advanced SQL, which picks up exactly where this stops: outer joins, subqueries, indexes, transactions and window functions. Or Power BI, if your next step is dashboards. Both build directly on what you learn here.

Seven modules and 79 lessons, around 27 hours of video, with written notes on every lesson and 40 interactive questions along the way. There are seven checkpoints of eight questions and a 20-question final assessment, and passing the final earns the certificate. Modules three to seven are five sets of practice exercises, so most of the course is you writing SQL rather than watching somebody else write it.

For life. You pay once, keep lifetime access, and there is no subscription. There is also a 7-day money-back guarantee if it turns out not to fit.