Advanced MySQL Course: SQL Theory & Real Practice

Name: Advanced MySQL Course: SQL Theory & Real Practice
Rating: 1.5 (1 reviews)

Master MySQL with hands-on SQL practice: data types, JOINs, aggregation, subqueries, transactions, database operations.

Created byIT HELPER

Last updated 11/2025

English

What you'll learn

Understand SQL fundamentals and how relational databases work
Write MySQL queries using SELECT, JOIN, GROUP BY, UNION, INSERT, UPDATE, CREATE, DROP and subqueries
Apply SQL theory through real-world practice tasks and exercises
Design and structure databases for practical business scenarios
Solve real MySQL challenges and improve problem-solving skills
Build confidence to use SQL in data analysis and development projects

Course content

7 sections • 44 lectures • 3h 41m total length

Welcome to the Course2:38
"An investment in knowledge always pays the best interest" - Benjamin Franklin

1.1 What Are Databases?2:40
A relational database organizes data into tables with rows and columns and uses unique identifiers (keys) to create defined relationships between these tables. This structured approach makes it efficient to store, manage, and access related information, which is why they are widely used. Data is structured into tables that represent entities, with columns for attributes and rows for individual records.

This understanding will help you later in the course when we start working with MySQL — one of the most widely used relational database systems.
1.2 What Is a DBMS?2:06
Popular DBMS brands include Oracle, MySQL, Microsoft SQL Server, PostgreSQL, and MongoDB. Other prominent brands are MariaDB, SQLite, Redis, and IBM Db2. Many companies also offer cloud-based database services, such as Amazon RDS and Aurora, and Microsoft's Azure SQL Database.

In this course, we will focus specifically on MySQL, a powerful and widely used open-source DBMS.
1.3 What Is SQL?3:51
Structured Query Language (SQL) is a domain-specific, standardized programming language used to interact with relational database management systems (RDBMS) such as MySQL, SQL Server, IBM Db2, PostgreSQL and Oracle Database.

In the next lessons, we will begin writing SQL queries in MySQL Workbench.
1.4 MySQL Installation4:02
In this lesson, you will install MySQL and MySQL Workbench step-by-step. After this setup, you will be ready to start writing your first SQL queries in the next module.

MySQL Installer:
Link from the lesson: https://dev.mysql.com/downloads/installer/

Direct download link for 8.0.44: https://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-8.0.44.0.msi

2.1 Database Keys (Primary Keys Explained)3:39
Primary Key is a unique identifier for each row in a table. It must contain unique, non-null values and ensures data integrity. Primary keys help prevent duplicate records and are used to connect tables through foreign keys.

Composite Key in SQL consists of two or more columns that together create a unique value for each row. It is used when no single column can uniquely identify a record. Unlike a single-column primary key, which relies on one field to guarantee uniqueness, a composite key ensures that the combination of values across multiple columns is unique.

Surrogate key is an artificially generated unique identifier, often an auto-increment column. It has no business meaning and is used to simplify table relationships and ensure reliable indexing.
SQL Fundamentals: Quick Knowledge Check
2.2 Introduction to Database and SELECT Statements (Basic Query Structure)10:19
In this lecture, you will download and install the sample database that we will use throughout the course.
This database represents a small library system and contains several connected tables:
reader – stores information about library customers
book – stores book titles and their details
edition – contains edition-specific information related to each book
library_service – lists services the library provides
transaction – records which service was ordered, by which reader, and the status of the transaction
You will upload this database into your local MySQL environment and review its structure so you can begin writing queries.
Practice task: SELECT operator and Primary Key
2.3 Selecting Specific Columns in MySQL1:46
Practice task: SELECT columns
2.4 Filtering Data with WHERE Clause5:01
When working with numeric values (such as 5, 99, 223), it’s best to get used to writing them without quotation marks. MySQL may allow quotes around numbers, but other database management systems may not. We’ll explore numeric data types in more detail in Module 3.
Practice task: Filtering with WHERE
2.5 IN operator4:19
Practice task: Using IN Operator
2.6 Comparison Operators in SQL4:38
Practice task: Comparison Operators
2.7 DISTINCT2:27
Practice task: DISTINCT
2.8 Search with LIKE operator4:24
Practice task: Search with LIKE
2.9 SQL Best Practices for Writing Clean Queries6:59
In this lesson, we will explore key SQL best practices that help you write cleaner, more readable, and more efficient queries. These principles will make your SQL skills more professional and prepare you for advanced topics.

3.1 Why are types of data important?3:29
3.2 Data Types in MySQL Part 1.9:17
Data Types in MySQL Short Quiz
3.3 NOT operator3:54
Practice task: NOT operator
3.4 NULL value3:53
Practice Task: NULL value
3.5 AND/OR operators2:07
Note that IN operator with parentheses works like OR operator when searching on the same column.
Compare these two queries and how easy it is to write the second one:

SELECT * FROM reader WHERE first_name = 'Emma' OR first_name = 'Liam' OR first_name = 'Sophie';
SELECT * FROM reader WHERE first_name IN ('Emma', 'Liam', 'Sophie');
Practice task: AND/OR operators
3.6 Execution order NOT-AND-OR operators4:37
Practice Task: Execution order NOT-AND-OR operators
3.7 BETWEEN operator2:55
Practice task: BETWEEN operator
3.8 AGGREGATION and SORT4:28
If you want to use the word LIMIT, but not from the first row (the default), but from, the second (or any other), then use the word OFFSET.
OFFSET counts rows from zero, meaning the second row is OFFSET 1.

Example: SELECT * FROM reader ORDER BY age DESC LIMIT 1 OFFSET 1;
Practice Task: AGGREGATION and SORT
3.9 COUNT operator4:13
Practice Task: COUNT operator

5.1 Data Types in MySQL Part 2.5:27
Data Types in MySQL Part 2 Short Quiz
5.2 Update Data in Database3:34
Always enter a unique value in WHERE condition to avoid accidentally updating multiple rows at once.
Practice task: Update Data in Database
5.3 SQL Transactions6:02
ROLLBACK cannot undo ALTER, DROP, or CREATE statements (you will later learn why).
However, it can rollback changes made by INSERT, UPDATE, and DELETE.
Practice task: SQL Transactions
5.4 Save Points in SQL3:47
Practice Task: Save Points in SQL
5.5 INSERT INTO Statement8:16
Practice Task: INSERT INTO Statement
5.6 DELETE and DROP Operations6:01
Practice Task: DELETE and DROP Operations
5.7 Table Creation9:45
Practice Task: Table Creation
5.8 SQL Command Categories (DDL, DML, DCL, TCL)3:38

Requirements

No prior SQL or programming experience required — this course is beginner-friendly
A computer with internet access and the ability to install MySQL
Motivation to learn and practice with real tasks

Description

This course contains the use of artificial intelligence.

You will learn MySQL through a clear, structured, and highly practical approach. This course covers everything from SQL fundamentals to advanced real-world techniques used by data analysts, backend developers, QA engineers, and database administrators.

We start with the basics — understanding what databases are, how SQL works, and how to interact with MySQL using real queries. You will learn all essential SQL concepts such as comparison operators, filtering, sorting, wildcards, logical operators, the IN and BETWEEN operators, and grouping data using GROUP BY.

As the course progresses, we go deeper into database logic: JOINS, nested subqueries, data types, and working with date/time functions. You will also explore more advanced topics like transactions, COMMIT/ROLLBACK, savepoints, updating data safely, deleting rows with foreign key constraints, and creating your own database from scratch.

This course is highly practical. Every module includes assignments, quizzes, and tasks that require you to write real SQL queries. You will practice SELECT, INSERT, UPDATE, DELETE, and advanced analytical SQL patterns used in real work environments.

By the end of the course, you will be able to confidently design, query, and manage relational databases, understand real business scenarios, and apply SQL skills immediately in your job or learning path.

Whether you're a beginner or want to strengthen your SQL fundamentals and dive deeper — this course is designed for you.

AI Usage Disclosure

This course uses AI-generated voice narration.
All lesson content, scripts, explanations, SQL queries, assignments, and instructional materials were fully written, designed, and checked by the instructor. The AI was used only for audio narration, not for generating educational content.

Who this course is for:

Beginners who want to learn SQL and MySQL from scratch
Developers and testers searching for practical SQL experience
Data analysts and BI specialists who need stronger query skills
Students preparing for IT or data-related job interviews
Anyone interested in working with databases or analyzing data

Advanced MySQL Course: SQL Theory & Real Practice

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Module 1: Database & SQL Fundamentals4 lectures • 13min

Module 2: SQL Basics – SELECT, Filters, and Operators9 lectures • 44min

Module 3:SQL Operators, Data Types & Aggregation9 lectures • 39min

Module 4: Advanced SQL — Schemas, Subqueries, JOINs & UNION8 lectures • 50min

Module 5: Data Manipulation, Transactions & Database Management in SQL8 lectures • 47min

Module 6: Working with Date, Time, and Text Data in SQL5 lectures • 28min

Requirements

Description

Who this course is for: