Skip to content
CBT Nuggets

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.

Updated August 2021

29Skills
157Videos
27h 7mTotal
157 videos27h 7m

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.

Skills Your Team Will Gain

  • 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

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

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $99 for 1 year of access to MySQL Essentials.

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.