Prepstellar
Get the app

SQL

SQL Fundamentals

37 lessons · 9 domains · Narrated

Get the app Read the first lessons free Free final test

A full course on SQL: written lessons covering foundations, joins and relational composition, aggregation, subqueries, data definition and integrity, transactions and concurrency, and views, indexes, and query plans, narrated audio for every concept, practice questions with explanations, and mock exams. Every statement traces back to current PostgreSQL documentation.

What you'll learn

  • Getting started
  • SQL Foundations
  • Joins and Relational Composition
  • Aggregation and Analytical Calculations
  • Subqueries and Reusable Query Logic
  • Data Definition and Integrity
  • Transactions and Concurrency
  • Views, Indexes, and Query Plans
  • Advanced SQL and PostgreSQL Extensions

The course

01 SQL and PostgreSQL Basics 19 cards · 7 quick checks Lesson → Test →
02 Database Structure and Core Vocabulary 17 cards · 7 quick checks Lesson → Test →
03 A SQL Workflow from Connection to Result 18 cards · 7 quick checks Lesson → Test →
04 What You Will Learn in This SQL Course 19 cards · 7 quick checks Lesson → Test →
05 Relational Model and SQL 20 cards · 9 quick checks Lesson → Test →
06 SQL Lexical Structure 19 cards · 9 quick checks Lesson → Test →
07 Values, Types, and Expressions 25 cards · 11 quick checks Lesson → Test →

The remaining 30 lessons are in the app.

All practice sets

Mock exam

Final test · 25 questions · Free SQL Fundamentals final test 25 questions from the whole course. Untimed here; timed and scored in the app.

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get the app