Pre-reading builds a framework — so learning actually sticks

Read ~27m
15 terms · 29 segments

SQL Tutorial for Beginners (Complete Course using MySQL)

CodeWithHarryData-Science
29chapters with key takeaways — read first, then watch
1

Introduction and Importance of SQL Course

0:00-2:41•2m 41sIntro
2

What is a Database and Why Use It

2:42-6:54•4m 12sIntro
3

Introduction to DBMS, RDBMS, and NoSQL Databases

6:55-9:12•2m 17sIntro
4

MySQL Installation Guide (Windows, Linux, Mac)

9:13-18:09•8m 56sData Prep
5

Creating a Database and Understanding Schema

18:09-23:14•5m 5sData Prep
6

Creating Tables and Data Types & Constraints

23:14-29:14•6mData Prep
7

Deleting Databases and Using SQL Scripts

29:14-32:44•3m 30sData Prep
8

Detailed Explanation of Data Types and Constraints

32:44-37:51•5m 7sData Prep
9

Renaming Tables and Modifying Columns

37:51-48:29•10m 38sData Prep
10

Inserting Data (CRUD - Create)

48:29-57:36•9m 7sData Prep
11

Setting Up Sample Data for Practice

57:36-1:00:15•2m 39sData Prep
12

Querying Data: WHERE Clause and Operators

1:00:15-1:11:28•11m 13sAnalysis
13

Updating Data (CRUD - Update)

1:11:28-1:18:07•6m 39sAnalysis
14

Deleting Data and Dropping Tables (CRUD - Delete)

1:18:07-1:24:17•6m 10sAnalysis
15

Detailed Explanation of MySQL Constraints

1:24:17-1:35:19•11m 2sData Prep
16

SQL Functions: Aggregate, String, Date/Time, Mathematical

1:35:19-1:48:16•12m 57sAnalysis
17

Auto Commit and Transactions (Rollback/Commit)

1:48:16-1:58:00•9m 44sMethodology
18

In-depth Analysis of Primary Key

1:58:00-2:04:08•6m 8sAnalysis
19

Foreign Keys and Table Relationships

2:04:08-2:17:56•13m 48sAnalysis
20

SQL Joins: Inner, Left, Right

2:17:56-2:28:09•10m 13sAnalysis
21

UNION and UNION ALL Operators

2:28:09-2:38:28•10m 19sAnalysis
22

Self Joins: Referral-Based Relationships

2:38:28-2:47:31•9m 3sAnalysis
23

MySQL Views: Virtual Tables

2:47:31-2:57:14•9m 43sAnalysis
24

Indexes for Performance Optimization

2:57:14-3:06:52•9m 38sMethodology
25

Subqueries: Using Nested Queries

3:06:52-3:13:54•7m 2sAnalysis
26

GROUP BY, HAVING and ROLLUP

3:13:54-3:24:00•10m 6sAnalysis
27

Stored Procedures: Reusable SQL Blocks

3:24:00-3:35:46•11m 46sMethodology
28

Triggers: Event-Based Automated Actions

3:35:46-3:46:43•10m 57sMethodology
29

Advanced SQL Features and AI Integration

3:46:43-3:57:54•11m 11sAnalysis

Video Details & AI Summary

Published Jul 13, 2025
Analyzed Jan 29, 2026

AI Analysis Summary

This video is a comprehensive SQL tutorial for beginners using MySQL. It starts with the fundamentals of databases and DBMS, then deeply covers data types, constraints, and CRUD (Create, Read, Update, Delete) operations. The course also includes advanced SQL concepts such as Joins, Union, Self-Joins, Views, Indexes, Subqueries, Group By, Stored Procedures, and Triggers, along with tips for enhancing SQL skills using AI tools.

Title Accuracy Score
10/10Excellent
Model:gemini-2.5-flash

Original Video

Watch on YouTubeView channel on YouTube