MySQL Essentials

This MySQL training covers how create, configure, maintain, and deploy MySQL databases for web applications. You'll learn how to control and use the world's most popular database engine and the basics of what a MySQL database is best for, how to set one up, optimize it, connect it to apps, and more.

Trevor SullivanDevOps & Cloud Engineering

Updated August 2021

Request a Demo

29Skills

157Videos

27h 7mTotal

157 videos

Who This Course Is For

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.

Course Curriculum

Premium skill.Introduction to MySQL54m
Premium skill.Create Tables in MySQL Databases56m
Premium skill.Creating Tables with Constraints in MySQL56m
Premium skill.Writing Select Queries in MySQL59m
Premium skill.Working with Date and Time in MySQL Databases54m
Premium skill.Understanding Windows in MySQL SELECT Statements55m
Premium skill.Using MySQL Window Functions in SELECT Queries59m
Premium skill.Writing User-Defined Routines in MySQL53m
Premium skill.Using MySQL Triggers to Automate Database Activities54m
Premium skill.Learn MySQL Views1h 1m
Premium skill.Using Regular Expression Functions in MySQL58m
Premium skill.Partitioning Tables in MySQL Databases56m
Premium skill.Learn MySQL Table Indexes52m
Premium skill.Understanding MySQL Storage Engines60m
Premium skill.Learn MySQL Database User Configuration55m
Premium skill.Learn MySQL Database Privileges58m
Premium skill.Backup and Restore MySQL Databases51m
Premium skill.Use the MySQL Shell to Manage MySQL Databases53m
Premium skill.Use PowerShell to Query MySQL Databases58m
Premium skill.Manage MySQL Databases with phpMyAdmin51m
Premium skill.Use Python to Manage MySQL Databases52m
Premium skill.Running MySQL on Azure57m
Premium skill.Running MySQL on Amazon Web Services (AWS)1h 4m
Premium skill.Configure Active Directory Authentication for MySQL in Amazon RDS54m
Premium skill.Configure InnoDB Cluster for MySQL52m
Premium skill.Storing and Querying JSON Data in MySQL1h 6m
Premium skill.Using MySQL as a Document Storage System52m
Premium skill.Managing Documents in MySQL Document Store60m
Premium skill.Deploy MySQL-Compatible Databases on Planetscale59m