Certification course

Learn MySQL.

Learn MySQL and take control of how data is stored, queried, and managed.

4.8 · 5 reviews

$95Exam and certificate included

All 33 courses · $499

Already know MySQL? Take the exam · $95

14-day money-back guarantee · Instant access · Lifetime access

BeginnerNo experience needed
31 hoursAt your own pace
52 modulesLessons, quizzes, exercises
Exam includedNo need to buy separately
W3Schools Hero1-year subscription included

Our learners work at

What you'll learn

Real MySQL skills, step by step.

Everything you need to use MySQL with confidence, from the first line to real projects.

Understand basic SQL syntax and how to write queries.
Learn database operations like SELECT, INSERT, UPDATE, and DELETE.
Work with database and table structures using CREATE, DROP, and ALTER.
Understand advanced SQL operations like JOINs, UNION, and GROUP BY.
Handle NULL values and learn about constraints.
Use SQL functions for strings, numbers, and dates.
Create and manage indexes and views.
Work with advanced SQL features like wildcards and aliases.

Roles you'll be ready for

Database Administrator
Back-End Developer
Data Analyst
SQL Developer
Data Engineer
Full Stack Developer
PHP Developer
Business Intelligence Developer
Database Developer
Systems Administrator
Reporting Analyst
Web Application Developer

Syllabus

Everything the course covers.

7 chapters · 52 modules · 31 hours

01Getting started4 modules

MySQL HOME
MySQL Intro
MySQL RDBMS
MySQL SQL

02Querying data9 modules

MySQL SELECT
MySQL WHERE
MySQL AND, OR, NOT
MySQL ORDER BY
MySQL INSERT INTO
MySQL NULL Values
MySQL UPDATE
MySQL DELETE
MySQL LIMIT

03Functions and filters7 modules

MySQL MIN and MAX
MySQL COUNT, AVG, SUM
MySQL LIKE
MySQL Wildcards
MySQL IN
MySQL BETWEEN
MySQL Aliases

04Joins and grouping14 modules

MySQL Joins
MySQL INNER JOIN
MySQL LEFT JOIN
MySQL RIGHT JOIN
MySQL CROSS JOIN
MySQL Self Join
MySQL UNION
MySQL GROUP BY
MySQL HAVING
MySQL EXISTS
MySQL ANY, ALL
MySQL INSERT SELECT
MySQL CASE
MySQL Null Functions

05Comments and operators2 modules

MySQL Comments
MySQL Operators

06Databases and tables5 modules

MySQL Create DB
MySQL Drop DB
MySQL Create Table
MySQL Drop Table
MySQL Alter Table

07Constraints, indexes and views11 modules

MySQL Constraints
MySQL Not Null
MySQL Unique
MySQL Primary Key
MySQL Foreign Key
MySQL Check
MySQL Default
MySQL Create Index
MySQL Auto Increment
MySQL Dates
MySQL Views

Your certificate

Become a Certified MySQL Developer.

A credential from the site that has taught the web since 1999.

Learn
Lessons, quizzes and exercises. No deadlines.
Pass the exam
Online, multiple choice. 3 attempts, results instantly.
Share it
On LinkedIn and your CV. Employers verify it by link or QR code.

Your score sets your level: Intermediate 40% · Advanced 75% · Professional 90%

Also included

A year of W3Schools Hero subscription.

Keep learning and building long after the exam. Worth $120, included.

Unlimited learning in the app
Full access on iOS and Android. Learn anywhere.
Build with Spaces
Your own space to build, test and deploy real projects.
Ad-free W3Schools
Learn on w3schools.com without ads.
Leaderboard and challenges
Earn XP, keep your streak, compete with other learners.

Reviews

What learners say.

4.8 · 5 reviews

The course was very helpful in grasping the concepts. I paid to get the certificate and it feels like it was worth it. The course is structured to help you succeed.

Boluwatife A.Verified buyerNigeria
I have learned a lot by practicing in W3schools site. Your site is very good.

Deepa K.Verified buyerUnited States
Simplicity is all I can say about the course.

Simbarashe M.Verified buyerBotswana

Pricing

One course, or all of them.

This course

Learn MySQL

$95one-time

The full MySQL course
MySQL exam and certificate
1 year of W3Schools Hero subscription
Lifetime access

14-day money-back guarantee, as long as no exam attempt is used.

Best value

Full Access

$499one-time

45+ certifications
W3Schools Hero subscription for life
Lifetime access
New courses and exams included as we add them

Get Full Access 14-day money-back guarantee, as long as no exam attempt is used.

Questions? Answers.

Do you have a money-back guarantee?

Yes. If you are not satisfied, you get your money back within 14 days of purchase, as long as no exam attempts are used. Our refund policy.

How fast do I get access?

Instantly. Right after purchase you get an email with access to the course and the exam.

How does the exam work?

The exam is online and multiple choice. You get 3 attempts and choose when to take each one. Your score sets your level: Intermediate (40%), Advanced (75%) or Professional (90%).

Does the certificate expire?

No. The certificate never expires. It is issued in your name and employers can verify it with a unique link or QR code.

What is the difference between the course and the exam?

The course includes lessons, exercises, progress tracking and the exam. If you already know the subject, you can buy the exam only and go straight to certification.