MySQL Online Training

This foundational MySQL training prepares learners to create, configure, maintain, and deploy MySQL databases for web applications.

MySQL is the most popular relational database in the world. That’s because MySQL databases are free, open source, and easy to create and maintain. MySQL is a key component in the archetypal LAMP (Linux, Apache, MySQL, PHP) stack, which has long been shorthand for the basic building blocks required to host and build websites. For these reasons, MySQL is often the first relational database web developers learn.

In addition to its popularity, MySQL is a mature, stable technology. MySQL is more robust than serverless options like SQLite, but easier to deploy and maintain than other relational databases, which also makes it a great first database to learn.

For anyone who manages developers, this MySQL training can be used to onboard new developers, curated into individual or team training plans, or as a MySQL reference resource.

MySQL: What You Need to Know

This MySQL training has videos that cover topics including:

Creating tables in MySQL databases
Understanding different MySQL storage engines
Automating MySQL databases with triggers
Using the Python MySQL connector to store and query data
Securing a MySQL database

Who Should Take MySQL Training?

This MySQL training is considered foundational-level MySQL training, which means it was designed for developers with 1 to 3 years of experience — or no experience at all. This MySQL course is valuable for new or aspiring IT professionals, experienced developers looking to validate foundational skills, and non-technical professionals.

MySQL user training. For anyone learning MySQL, you’ll become acquainted not only with one of the most popular web technologies, but also one of the most popular languages — SQL. Though SQL may be in the name, MySQL and SQL are different. One is the database and the other is the query language. In this MySQL training, you’ll learn both.

New or aspiring web developers. If you’re learning to become a web developer, you’re going to learn to use MySQL. The LAMP stack is still the most common technology for most websites. This MySQL training shows you how to build, configure, and maintain the database that runs everything from simple static sites to the most complicated web applications.

Skill:
Introduction to MySQL
- 1. Overview
  1 min
- 2. Intro to MySQL Database Server
  7 mins
- 3. Understanding Various Types of Database Engines
  8 mins
- 4. Learn About Relational Database Schemas
  7 mins
- 5. Methods of Running MySQL Databases
  12 mins
- 6. Tools for Managing MySQL Database Servers
  11 mins
- 7. Connecting to MySQL Server with Sqlectron
  6 mins
- 8. Conclusion
  1 min
Skill:
Create Tables in MySQL Databases
- 1. Overview
  1 min
- 2. Intro to MySQL Table Management
  11 mins
- 3. Create Employees Table in MySQL
  8 mins
- 4. Add ID Field and NOT NULL Column Constraint
  7 mins
- 5. Enforce Unique Values on Employee ID Column with PRIMARY KEY Constraint
  6 mins
- 6. Enable Auto Incrementing on Employee ID Column
  5 mins
- 7. Add FullName Generated Virtual Column
  9 mins
- 8. Add BirthDate Field to Employees as DATE Type
  7 mins
- 9. Conclusion
  1 min
Skill:
Creating Tables with Constraints in MySQL
- 1. Overview
  1 min
- 2. Intro to MySQL Table Constraints
  14 mins
- 3. Create FOREIGN KEY References in MySQL
  11 mins
- 4. Query Data Across FOREIGN KEY References
  5 mins
- 5. Define Table CHECK Constraints in MySQL
  9 mins
- 6. Define Column CHECK Constraints in MySQL
  4 mins
- 7. Conclusion
  1 min
Skill:
Writing Select Queries in MySQL
- 1. Overview
  1 min
- 2. Intro to SELECT Queries in MySQL
  11 mins
- 3. Select Columns and Set Aliases in MySQL
  13 mins
- 4. Use Function Expressions in MySQL SELECT Statments
  9 mins
- 5. Filter MySQL Query Results with WHERE Clause
  10 mins
- 6. Use GROUP BY and ORDER BY Statements
  12 mins
- 7. Conclusion
  1 min
Skill:
Working with Date and Time in MySQL Databases
- 1. Overview
  1 min
- 2. Intro to Date-Time in MySQL
  5 mins
- 3. Overview: DateTime Data Types for MySQL Columns
  13 mins
- 4. Exploring DATETIME and TIMESTAMP Data Types
  8 mins
- 5. Date and Time Literals in MySQL Language
  10 mins
- 6. Built-in DateTime Manipulation Functions in MySQL
  15 mins
- 7. Conclusion
  1 min
Skill:
Understanding Windows in MySQL SELECT Statements
- 1. Overview
  1 min
- 2. Intro to MySQL Windows
  14 mins
- 3. Build Sample Database for MySQL Windows
  8 mins
- 4. Use OVER Clause to Ask Deeper Questions
  8 mins
- 5. Create Named WINDOWs in MySQL SELECT Statements
  13 mins
- 6. Use Outer and Sub-queries to Filter Windows
  8 mins
- 7. Conclusion
  1 min
Skill:
Using MySQL Window Functions in SELECT Queries
- 1. Overview
  1 min
- 2. Intro to MySQL Window Functions
  6 mins
- 3. Set Up Sample MySQL Database
  9 mins
- 4. RANK and DENSE_RANK MySQL Functions
  15 mins
- 5. Divide MySQL Partitions into Buckets with NTILE
  6 mins
- 6. Conclusion
  1 min
Skill:
Writing User-Defined Routines in MySQL
- 1. Overview
  1 min
- 2. Intro to MySQL Procedures and Functions
  10 mins
- 3. Create a MySQL Stored Procedure
  9 mins
- 4. Specify Parameters on MySQL Stored Procedures
  10 mins
- 5. Create and Invoke MySQL Functions
  9 mins
- 6. Implement Complex MySQL Routine Bodies
  11 mins
- 7. Conclusion
  1 min
Skill:
Using MySQL Triggers to Automate Database Activities
- 1. Overview
  1 min
- 2. Intro to MySQL Triggers
  12 mins
- 3. Set up Containerized MySQL Environment
  8 mins
- 4. Logging MySQL Database Activity with Triggers
  10 mins
- 5. Retrieve INSERT Field Values Inside MySQL Triggers
  5 mins
- 6. Modify MySQL Data Rows with Triggers
  9 mins
- 7. Block Row Deletion with Conditional MySQL Triggers
  6 mins
- 8. Conclusion
  1 min
Skill:
Learn MySQL Views
- 1. Overview
  1 min
- 2. Intro to MySQL Views
  13 mins
- 3. Create Calculated Columns with MySQL Views
  11 mins
- 4. Define User Security on MySQL Views
  9 mins
- 5. Updatable Views in MySQL
  8 mins
- 6. Triggers and Views in MySQL
  5 mins
- 7. Conclusion
  1 min
Skill:
Using Regular Expression Functions in MySQL
- 1. Overview
  1 min
- 2. Overview of MySQL Regular Expression Functions
  10 mins
- 3. Use REGEXP_INSTR to Find Pattern Occurrences in MySQL
  15 mins
- 4. Use REGEXP_REPLACE to Substitute String Values in MySQL
  10 mins
- 5. Use Regular Expressions in MySQL Functions
  8 mins
- 6. Conclusion
  1 min
Skill:
Partitioning Tables in MySQL Databases
- 1. Overview
  1 min
- 2. Intro to MySQL Table Partitioning
  9 mins
- 3. Partition MySQL Tables by Range of Values
  12 mins
- 4. Partition MySQL Tables with List of Values
  9 mins
- 5. Partition MySQL Tables by HASH or KEY
  10 mins
- 6. Querying MySQL Engine for Partition Metadata
  13 mins
- 7. Conclusion
  1 min
Skill:
Learn MySQL Table Indexes
- 1. Overview
  1 min
- 2. Intro to MySQL Table Indexes
  9 mins
- 3. Inject Sample Data Into MySQL Database
  8 mins
- 4. Create an Index on MySQL Tables
  9 mins
- 5. Monitor Index Utilization in MySQL Engine
  8 mins
- 6. Optimize ORDER BY Queries in MySQL with Indexes
  9 mins
- 7. Incorporate Indexes into MySQL Table Creation
  6 mins
- 8. Conclusion
  1 min
Skill:
Understanding MySQL Storage Engines
- 1. Overview
  1 min
- 2. Intro to MySQL Storage Engines
  9 mins
- 3. Review the Default InnoDB MySQL Storage Engine
  9 mins
- 4. Explore the MySQL MyISAM Storage Engine
  9 mins
- 5. Create MySQL Tables with the CSV Storage Engine
  9 mins
- 6. Creating Tables with the MySQL MEMORY Storage Engine
  8 mins
- 7. Query Remote Data with Federated Tables in MySQL
  13 mins
- 8. Conclusion
  1 min
Skill:
Learn MySQL Database User Configuration
- 1. Overview
  1 min
- 2. Intro to MySQL Users
  10 mins
- 3. Create MySQL Users
  15 mins
- 4. Configure Password Options for MySQL Users
  10 mins
- 5. Specify Resource Controls for MySQL Users
  8 mins
- 6. Enforce TLS Connections to MySQL Engine
  10 mins
- 7. Conclusion
  1 min
Skill:
Learn MySQL Database Privileges
- 1. Overview
  1 min
- 2. Intro to MySQL Privileges
  13 mins
- 3. Grant Global Privileges to MySQL Engine
  9 mins
- 4. Grant Database Privileges to MySQL Users
  9 mins
- 5. Grant Table Privileges to MySQL Users
  5 mins
- 6. Grant Column Level Privileges to MySQL Users
  7 mins
- 7. Configure Proxy Users in MySQL
  12 mins
- 8. Conclusion
  1 min
Skill:
Backup and Restore MySQL Databases
- 1. Overview
  1 min
- 2. Intro to MySQL Backup and Restore
  11 mins
- 3. Install mysqldump and Create Test Data
  8 mins
- 4. Backup and Restore an Entire MySQL Server
  6 mins
- 5. Backup and Restore Specific MySQL Tables
  9 mins
- 6. Conclusion
  1 min
Skill:
Use the MySQL Shell to Manage MySQL Databases
- 1. Overview
  1 min
- 2. Intro to MySQL Shell
  15 mins
- 3. Explore the MySQL Shell Environment
  12 mins
- 4. Run Bash Commands From MySQL Shell
  7 mins
- 5. Import JSON Data Using MySQL Shell
  9 mins
- 6. Run MySQL Shell in Batch Mode
  8 mins
- 7. Conclusion
  1 min
Skill:
Use PowerShell to Query MySQL Databases
- 1. Overview
  1 min
- 2. Intro to MySQL and PowerShell
  9 mins
- 3. Deploy MySQL and PowerShell Container Playground
  14 mins
- 4. Manage MySQL Connections with PowerShell
  11 mins
- 5. Create MySQL Database and Return DB List with PowerShell
  8 mins
- 6. Create MySQL Table and Iterate Over Data Rows with PowerShell
  13 mins
- 7. Conclusion
  1 min
Skill:
Manage MySQL Databases with phpMyAdmin
- 1. Overview
  1 min
- 2. Intro to MySQL and phpMyAdmin
  12 mins
- 3. Overview of phpMyAdmin User Interface
  6 mins
- 4. Import and Explore Northwind Database with phpMyAdmin
  10 mins
- 5. Apply Custom Configuration for phpMyAdmin
  7 mins
- 6. Create MySQL Event Scheduler with phpMyAdmin
  8 mins
- 7. Monitoring MySQL with phpMyAdmin
  5 mins
- 8. Conclusion
  1 min
Skill:
Use Python to Manage MySQL Databases
- 1. Overview
  1 min
- 2. Intro to MySQL Python Connector
  4 mins
- 3. Set Up MySQL Server and Python Containers with VSCode
  12 mins
- 4. Establish Connection to MySQL using Python Connector
  13 mins
- 5. Create MySQL Databases and Tables with Python
  10 mins
- 6. Insert and Select Data from MySQL Tables with Python
  10 mins
- 7. Conclusion
  1 min
Skill:
Running MySQL on Azure
- 1. Overview
  1 min
- 2. Intro to MySQL on Azure
  11 mins
- 3. Deploy an Azure Virtual Machine with MySQL
  11 mins
- 4. Deploy MySQL on Azure Database
  16 mins
- 5. Running MySQL on Azure Container Instances
  16 mins
- 6. Conclusion
  1 min
Skill:
Running MySQL on Amazon Web Services (AWS)
- 1. Overview
  1 min
- 2. Intro to MySQL on AWS
  11 mins
- 3. Run MySQL on Amazon EC2 Virtual Machines
  14 mins
- 4. Run MySQL with Docker on EC2
  13 mins
- 5. Run MySQL on AWS Fargate
  13 mins
- 6. Run MySQL on Amazon Relational Database Service
  11 mins
- 7. Conclusion
  1 min
Skill:
Configure Active Directory Authentication for MySQL in Amazon RDS
- 1. Overview
  1 min
- 2. Intro to Amazon RDS Integration with AWS Managed Microsoft Active Directory
  10 mins
- 3. Setting up an Amazon VPC Environment
  7 mins
- 4. Deploy Windows Server EC2 Client Instance
  9 mins
- 5. Deploy Amazon RDS MySQL Instance
  6 mins
- 6. Install and Test MySQL Client on EC2
  15 mins
- 7. Clean Up Your AWS Demo Environment
  4 mins
- 8. Conclusion
  1 min
Skill:
Configure InnoDB Cluster for MySQL
- 1. Overview
  1 min
- 2. Intro to MySQL InnoDB Cluster
  10 mins
- 3. Configure the MySQL Servers
  15 mins
- 4. Create the MySQL InnoDB Cluster
  13 mins
- 5. Add a Secondary MySQL Instance to InnoDB Cluster
  11 mins
- 6. Conclusion
  1 min
Skill:
Storing and Querying JSON Data in MySQL
- 1. Overview
  1 min
- 2. Intro to JSON Storage in MySQL
  13 mins
- 3. Create MySQL Table with JSON Data Type
  12 mins
- 4. Modify JSON Array Values in MySQL
  10 mins
- 5. JSON Schema Validation in MySQL
  16 mins
- 6. Conclusion
  1 min
Skill:
Using MySQL as a Document Storage System
- 1. Overview
  1 min
- 2. Intro to MySQL Document Storage
  13 mins
- 3. Setting Up MySQL Document Test Environment
  11 mins
- 4. Import and Explore World_X MySQL Sample Database
  8 mins
- 5. Managing NoSQL Collections with MySQL Shell
  11 mins
- 6. About InnoDB Clustering for MySQL Document Storage
  6 mins
- 7. Conclusion
  1 min
Skill:
Managing Documents in MySQL Document Store
- 1. Overview
  1 min
- 2. Intro to MySQL Document Management
  10 mins
- 3. Searching for Documents in MySQL Collections
  12 mins
- 4. Property Projection in MySQL Collection Searches
  12 mins
- 5. Adding Documents to MySQL Collections
  9 mins
- 6. Modify Existing Documents in MySQL Collections
  7 mins
- 7. Create an Index for MySQL Document Collection
  8 mins
- 8. Conclusion
  1 min
Skill:
Deploy MySQL-Compatible Databases on Planetscale
- 1. Overview
  1 min
- 2. Intro to Planetscale for MySQL Compatible Databases
  6 mins
- 3. Explore the Planetscale Console
  11 mins
- 4. Create and Deploy Branch in Planetscale
  12 mins
- 5. Connect to MySQL Database with Planetscale CLI Tool
  11 mins
- 6. Manage Database Branches with Planetscale CLI
  12 mins
- 7. Managing Database Passwords with Planetscale CLI
  4 mins
- 8. Conclusion
  1 min

Loading transcripts...

Partition MySQL Tables by Range of Values

Access all premium content with a free week!

Start a free week

Explore Features

Course overview

27 HOURS OF TRAINING

29 SKILLS

157 VIDEOS

0 VIRTUAL LABS

0 PRACTICE EXAMS

Trevor Sullivan

Nugget trainer since 2020

Read the full bio

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews

MySQL FAQs: Cost, Training, Value

What will you learn in this MySQL training?

Take MySQL training from CBT Nuggets and you'll learn how to take control of and make use of the world's most popular database engine. You'll learn the basics of what a MySQL database is best for, how to set one up, optimize it, connect it to apps, and more.

Who should take this MySQL course?

Virtually anyone who comes into contact with data and databases should take this course on MySQL. Learning what MySQL is and what it's capable of can help you make better business decisions about what technology to invest in or make better technical decisions when it comes to actual implementations.

Is this training in MySQL associated with any certifications?

No, even though many CBT Nuggets courses are specially designed to help learners pass a certification exam, MySQL training from CBT Nuggets is more focused on practical knowledge. Since it's thorough and practice-oriented, you can use this course to prepare for certification exams, it just isn't modeled off any certs.

What certification should you consider after taking this course in MySQL?

MySQL training from CBT Nuggets is designed to give you a conceptual understanding of database design and maintenance as well as practice with actually performing database administration. That's why the two Oracle certifications – Database Administration and Database Developer – will be significantly easier after taking this course

Why should you take this MySQL training?

You should take this MySQL training because there's always something more you can know about databases. For analysts, learning the right queries can make your data pulls better. For administrators, understanding data management can make your networks faster. And for engineers, mastering data architecture can define your career.

Oracle Database SQL Certified Associate (1Z0-071)

SQL for Data Practitioners

What is it like to train with us?

Our learners say it best.

MySQL FAQs: Cost, Training, Value

Let's chat!