SQL - Database Programming

This beginner course introduces database management basics and SQL using MySQL. It covers schema design, CRUD operations, aggregation, nested queries, joins, keys, and related topics.

Syllabus

Introduction | SQL | Tutorial 1.
What is a Database? | Let's Learn.
Tables & Keys | SQL | Tutorial 2.
SQL Basics | SQL | Tutorial 3.
MySQL Windows Installation | SQL | Tutorial 4.
MySQL Mac Installation | SQL | Tutorial 5.
Creating Tables - SQL - Tutorial 6.
Inserting Data - SQL - Tutorial 7.
Constraints - SQL - Tutorial 8.
Update & Delete | SQL | Tutorial 9.
Basic Queries | SQL | Tutorial 10.
Company Database Intro | SQL | Tutorial 11.
Creating Company Database | SQL | Tutorial 12.
More Basic Queries | SQL | Tutorial 13.
Functions | SQL | Tutorial 14.
WIldcards | SQL | Tutorial 15.
Union | SQL | Tutorial 16.
Joins | SQL | Tutorial 17.
Nested Queries | SQL | Tutorial 18.
On Delete | SQL | Tutorial 19.
Triggers | SQL | Tutorial 20.
ER Diagrams Intro | SQL | Tutorial 21.
Designing an ER Diagram | SQL | Tutorial 22.
Converting ER Diagrams to Schemas | SQL | Tutorial 23.