Learn Coding
SQL and Database Design
Data Dan
Database Administrator
Published
Feb 06, 2026
Master the language for managing and querying relational databases.
What You'll Learn
1
Introduction to Relational Databases
Learn about tables, rows, columns, and the relational model.
2
Basic SQL Queries (SELECT)
Master the art of retrieving data from a database with filters and sorting.
3
Data Manipulation (INSERT, UPDATE, DELETE)
Learn how to modify the data stored in your tables.
4
Joins and Relationships
Master Inner, Left, Right, and Full Joins to combine data from multiple tables.
5
Aggregate Functions and Grouping
Learn how to perform calculations on your data using SUM, AVG, and GROUP BY.
6
Database Normalization
Learn the principles of designing efficient and non-redundant database schemas.
7
Indexes and Performance
Discover how to speed up your queries using database indexes.
8
Subqueries and Common Table Expressions
Master advanced techniques for writing complex and readable SQL.
9
Transactions and Concurrency
Learn how to ensure data integrity using SQL transactions.
10
Database Security and Permissions
A guide to protecting your data and managing user access.