Work & Development · Backend & Full Stack Development

SQL and Relational Data

Build a small resource directory with related tables and clear database queries.

Level: Intermediate
Lessons: 9 lessons in 3 modules
Estimated study: About 24 hours
Format: Online, self-paced

Start your free 3-day trial Read lesson 1 free Already a student? Open course

Monthly: $0 today with a card, then $34 on day 4 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.

Before you start

Recommended preparation:

Server Applications with Node.js

Use a computer with a keyboard and a current browser. Individual lessons explain the tools needed for each exercise.

Full study requires active Academy access. This course can be audited independently of optional assessed programs.

About this course

Learn to store related facts in tables and ask questions with SQL, the language used to work with a database. Practice with invented records, then connect the database to a small 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

Separate facts into tables. Give each row an ID and add rules that protect the data.

Model a directory with tables and primary keys2 h 40 minFree preview
Turn data rules into constraints2 h 40 min
Enforce relationships and choose deletion behavior2 h 40 min

Find, combine and count records. Check missing values and the order of your results.

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

Keep user input separate from SQL instructions. Save related changes together and connect the database to an API.

Bind values instead of constructing SQL text2 h 40 min
Apply a small migration and an atomic update2 h 40 min
Connect the directory API to persistent relational data2 h 40 min

Related assessed programs

This course belongs to the following optional programs. Each has its own required course bundle, evidence review and separate fee. Each program page shows its approved fee and current registration status.