Relational Database Basics
Understand tables, rows, columns, primary keys, foreign keys and relationships.
Read Chapter →
Data & Databases Tutorial
SQL Tutorial
SQL is the language used to define, query and modify data in relational databases. The core concepts transfer across systems, although individual database products may add their own syntax and features.
What You Will Learn
- Create and query relational tables
- Filter and sort data
- Join related tables
- Aggregate and summarize records
- Understand transactions and analytical queries
Prerequisites
- Basic computer usage
- A relational database such as PostgreSQL, MySQL or SQLite for practice
- No programming language required
Course Chapters
SELECT, WHERE and ORDER BY
Read data with projection, filtering, sorting and limiting.
Read Chapter →INSERT, UPDATE and DELETE
Create, modify and remove rows safely.
Read Chapter →SQL Joins
Combine related tables with INNER JOIN and OUTER JOIN patterns.
Read Chapter →GROUP BY and Aggregate Functions
Summarize data with COUNT, SUM, AVG, MIN, MAX, GROUP BY and HAVING.
Read Chapter →Subqueries, Transactions and Window Functions
Move beyond basic CRUD with reusable query patterns and analytical SQL.
Read Chapter →Want Guided Classroom or Mentor-Led Training?
This free tutorial teaches the fundamentals. For structured training, projects and instructor guidance, review the related Mango Engineers course page.
View related course details