Lessons
SQL · Easy
SQL · Easy. Ten lessons. Open-book quizzes. Lesson 1 free.
10 lessons · The Host · Lesson 1 free
Pass all ten lessons for the certificate. Sample · Claim
Lesson 1 · On the house
Primary keys
Unique row identity.
Lesson 2
NOT NULL and UNIQUE
Column constraints.
Lesson 3
Foreign keys
Referential integrity.
Lesson 4
CREATE INDEX
Speed up lookups.
Lesson 5
LEFT vs INNER JOIN
Presence vs match.
Lesson 6
DISTINCT
Unique result rows.
Lesson 7
Subqueries
Queries inside queries.
Lesson 8
Transactions intro
BEGIN, COMMIT, ROLLBACK.
Lesson 9
NULL three-valued logic
Unknown is not false.
Lesson 10
Views
Saved queries.
Sample certificate
Certificate of completion
Sign in to claim your certificate of completion.
Certificate
Finish all ten lessons, then sign in
Pass every lesson on this device (quizzes and checks). Then sign in or create an account to type your name and download the JPG.