Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn SQL comprehensively in this 3.5-hour tutorial using MySQL, complete with free downloadable notes. Master database fundamentals, including types of databases and RDBMS concepts, before diving into SQL essentials. The tutorial covers MySQL installation, data types, and all major SQL components: DDL, DML, DCL, TCL, and DQL. Progress through practical topics like Order By, Group By, Having clauses, SQL functions, subqueries, and various types of joins. Advanced concepts include keys, constraints, views, indexes, and stored procedures—providing everything needed to become proficient in SQL from scratch.
Syllabus
0:00 Introduction
02:40 Database
06:20 Types of Databases
08:30 RDBMS
10:23 SQL Introduction
17:18 Installation of MySQL
25:43 SQL DataTypes
34:55 DDL
55:09 DML
01:08:38 DCL
01:15:11 TCL
01:24:15 DQL
01:30:04 Order By, Group By and Having
01:44:43 SQL Functions and Subquery
02:03:29 SQL Joins
02:32:38 SQL Keys and Constraints
03:00:16 SQL View
03:06:49 SQL Index
03:14:25 Stored Procedure in SQL
Taught by
5 Minutes Engineering