Databases & SQL curriculum & tutors

Computer Science

A project-based relational database course covering querying, joins, schema design, normalization, constraints, transactions, views, indexes, query plans, application integration, and scaling.

7 public curriculum units1 tutor availableAlways Free
Introductory relational databases / SQL

Databases & SQL curriculum

A project-based relational database course covering querying, joins, schema design, normalization, constraints, transactions, views, indexes, query plans, application integration, and scaling.

Pacing
7 units, 12-22 weeks self-paced
Units
7 unit sequence
Practice
560 checked answers
Support
Self-paced or tutor-guided
Outcomes
  • Write correct SQL queries and explain their relational meaning.
  • Design normalized schemas with explicit keys, constraints, and transaction boundaries.
  • Use query plans, indexes, tests, and data-integrity checks before attempting scale.

Video companion links

Use these linked courses for video instruction and mastery practice, then return here for PeerTutor original checks and tutor help on the exact unit that got stuck.

External video content is linked or embedded through provider-hosted players, not copied. PeerTutor practice is original and cites each source path separately.

Unit sequence

Built for independent progress first, then tutor support where the student gets stuck.

View full curriculum
  1. 01

    Querying relational data

    • Use SELECT, filtering, sorting, expressions, aggregates, grouping, and null semantics.
    • Translate questions into deterministic queries.

    Practice: Answer a dataset question set and explain the row set produced at each query stage.

  2. 02

    Relating tables with joins

    • Use primary and foreign keys plus inner, outer, cross, and self joins.
    • Detect duplicate amplification and missing relationships.

    Practice: Build a multi-table report and prove its row counts with intermediate checks.

  3. 03

    Schema design and normalization

    • Model entities, relationships, cardinality, types, constraints, and normal forms.
    • Separate facts to prevent update anomalies.

    Practice: Turn a messy spreadsheet into a normalized schema with an ER diagram and written invariants.

  4. 04

    Writing and transactions

    • Use INSERT, UPDATE, DELETE, upserts, transactions, isolation concepts, and rollback.
    • Preserve invariants under failure and concurrency.

    Practice: Implement a multi-step write transaction and test success, validation failure, and rollback behavior.

Need the complete source list and remaining units? Open the full Databases & SQL curriculum.

STEM, coding, and test-prep tutor support

Free

Nikhil supports students working through the public STEM, coding, and test-prep curriculum. Sessions focus on diagnosing the exact gap, working probl…

Pre-AlgebraAlgebraPrecalculusAP Precalculus+2 more
4 yrs experience Online

Ready to work through Databases & SQL?

Start with the public curriculum. If a unit stalls, get targeted one-on-one support from a tutor.