Skip to content

Developing Work Skills · Career & Development

SQL and Relational Data

Model, query, and connect a fictional relational resource directory.

Level
Intermediate
Estimated study
About 24 hours
Lessons
9 lessons in 3 modules
Format
Online, self-paced
Start your free 7-day trialAlready a student? Open course

Monthly: $0 today with a card, then $34 on day 8 unless you cancel before then. After the trial, 30 days' notice applies. Active on-campus students have academy access included. Check your existing student account before buying another subscription.

About this course

Model related information and retrieve it with SQL. Practice database work using fictional data, then connect a small data model to your server application.

What you will be able to do

  • Design related tables with keys and useful constraints.
  • Write queries with filtering, joins and aggregates.
  • Use parameterized queries and explain a transaction.

Course outline

Module 1: Model related information

3 lessons · 8 h

Choose tables, relationships, primary keys and constraints.

  1. Model a directory with tables and primary keys2 h 40 min
  2. Turn data rules into constraints2 h 40 min
  3. Enforce relationships and choose deletion behavior2 h 40 min

Module 2: Query and summarize

3 lessons · 8 h

Practice selection, joins, grouping and aggregation with fictional records.

  1. Ask precise questions with SELECT2 h 40 min
  2. Combine related information with joins2 h 40 min
  3. Summarize the directory without inflated counts2 h 40 min

Module 3: Connect data to an API

3 lessons · 8 h

Use parameterized queries, migrations and a small transaction.

  1. Bind values instead of constructing SQL text2 h 40 min
  2. Apply a small migration and an atomic update2 h 40 min
  3. Connect the directory API to persistent relational data2 h 40 min
Get helpStart 7-day trial