Clear, practical technology insights
TipsMake Learning
Explore TipsMake guides
Learning Library
Build practical programming and technology skills

SQL and Relational Databases

Design a relational schema, write reliable queries, update data safely, use transactions, and diagnose common correctness and performance problems.

View curriculum
FoundationDifficulty
30 hoursEstimated time
8 modules32 lessons
5 guided labsKnowledge check
00
Plan your learning

Path Brief

Skills you will practice

  • Core · Sql Relational Databases
  • Core · Relational Database Foundations
  • Core · Retrieve Data
  • Core · Combine And Summarize Data
  • Core · Insert Update And Delete Safely
  • Core · Schema Design

Prerequisites

  • No prior experience is required; basic computer and file-management skills are helpful.

Tools

  • A current web browser
  • A code editor or terminal appropriate to the path
  • A safe local or virtual lab environment
01
Before you begin

What you need

  • No prior experience is required; basic computer and file-management skills are helpful.
02
Step-by-step curriculum

Learning modules

Complete lessons in order or open the module that matches your current goal. Your lesson progress is saved on this device.

01Relational Database FoundationsBuild practical skill in relational database foundations and connect it to the outcomes of SQL and Relational Databases.4 lessons · 1 lab
Module checkpointRelational Database Foundations checkpoint
1Which exercise best practices the actual skill taught in Relational Database Foundations in SQL and Relational Databases?
2Which diagnostic action is relevant when Relational Database Foundations in SQL and Relational Databases does not behave as expected?
3Which statement is a core idea you need to understand for Relational Database Foundations in SQL and Relational Databases?
02Retrieve DataBuild practical skill in retrieve data and connect it to the outcomes of SQL and Relational Databases.4 lessons · 1 lab
Module checkpointRetrieve Data checkpoint
1Which diagnostic action is relevant when Retrieve Data in SQL and Relational Databases does not behave as expected?
2Which statement is a core idea you need to understand for Retrieve Data in SQL and Relational Databases?
3Which setup step belongs directly to Retrieve Data in SQL and Relational Databases?
03Combine and Summarize DataBuild practical skill in combine and summarize data and connect it to the outcomes of SQL and Relational Databases.4 lessons · 1 lab
Module checkpointCombine and Summarize Data checkpoint
1Which diagnostic action is relevant when Combine and Summarize Data in SQL and Relational Databases does not behave as expected?
2Which statement is a core idea you need to understand for Combine and Summarize Data in SQL and Relational Databases?
3Which setup step belongs directly to Combine and Summarize Data in SQL and Relational Databases?
04Insert, Update, and Delete SafelyBuild practical skill in insert, update, and delete safely and connect it to the outcomes of SQL and Relational Databases.4 lessons · 1 lab
Module checkpointInsert, Update, and Delete Safely checkpoint
1Which statement is a core idea you need to understand for Insert, Update, and Delete Safely in SQL and Relational Databases?
2Which setup step belongs directly to Insert, Update, and Delete Safely in SQL and Relational Databases?
3Which exercise best practices the actual skill taught in Insert, Update, and Delete Safely in SQL and Relational Databases?
05Schema DesignBuild practical skill in schema design and connect it to the outcomes of SQL and Relational Databases.4 lessons · 1 lab
Module checkpointSchema Design checkpoint
1Which statement is a core idea you need to understand for Schema Design in SQL and Relational Databases?
2Which setup step belongs directly to Schema Design in SQL and Relational Databases?
3Which exercise best practices the actual skill taught in Schema Design in SQL and Relational Databases?
06Transactions and ConcurrencyBuild practical skill in transactions and concurrency and connect it to the outcomes of SQL and Relational Databases.4 lessons
Module checkpointTransactions and Concurrency checkpoint
1Which setup step belongs directly to Transactions and Concurrency in SQL and Relational Databases?
2Which exercise best practices the actual skill taught in Transactions and Concurrency in SQL and Relational Databases?
3Which diagnostic action is relevant when Transactions and Concurrency in SQL and Relational Databases does not behave as expected?
07Indexes and Query PerformanceBuild practical skill in indexes and query performance and connect it to the outcomes of SQL and Relational Databases.4 lessons
Module checkpointIndexes and Query Performance checkpoint
1Which statement is a core idea you need to understand for Indexes and Query Performance in SQL and Relational Databases?
2Which setup step belongs directly to Indexes and Query Performance in SQL and Relational Databases?
3Which exercise best practices the actual skill taught in Indexes and Query Performance in SQL and Relational Databases?
08Application Database PracticesBuild practical skill in application database practices and connect it to the outcomes of SQL and Relational Databases.4 lessons
Module checkpointApplication Database Practices checkpoint
1Which setup step belongs directly to Application Database Practices in SQL and Relational Databases?
2Which exercise best practices the actual skill taught in Application Database Practices in SQL and Relational Databases?
3Which diagnostic action is relevant when Application Database Practices in SQL and Relational Databases does not behave as expected?
03
Portfolio integration

Capstone Project

Build a Database for a Service Business

Combine the path skills in a portfolio-ready project with clear functional requirements, tests, verification evidence, and operating notes.

GuidedIndependentPortfolio

Acceptance criteria

  • The core workflow works from start to finish.
  • Invalid input or failure states are handled clearly.
  • The result is tested and documented.
  • A reviewer can reproduce the setup and verification.
03
Knowledge check

Test your understanding

Answer all questions. Results and explanations are calculated instantly in your browser.

1Path review for SQL and Relational Databases: Which statement is a core idea you need to understand for Relational Database Foundations in SQL and Relational Databases?
2Path review for SQL and Relational Databases: Which setup step belongs directly to Retrieve Data in SQL and Relational Databases?
3Path review for SQL and Relational Databases: Which exercise best practices the actual skill taught in Combine and Summarize Data in SQL and Relational Databases?
4Path review for SQL and Relational Databases: Which diagnostic action is relevant when Insert, Update, and Delete Safely in SQL and Relational Databases does not behave as expected?
5Path review for SQL and Relational Databases: Which statement is a core idea you need to understand for Schema Design in SQL and Relational Databases?
04
Continue in Programming

Related Programming

Skill assessment

Check your starting point

Use practical questions to identify prerequisite skills and a recommended module.

Open resources Project library

Plan the capstone

Review project expectations, verification evidence, and portfolio requirements.

Open resources Programming Hub

Explore related paths

Compare career tracks, languages, technologies, and recommended next steps.

Open resources