The Complete MySQL Developer Course

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

4.46 (5415 reviews)
Udemy
platform
English
language
Databases
category
instructor
25,839
students
10.5 hours
content
Jun 2019
last update
$84.99
regular price

What you will learn

Apply for jobs as junior MySQL developers

Build web applications using MySQL and PHP

Establish a solid foundation for databases and SQL

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!

Content

Introduction to the course and MySQL

Introduction
Introduce yourself and learn how to get FREE LIVE HELP!
Development environment overview
IMPORTANT: Development Environment Setup - Overview
Windows - Install/setup MySQL, users and create databases
Mac - Install/setup MySQL, users and create databases
AWS Cloud - Setup MySQL, users and create databases

Creating Databases and Introduction to Queries

Power of Databases
Create a Database/Schema
Create a Database/Schema - Text lecture
Intro to tables and conventions used
Working with tables
Working with tables - Text lecture
Inserting rows of data
Inserting rows of data - Text lecture
Select
Select - Text lecture
Concat and substring
Concat and substring - Text lecture
Homework challenge - bowling scores!
Homework challenge - Text version
Solution - bowling score challenge
Solution - Text
Alternate method of homework solution - script
Alternate method of running queries - script - Text version
MySQL, Oracle, SQL Server
Limit, order by and distinct
Limit, order by and distinct - Text lecture
Count, like and group by
Count, like and group by - Text lecture
Min and max
Min and max - Text lecture
Code challenge project - create a new report
Code challenge project - Text version

Logical operators and dates

Data types in MySQL
Data types in MySQL - Text lecture
Where and not equal
Where and not equal - Text lecture
Comparison operators
Comparison operators - Text lecture
Or
Or - Text lecture
Null and blanks
Null and blanks - Text lecture
Case statements
Case statements - Text lecture
Dates and times
Dates and times - Text lecture
Date, time and math
Date, time and math - Text lecture
Section 3 final project - Create a report on birthdays
Text solution to final project on birthday reporting

Update and delete rows

Update
Update - Text lecture
Update based on comparison
Update based on comparison - Text lecture
Delete
Delete - Text lecture

Multiple tables and JOINS

Primary keys, foreign keys
Primary and foreign keys - Text lecture
Data prep for joins
Data prep for joins - Text lecture
Joins and aliases
Joins and aliases - Text lecture
More about joins
More about joins - Text lecture
Inner, Left, Outer, Right joins
Inner, Left, Outer and Right joins - Text lecture
Left outer joins
Left outer joins - Text lecture
Fix a bad join challenge
Fix a bad join challenge - Text lecture
Subselects
Subselects - Text lecture
More subselects
More subselects - Text lecture
Section 5 - Final Project Part 1
Final Project Part 1 - Text solution
Section 5 - Final Project Part 2
Final Project Part 2 - Text solution

Web apps - Data collection from a survey

Introduction to Web App Development
HTML and CSS
HTML and CSS - Text lecture
Start form collector project
Project start - Text lecture
Add styling to form
Add styling to form - Text follow-up
Create table
Create table - Text follow-up
Learn php basics
Config and other php
Config and other php - Text follow-up
Complete receiver
Complete receiver - Text follow-up
Start SQL Functons
Start SQL Functions - Text lecture
Preview and understand steps taken for web app
Preview of web app - Text follow-up
Add browser display
Add browser display - Text follow-up
Project - Convert to poll!
Project - Solution text

CRUD and PHP

CRUD - Introduction
CRUD - Intro - Text follow-up
Create action
Create action - Text lecture
Read
Read - Text lecture
Update action
Update action - Text lecture
Delete action
Delete action - Text lecture

Authentication with PHP and MySQL

Introduction to authentication
Intro to authentication - Text lecture
Complete user sign-up
Complete user sign-up - Text lecture
Login users
Login users - Text lecture
Enforce log in for app
Enforce log in - Text lecture
Sessions
Sessions - Text lecture

Challenge section - Build a WebAdmin site

Challenge section intro and get started
Challenge section intro - text reference
Challenge section project day 2
Project day 3, 4 and 5
Project day 6, 7 and completion

Deploy to production

Deploy to production using a hosting service
Deploy to production - Text lecture

Database permissions

Database permissions section doc

Stored Procedures and Scheduled jobs

Stored Procedures and Scheduled jobs section doc
Thank you!

Screenshots

The Complete MySQL Developer Course - Screenshot_01The Complete MySQL Developer Course - Screenshot_02The Complete MySQL Developer Course - Screenshot_03The Complete MySQL Developer Course - Screenshot_04

Reviews

Jatin
June 27, 2023
A very well-explained, comprehensive SQL course. More real-world problems can be added as a complete project.
Allan
January 15, 2023
I think he does a little too much copy and paste. I tend to learn better when I have to type everything and his cut and paste makes that difficult. There are also a lot of "why did you do that" questions that never get answered. It is a LOT of material, and he does a pretty good job, and of course it all works well. So far so good.
Christopher
October 25, 2022
This has been pretty good. The only real issue has been the continued development of MySQL itself, which has rendered some content incorrect.
Joe
September 15, 2022
I installed the latest version of MySQL so I believe some commands in course no longer are applicable as they have been deprecated by MySQL
Sumit
June 27, 2022
well it's an good course for beginners to move ahead and know the basics of sql queries like formatting ,spitting and many much more
Michael
June 4, 2022
Good course so far! Some inconsistencies with capitalization in queries and table column names which makes it difficult to copy & paste the longer scripts specifically for creating and updating tables.
Cesar
August 24, 2021
The teacher was great, excellent handle of the topics, very clear explanations on all the subjects, the exercises clear and useful, the only thing I would improve is too long and a complete milestone to understand all the topics.
Satyawan
July 28, 2021
as i want to prepare my self for mySql, this video course is perfect for me, every point is very clear and easily understandable
Bawiise
March 4, 2021
The best course on mysql combined with web apps. Provision of text lectures makes it easier for one to refer without having to watch a whole lecture video. It's really an amazing course.
Richard
February 24, 2018
The https://c9.io doesn't work. It was discontinued. I registered for cloud9 but there's no workspace for the course.
Michael
February 6, 2018
Outdated material. Cloud 9 is now on AWS with a completely different interface. Cannot install mysql- Type mysql-ctl install Response is command not found
Rohith
January 25, 2018
Had a great time doing this course and great hands on experience. If the instructor had explained it a bit more details I would have given this course five star rating.
Cassandra
January 19, 2018
Because this tutorial isn't updated and I've spent hours trying to figure out the updated way with no assistance.
Alex
January 16, 2018
Because I haven' t started ten minutes before I discover C9.io is under amazon and not free. I am not ready to pay additional costs for it. Learning material and alternatives have not been adapted. I am loosing my time ...
Thinsoldier
December 20, 2017
This course has some interesting examples I appreciate being exposed to. Problems: Instructor says "string" every time he meant to say "variable". I cannot put up with that. He uses fetch_array in places where it would be much more developer friendly to use fetch_assoc. Personally not a fan of his style of naming files or php functions. NO ATTEMPT TO PREVENT SQL INJECTIONS IN THE PHP CODE. Far too much PHP in this course and it is very low quality PHP. Would have preferred more SQL content like an explanation of normalization and foreign key constraints and views, innodb vs myisam, full text search, indexing to improve query speed. The instructor would need to REMOVE ALL OF THE PHP CONTENT I've seen so far to get 3 stars from me.

Charts

Price

The Complete MySQL Developer Course - Price chart

Rating

The Complete MySQL Developer Course - Ratings chart

Enrollment distribution

The Complete MySQL Developer Course - Distribution chart

Related Topics

785066
udemy ID
3/7/2016
course created date
11/11/2019
course indexed date
Bot
course submited by