SQL Complete Course: Introduction to Databases and SQL

Start SQL from zero with deep, conceptually strong lessons on database fundamentals, MySQL basics, ER design, keys, architecture, and real-world industry examples.

10h 18m

22 lessons

1k+ enrolled

beginnerFree

Course Access

Free

Your Progress

Completed Lessons0 / 22

0% Complete

Course Content

22 lessons • 10h 18m total duration

What is Data? Raw Facts, Types and the Data Lifecycle Explained

25m

What is a Database? Flat File vs Relational Database Explained

28m

Types of Databases: Relational, NoSQL, Hierarchical, Network and Cloud

30m

DBMS vs RDBMS: Features, Key Differences and Real Examples

30m

Introduction to MySQL: Server, Workbench, CLI, and First SQL Commands

35m

What is SQL? History, Purpose, Importance and How It Works

25m

SQL Sub-Languages: DDL, DML, DCL, TCL and DQL with Examples

35m

Keys in Database: Primary, Foreign, Candidate, Composite and Super Key

35m

Entity Relationship Model: Entities, Attributes, Relationships and ER Diagrams

35m

DBMS Architecture: 1-Tier, 2-Tier and 3-Tier Explained with Examples

30m

Real-World Database Use Cases: Netflix, Amazon, Zomato and Beyond

30m

SQL Data Types in MySQL: INT, VARCHAR, DATE, BOOLEAN, ENUM Explained

30m

CREATE DATABASE in MySQL: Syntax, Character Set, and Collation Explained

22m

CREATE TABLE in SQL: Column Definitions and Constraints Explained

28m

PRIMARY KEY and AUTO_INCREMENT in SQL: Single and Composite Keys Explained

25m

FOREIGN KEY in SQL: Referential Integrity, ON DELETE CASCADE, and ON UPDATE

28m

ALTER TABLE in SQL: ADD, DROP, MODIFY, and RENAME Column or Table

26m

DROP TABLE vs TRUNCATE TABLE vs DELETE: Differences and When to Use Each

24m

RENAME TABLE in MySQL: Syntax and Practical Examples

18m

SHOW TABLES and DESCRIBE in MySQL: Inspecting Database Structure

18m

SQL Constraints: All 6 Types Explained with MySQL Syntax Examples

26m

Practical Exercise: Design a 3-Table Student Management Database Schema

35m