Complete MySQL for Beginners 2026 (Zero to Confidence)

In this lecture, we'll start working practically with MySQL databases and tables.

We'll learn how to create and manage tables, insert records, and retrieve information using SQL queries.

Topics covered:

1. Creating a database using CREATE DATABASE.

2. Selecting a database using USE.

3. Creating tables using CREATE TABLE.

4. Understanding table structure and columns.

5. Working with INSERT INTO statements.

6. Inserting records into MySQL tables.

7. Inserting multiple records.

8. Retrieving data using SELECT.

9. Selecting all columns using SELECT *.

10. Selecting specific columns from a table.

11. Renaming tables using RENAME TABLE.

12. Introduction to modifying table structures using ALTER TABLE.

We'll use practical SQL examples to understand how databases and tables work.

By the end of this lecture, you'll be comfortable creating tables, inserting records, and retrieving data.

In this lecture, we'll explore additional ways of inserting data and learn how SQL operators help us write more flexible and powerful queries.

Topics covered:

1. Inserting data using column names.

2. Inserting multiple rows in a single query.

3. Understanding SQL comparison operators.

4. Working with equal to and not equal to operators.

5. Using greater than and less than operators.

6. Working with IS NULL and IS NOT NULL.

7. Understanding BETWEEN and IN operators.

8. Pattern matching using LIKE.

9. Working with logical conditions using AND, OR, and NOT.

10. Sorting records using ORDER BY.

11. Retrieving a limited number of records using LIMIT.

12. Understanding LIMIT with OFFSET.

We'll work through practical SQL examples to understand how these operators can be used to retrieve specific information from database tables.

In this lecture, we'll learn how to modify existing records and remove unwanted data from MySQL tables.

Topics covered:

1. Introduction to UPDATE statements.

2. Understanding the UPDATE syntax.

3. Updating a single column.

4. Updating multiple columns simultaneously.

5. Using WHERE conditions with UPDATE.

6. Updating records based on specific conditions.

7. Introduction to DELETE statements.

8. Deleting a single record.

9. Deleting multiple records using conditions.

10. Deleting all records while keeping the table structure.

11. Understanding the difference between DELETE and DROP TABLE.

12. Important precautions when using UPDATE and DELETE without WHERE.

By the end of this lecture, you'll understand how to safely modify and remove records using SQL commands.

In this lecture, we'll explore MySQL constraints and built-in SQL functions that help maintain data integrity and perform useful calculations and transformations.

Part 1: MySQL Constraints

1. Understanding database constraints.

2. UNIQUE constraint.

3. NOT NULL constraint.

4. CHECK constraint.

5. DEFAULT constraint.

6. Adding and modifying constraints using ALTER TABLE.

7. Understanding why constraints are important.

Part 2: SQL Functions

1. Aggregate functions: COUNT(), SUM(), AVG(), MIN(), and MAX().

2. String functions: LENGTH(), LOWER(), UPPER(), and CONCAT().

3. Date functions: NOW(), YEAR(), MONTH(), DAY(), DATEDIFF(), and TIMESTAMPDIFF().

4. Mathematical functions: ROUND(), FLOOR(), CEIL(), and MOD().

5. Conditional functions using IF().

We'll understand these concepts through practical queries and examples.

By the end of this lecture, you'll know how to enforce database rules and use built-in functions to analyze and transform data.

In this lecture, we'll explore MySQL transactions and understand how to control changes made to a database. We'll also study the important concept of primary keys.

Part 1: Transactions and AutoCommit

1. Understanding transactions in MySQL.

2. Understanding the default AutoCommit mode.

3. Disabling AutoCommit.

4. Using COMMIT to save changes permanently.

5. Using ROLLBACK to undo changes.

6. Enabling AutoCommit again.

7. Understanding practical transaction workflows.

Part 2: Primary Keys

1. What is a PRIMARY KEY?

2. Understanding primary key properties.

3. Primary Key vs UNIQUE constraint.

4. Creating a primary key.

5. Adding a primary key using ALTER TABLE.

6. Dropping a primary key.

We'll use practical SQL examples to understand transaction management and the importance of uniquely identifying records in relational databases.

In this lecture, we'll explore how MySQL handles relationships between tables and how SQL JOINs and set operators help combine data from multiple sources.

Part 1: AUTO_INCREMENT

1. Understanding AUTO_INCREMENT.

2. Using AUTO_INCREMENT with PRIMARY KEY.

3. Automatically generating unique identifiers.

4. Changing the starting AUTO_INCREMENT value.

Part 2: Foreign Keys

1. What is a FOREIGN KEY?

2. Understanding relationships between tables.

3. Creating foreign key constraints.

4. Adding foreign keys using ALTER TABLE.

5. Dropping foreign key constraints.

6. Understanding ON DELETE CASCADE, SET NULL, and RESTRICT.

Part 3: SQL JOINs and Set Operators

1. Introduction to SQL JOINs.

2. Understanding INNER JOIN.

3. Understanding LEFT JOIN.

4. Understanding RIGHT JOIN.

5. Introduction to UNION.

6. Understanding UNION vs UNION ALL.

7. Combining results from multiple SELECT statements.

By the end of this lecture, you'll understand how to connect related tables and combine data using different SQL operations.

In this lecture, we'll explore additional SQL concepts that help us write more advanced queries, simplify database operations, and improve data retrieval.

Topics covered:

Part 1: Advanced JOINs

1. Understanding Self JOIN.

2. Joining a table with itself.

3. Using table aliases.

4. Understanding relationships within the same table.

5. Practical examples of Self JOIN.

Part 2: MySQL Views

1. What is a View?

2. Creating views using CREATE VIEW.

3. Querying data from views.

4. Understanding how views reflect changes in underlying tables.

5. Dropping views.

Part 3: MySQL Indexes

1. What are indexes?

2. Understanding why indexes are used.

3. Viewing existing indexes.

4. Creating single-column indexes.

5. Creating multi-column indexes.

6. Understanding index order.

7. Dropping indexes.

Part 4: Subqueries

1. What is a subquery?

2. Understanding nested SQL queries.

3. Scalar subqueries.

4. Using subqueries with IN.

5. Subqueries inside SELECT statements.

6. Understanding derived tables using subqueries.

By the end of this lecture, you'll understand these important SQL techniques and how they can be applied to database queries.

In this lecture, we'll learn how to group records, filter aggregated results, generate summary information, and create reusable SQL programs using stored procedures.

Part 1: GROUP BY and HAVING

1. Understanding GROUP BY.

2. Grouping records based on column values.

3. Using aggregate functions with GROUP BY.

4. Calculating COUNT and AVG for different groups.

5. Understanding the HAVING clause.

6. Difference between WHERE and HAVING.

7. Filtering grouped results.

8. Understanding ROLLUP.

9. Generating subtotals and grand totals using GROUP BY WITH ROLLUP.

Part 2: Stored Procedures

1. What are stored procedures?

2. Why are stored procedures useful?

3. Understanding DELIMITER.

4. Creating stored procedures using CREATE PROCEDURE.

5. Understanding the BEGIN and END blocks.

6. Creating procedures with input parameters.

7. Executing procedures using CALL.

8. Viewing stored procedures.

9. Dropping stored procedures.

By the end of this lecture, you'll understand how to summarize database records and create reusable SQL procedures.

In this final lecture, we'll explore MySQL triggers and several additional SQL features that make database operations more flexible and powerful.

Part 1: MySQL Triggers

1. What is a trigger?

2. Why are triggers used?

3. Understanding BEFORE and AFTER triggers.

4. Triggers associated with INSERT, UPDATE, and DELETE.

5. Creating triggers using CREATE TRIGGER.

6. Understanding NEW and OLD keywords.

7. Creating a user logging trigger.

8. Testing triggers with practical examples.

9. Dropping triggers using DROP TRIGGER.

Part 2: More on MySQL

1. Understanding logical operators: AND, OR, and NOT.

2. Adding columns using ALTER TABLE.

3. Understanding wildcard operators (%) and (_).

4. Working with LIMIT and OFFSET.

5. Retrieving unique records using DISTINCT.

6. Removing all records using TRUNCATE.

7. Understanding CHANGE vs MODIFY in ALTER TABLE.

8. Renaming columns and modifying column data types.

We'll conclude by exploring these useful SQL features and reviewing how they help us work more effectively with MySQL databases.

Congratulations on reaching the final lecture!