Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Complete MySQL Developer Course

Name: The Complete MySQL Developer Course
Rating: 4.4 (8236 reviews)

MySQL: Learn how to use MySQL and PHP to build Reports and work with Databases for Web Applications

Created byRob Percival, Mashrur Hossain, Codestars • over 2.5 million students worldwide!

Last updated 12/2025

English

What you'll learn

Apply for jobs as junior MySQL developers
Build web applications using MySQL and PHP
Establish a solid foundation for databases and SQL

Course content

12 sections • 133 lectures • 10h 28m total length

Introduction1:35
Introduction to the course
Introduce yourself and learn how to get FREE LIVE HELP!3:15
Introduce yourself to the class and learn how to get help in Q & A section and free live chat
Development environment overview1:12
Why we will use an online IDE to develop code in this course
IMPORTANT: Development Environment Setup - Overview0:16
Additional resources and help for students with setup
Windows - Install/setup MySQL, users and create databases11:21
MySQL installation, setup and database creation steps for Windows users
Mac - Install/setup MySQL, users and create databases7:49
MySQL installation, setup and database creation steps for Mac users
AWS Cloud - Setup MySQL, users and create databases9:38
MySQL installation, setup and database creation steps for AWS cloud9 users

Power of Databases1:55
What is MySQL and how wide is it's reach?
Create a Database/Schema7:03
How to create a database/schema
Create a Database/Schema - Text lecture0:56
Text information for Create a Database/Schema video
Intro to tables and conventions used4:45
A look at tables, structures for queries and syntax used in the course
Working with tables12:48
Learn how to work with tables in databases
Working with tables - Text lecture1:03
Inserting rows of data11:49
Learn how to insert data into tables
Inserting rows of data - Text lecture0:31
Text follow-up to inserting rows of data video
Select2:57
Working with select in MySQL
Select - Text lecture0:19
Text follow-up for working with select video
Concat and substring10:40
Working with the concat and substring operators
Concat and substring - Text lecture0:31
Text follow-up lecture to working with concat and substring operators
Homework challenge - bowling scores!3:07
Homework code challenge
Homework challenge - Text version0:32
Text version of homework challenge
Solution - bowling score challenge10:54
Solution to homework assignment
Solution - Text0:21
Text solution to homework challenge
Alternate method of homework solution - script4:02
Using scripts to develop code and running them instead of using the console
Alternate method of running queries - script - Text version0:12
Text description of how to run queries via scripts
MySQL, Oracle, SQL Server3:22
A look at SQL
Limit, order by and distinct9:14
Learn how to use additional features like limit, order by and distinct
Limit, order by and distinct - Text lecture0:54
Text follow-up to limit, order by and distinct features
Count, like and group by7:46
Learn how to use count, like and group by features
Count, like and group by - Text lecture0:34
Text follow-up for video lecture on using count, like and group by
Min and max6:40
Learn how to use min and max
Min and max - Text lecture0:26
Text follow-up to video lecture on min and max operators
Code challenge project - create a new report11:00
Code challenge to create a new report
Code challenge project - Text version0:30
Text solution to report

Data types in MySQL5:20
Learn about different data types and their features
Data types in MySQL - Text lecture1:16
Text lecture follow-up to video on data types
Where and not equal5:19
Learn the details about where and how to use it, along with not equal
Where and not equal - Text lecture0:30
Text lecture follow-up to where and not equal
Comparison operators7:10
Working with comparison operators
Comparison operators - Text lecture0:53
Text lecture follow-up to comparison operators video
Or2:06
Working with or
Or - Text lecture0:10
Text lecture follow-up for working with Or
Null and blanks8:28
Working with null entries and blanks
Null and blanks - Text lecture0:53
Text lecture follow-up for working with null and blank video
Case statements3:27
Working with case
Case statements - Text lecture0:31
Text lecture follow-up for working with case statements
Dates and times6:37
Working with date and time formats
Dates and times - Text lecture0:57
Text lecture follow-up for video on working with dates and times
Date, time and math13:28
More date, time and date math
Date, time and math - Text lecture1:11
Text lecture follow-up to video on more date, time and math
Section 3 final project - Create a report on birthdays19:35
Final project for section 3, report on working with birthdays
Text solution to final project on birthday reporting1:28
Text solution to final project on section 3 - birthday reporting

Primary keys, foreign keys5:44
Learn what are primary and foreign keys
Primary and foreign keys - Text lecture1:05
Text version of primary and foreign keys video
Data prep for joins11:07
Setup our tables and data to work with joins
Data prep for joins - Text lecture1:11
Text follow up to data prep for joins video
Joins and aliases8:22
Learn about joins and using aliases
Joins and aliases - Text lecture0:43
Text follow-up to Joins and aliases video
More about joins12:39
Joins more in-depth
More about joins - Text lecture0:57
Text follow-up to more about joins video
Inner, Left, Outer, Right joins4:28
Learn about inner, left, outer and right joins
Inner, Left, Outer and Right joins - Text lecture1:12
Text follow-up to video on different types of joins
Left outer joins7:58
Learn about left joins
Left outer joins - Text lecture0:47
Text follow-up to video on left joins
Fix a bad join challenge4:15
Code challenge to fix a bad join
Fix a bad join challenge - Text lecture0:27
Text follow up to fixing a bad join challenge
Subselects6:54
Learn about subselects
Subselects - Text lecture0:38
Text follow-up to lecture on subselects
More subselects8:35
Subselects more in-depth
More subselects - Text lecture0:51
Text followup to video on subselects more in-depth
Section 5 - Final Project Part 112:39
Part 1 of final project for section 5
Final Project Part 1 - Text solution0:41
Text solution to final project part 1
Section 5 - Final Project Part 24:36
Part 2 of final project for section 5
Final Project Part 2 - Text solution0:25
Text solution to final project part 2 of section 5

Introduction to Web App Development8:09
Intro to building web applications
HTML and CSS2:33
Working with HTML and CSS - web building blocks
HTML and CSS - Text lecture0:10
Text follow-up to video on HTML and CSS
Start form collector project13:28
Start the web app
Project start - Text lecture2:26
Text follow-up to form collector project
Add styling to form8:01
Add styling to the form collector
Add styling to form - Text follow-up2:27
Text follow-up lecture to adding styling
Create table6:37
Create a table for the app using sql
Create table - Text follow-up0:24
Text follow-up to creating a table with sql
Learn php basics0:27
E-book for students of this course to learn introductory php
Config and other php13:51
Create a config file along with other php
Config and other php - Text follow-up2:16
Text lecture follow-up to config and other php
Complete receiver15:21
Complete the code for receiver.php
Complete receiver - Text follow-up0:05
Text lecture follow-up to complete receiver.php file
Start SQL Functons12:40
Start working on SQLFunctions file
Start SQL Functions - Text lecture1:20
Text lecture follow-up to SQL Functions
Preview and understand steps taken for web app15:44
Preview the web app and steps taken
Preview of web app - Text follow-up0:22
Text lecture follow-up to preview web app video
Add browser display9:54
Add a browser display for the web app
Add browser display - Text follow-up0:38
Text follow-up to adding browser display video
Project - Convert to poll!4:38
Final project for section 6 - convert to poll
Project - Solution text1:29
Text solution to final project for section 6

CRUD - Introduction14:49
An introduction to CRUD - what is it?
CRUD - Intro - Text follow-up1:37
Text follow-up for introduction to CRUD lecture
Create action17:11
Build the create action for the To Do app
Create action - Text lecture0:59
Text lecture follow-up to create action
Read9:59
Implement Read action for app
Read - Text lecture0:55
Text lecture follow-up to Read action
Update action19:59
Implement update action for the app
Update action - Text lecture2:36
Text lecture follow-up to update action video
Delete action12:14
Implement the delete action for to-do's
Delete action - Text lecture0:57
Text follow-up to delete action video

Introduction to authentication10:10
Intro to authentication - what is it?
Intro to authentication - Text lecture1:37
Text lecture follow-up to introduction to authentication
Complete user sign-up9:45
Continue with and complete signing up users
Complete user sign-up - Text lecture1:03
Text lecture follow-up to signing up users
Login users12:18
Implement log in and log out functionality
Login users - Text lecture1:23
Text lecture follow-up to log in and log out video
Enforce log in for app7:49
Add requirements to users to be logged in
Enforce log in - Text lecture0:45
Text lecture follow-up to enforcing log in
Sessions17:15
Implementing and working with Sessions
Sessions - Text lecture1:33
Text lecture follow-up to working with sessions

Requirements

No prior experience required
A browser and internet connection
Some prior experience in web technologies will be helpful but not necessary

Description

Novice to professional database developer in 4 weeks!

Establish the strongest possible foundation in database development by learning how to use MySQL - the most popular open source database in the world - write queries, create reports at will, build web applications, incorporate MySQL as the database layer - make your development dreams a reality by taking this course and putting a check mark next to your growing development skillset.

Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today's workplace. This course gives you that skill. You'll start with the absolute basics of installing and creating databases and work your way through building web applications with MySQL as the database, by the end of this course you'll be able to apply what you have learnt and do virtually anything you want with databases.

Regardless of whether you have experience with flashy new frameworks which try (and fail) to abstract the core of database queries, understanding and having the ability to manipulate these abstractions at will is fundamental to becoming a professional developer - which learning MySQL accomplishes!

This course has it all -

- Setting up MySQL, working with online IDE's

- Creating Databases and Queries

- Using logical operators, manipulating tables/rows/data

- Learning how joins work and using them at will

- Building web applications with PHP, HTML and CSS along with MySQL as the database layer

- Performing CRUD and authentication from web applications

- Creating admin features and deploying to production

- Responsive support in Q & A and FREE LIVE HELP chatline!

I'm so confident that you'll enjoy what you learn in this course that there is a no-questions asked 30-day money back guarantee (from the date of purchase). So what are you waiting for? Join today and I'll see you in the course!

Who this course is for:

Anyone interested in learning MySQL and Database techonologies
Anyone interested in getting a job as a MySQL Developer
Anyone interested in building web applications
Anyone interested in making a career change to Tech industry

The Complete MySQL Developer Course

What you'll learn

Explore related topics

Course content

Introduction to the course and MySQL7 lectures • 35min

Creating Databases and Introduction to Queries27 lectures • 1hr 55min

Logical operators and dates18 lectures • 1hr 19min

Update and delete rows6 lectures • 20min

Multiple tables and JOINS22 lectures • 1hr 36min

Web apps - Data collection from a survey22 lectures • 2hr 3min

CRUD and PHP10 lectures • 1hr 21min

Authentication with PHP and MySQL10 lectures • 1hr 4min

Challenge section - Build a WebAdmin site5 lectures • 10min

Deploy to production2 lectures • 2min

Requirements

Description

Who this course is for: