The Complete MySQL Developer Course
4.3 (1,174 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12,143 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Complete MySQL Developer Course to your Wishlist.

Add to Wishlist

The Complete MySQL Developer Course

MySQL: Learn how to build Reports and work with Databases for Web Applications using MySQL and PHP
4.3 (1,174 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12,143 students enrolled
Last updated 9/2017
English
Current price: $10 Original price: $175 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 60 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Apply for jobs as junior MySQL developers
  • Build web applications using MySQL and PHP
  • Establish a solid foundation for databases and SQL
View Curriculum
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 is the target audience?
  • 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
Compare to Other MySQL Courses
Curriculum For This Course
129 Lectures
10:09:36
+
Introduction to the course and MySQL
5 Lectures 17:42

Introduction to the course

Preview 01:35

Introduce yourself to the class and learn how to get help in Q & A section and free live chat

Introduce yourself and learn how to get FREE LIVE HELP!
03:15

Why we will use an online IDE to develop code in this course

Development environment overview
01:35

Use cloud9 to sign up for development environment

Sign up for cloud based IDE for development
10:50

Text follow-up material for sign-up for cloud based IDE video

Sign up for cloud based IDE - Text lecture
00:27
+
Creating Databases and Introduction to Queries
27 Lectures 01:55:07

What is MySQL and how wide is it's reach?

Preview 01:55

How to create a database/schema

Create a Database/Schema
07:03

Text information for Create a Database/Schema video

Create a Database/Schema - Text lecture
00:56

A look at tables, structures for queries and syntax used in the course

Preview 04:45

Learn how to work with tables in databases

Working with tables
12:48

Working with tables - Text lecture
01:05

Learn how to insert data into tables

Inserting rows of data
11:49

Text follow-up to inserting rows of data video

Inserting rows of data - Text lecture
00:34

Working with select in MySQL

Select
02:57

Text follow-up for working with select video

Select - Text lecture
00:20

Working with the concat and substring operators

Concat and substring
10:40

Text follow-up lecture to working with concat and substring operators

Concat and substring - Text lecture
00:34

Homework code challenge

Homework challenge - bowling scores!
03:07

Text version of homework challenge

Homework challenge - Text version
00:32

Solution to homework assignment

Solution - bowling score challenge
10:54

Text solution to homework challenge

Solution - Text
00:24

Using scripts to develop code and running them instead of using the console

Alternate method of homework solution - script
04:02

Text description of how to run queries via scripts

Alternate method of running queries - script - Text version
00:12

A look at SQL

MySQL, Oracle, SQL Server
03:22

Learn how to use additional features like limit, order by and distinct

Limit, order by and distinct
09:14

Text follow-up to limit, order by and distinct features

Limit, order by and distinct - Text lecture
00:54

Learn how to use count, like and group by features

Count, like and group by
07:46

Text follow-up for video lecture on using count, like and group by

Count, like and group by - Text lecture
00:35

Learn how to use min and max

Min and max
06:40

Text follow-up to video lecture on min and max operators

Min and max - Text lecture
00:26

Code challenge to create a new report

Code challenge project - create a new report
11:00

Text solution to report

Code challenge project - Text version
00:30
+
Logical operators and dates
18 Lectures 01:19:48

Learn about different data types and their features

Data types in MySQL
05:20

Text lecture follow-up to video on data types

Data types in MySQL - Text lecture
01:18

Learn the details about where and how to use it, along with not equal

Where and not equal
05:19

Text lecture follow-up to where and not equal

Where and not equal - Text lecture
00:32

Working with comparison operators

Comparison operators
07:10

Text lecture follow-up to comparison operators video

Comparison operators - Text lecture
00:58

Working with or 

Or
02:06

Text lecture follow-up for working with Or 

Or - Text lecture
00:12

Working with null entries and blanks

Null and blanks
08:28

Text lecture follow-up for working with null and blank video

Null and blanks - Text lecture
00:57

Working with case

Case statements
03:27

Text lecture follow-up for working with case statements

Case statements - Text lecture
00:33

Working with date and time formats

Dates and times
06:37

Text lecture follow-up for video on working with dates and times 

Dates and times - Text lecture
00:58

More date, time and date math

Date, time and math
13:28

Text lecture follow-up to video on more date, time and math

Date, time and math - Text lecture
01:13

Final project for section 3, report on working with birthdays

Section 3 final project - Create a report on birthdays
19:35

Text solution to final project on section 3 - birthday reporting

Text solution to final project on birthday reporting
01:34
+
Update and delete rows
6 Lectures 20:50

Update rows of data in tables

Update
05:33

Text lecture follow-up to updating

Update - Text lecture
00:29

More info and usage of update

Update based on comparison
10:33

Text follow-up to more use of updates

Update based on comparison - Text lecture
01:14

How to use delete to remove data

Delete
02:43

Text lecture follow-up on how to use delete

Delete - Text lecture
00:17
+
Multiple tables and JOINS
22 Lectures 01:37:01

Learn what are primary and foreign keys

Primary keys, foreign keys
05:44

Text version of primary and foreign keys video

Primary and foreign keys - Text lecture
01:06

Setup our tables and data to work with joins

Data prep for joins
11:07

Text follow up to data prep for joins video

Data prep for joins - Text lecture
01:32

Learn about joins and using aliases

Joins and aliases
08:22

Text follow-up to Joins and aliases video

Joins and aliases - Text lecture
00:45

Joins more in-depth

More about joins
12:39

Text follow-up to more about joins video

More about joins - Text lecture
01:00

Learn about inner, left, outer and right joins

Inner, Left, Outer, Right joins
04:28

Text follow-up to video on different types of joins

Inner, Left, Outer and Right joins - Text lecture
01:17

Learn about left joins

Left outer joins
07:58

Text follow-up to video on left joins

Left outer joins - Text lecture
00:48

Code challenge to fix a bad join

Fix a bad join challenge
04:15

Text follow up to fixing a bad join challenge

Fix a bad join challenge - Text lecture
00:27

Learn about subselects

Subselects
06:54

Text follow-up to lecture on subselects

Subselects - Text lecture
00:40

Subselects more in-depth

More subselects
08:35

Text followup to video on subselects more in-depth

More subselects - Text lecture
00:53

Part 1 of final project for section 5

Section 5 - Final Project Part 1
12:39

Text solution to final project part 1

Final Project Part 1 - Text solution
00:44

Part 2 of final project for section 5

Section 5 - Final Project Part 2
04:36

Text solution to final project part 2 of section 5

Final Project Part 2 - Text solution
00:27
+
Web apps - Data collection from a survey
21 Lectures 02:03:45

Intro to building web applications

Preview 08:09

Working with HTML and CSS - web building blocks

HTML and CSS
02:33

Text follow-up to video on HTML and CSS

HTML and CSS - Text lecture
00:11

Start the web app

Start form collector project
13:28

Text follow-up to form collector project

Project start - Text lecture
02:30

Add styling to the form collector

Add styling to form
08:01

Text follow-up lecture to adding styling

Add styling to form - Text follow-up
02:33

Create a table for the app using sql

Create table
06:37

Text follow-up to creating a table with sql

Create table - Text follow-up
00:25

Create a config file along with other php

Config and other php
13:51

Text lecture follow-up to config and other php

Config and other php - Text follow-up
02:40

Complete the code for receiver.php

Complete receiver
15:21

Text lecture follow-up to complete receiver.php file

Complete receiver - Text follow-up
00:05

Start working on SQLFunctions file

Start SQL Functons
12:40

Text lecture follow-up to SQL Functions

Start SQL Functions - Text lecture
01:35

Preview the web app and steps taken 

Preview and understand steps taken for web app
15:44

Text lecture follow-up to preview web app video

Preview of web app - Text follow-up
00:23

Add a browser display for the web app

Add browser display
09:54

Text follow-up to adding browser display video

Add browser display - Text follow-up
00:44

Final project for section 6 - convert to poll

Project - Convert to poll!
04:38

Text solution to final project for section 6

Project - Solution text
01:40
+
CRUD and PHP
10 Lectures 01:22:15

An introduction to CRUD - what is it?

CRUD - Introduction
14:49

Text follow-up for introduction to CRUD lecture

CRUD - Intro - Text follow-up
01:49

Build the create action for the To Do app

Create action
17:11

Text lecture follow-up to create action

Create action - Text lecture
01:07

Implement Read action for app

Read
09:59

Text lecture follow-up to Read action

Read - Text lecture
01:01

Implement update action for the app

Update action
19:59

Text lecture follow-up to update action video

Update action - Text lecture
03:02

Implement the delete action for to-do's

Delete action
12:14

Text follow-up to delete action video

Delete action - Text lecture
01:03
+
Authentication with PHP and MySQL
10 Lectures 01:04:32

Intro to authentication - what is it?

Introduction to authentication
10:10

Text lecture follow-up to introduction to authentication

Intro to authentication - Text lecture
01:44

Continue with and complete signing up users

Complete user sign-up
09:45

Text lecture follow-up to signing up users

Complete user sign-up - Text lecture
01:18

Implement log in and log out functionality

Login users
12:18

Text lecture follow-up to log in and log out video

Login users - Text lecture
01:38

Add requirements to users to be logged in 

Enforce log in for app
07:49

Text lecture follow-up to enforcing log in

Enforce log in - Text lecture
00:54

Implementing and working with Sessions

Sessions
17:15

Text lecture follow-up to working with sessions

Sessions - Text lecture
01:39
+
Challenge section - Build a WebAdmin site
5 Lectures 10:18

Challenge section introduction and start admin site

Challenge section intro and get started
03:54

Text reference for challenge section

Challenge section intro - text reference
00:12

Day 2 items

Challenge section project day 2
01:36

Challenge section project days 3, 4 and 5

Project day 3, 4 and 5
02:35

Project day 6 and 7 leading to completion

Project day 6, 7 and completion
02:01
+
Deploy to production
2 Lectures 02:02

Deploy web apps to production using a hosting service

Deploy to production using a hosting service
01:58

Deploy to production - Text lecture
00:04
2 More Sections
About the Instructor
Rob Percival
4.6 Average rating
79,547 Reviews
395,614 Students
22 Courses
Web Developer And Teacher

Hi! I'm Rob. I have a degree in Mathematics from Cambridge University and you might call me a bit of coding geek.

After building websites for friends and family for fun, I soon learned that web development was a very lucrative career choice. I gave up my successful (and sometimes stressful) job as a teacher to work part time and today, couldn't be happier.

I'm passionate about teaching kids to code, so every summer I run Code School in the beautiful city of Cambridge. I also run the popular web hosting and design service, Eco Web Hosting which leaves me free to share my secrets with people like you.

You wouldn't believe the freedom that being a web developer offers. Sign up and find out for yourself why so many people are taking and recommending this course. I genuinely believe it's the best on the market and if you don't agree, I'll happily refund your money.

Sign up to my courses and join me in this amazing adventure today.

Mashrur Hossain
4.4 Average rating
7,084 Reviews
62,697 Students
11 Courses
Technology Professional and Entrepreneur

Hi, I'm Mashrur, I have been a technology professional for over a decade and have degrees in Computer Science and Economics

I have worked with Enterprise Software Systems throughout my career with roles played in analysis, development and management. I lead projects using both agile and waterfall methodologies and am well versed in the inner workings of the software development and delivery world.

During my career, I've realized how much I enjoyed training new hires and new team members and helping them succeed. I've dedicated a good amount of time over the last 7 years on-boarding new analysts and developers and working with them to build and maintain systems which puts me in a very unique position of knowing what new entrants to a field or subject need to succeed. I strongly believe in a focus on fundamentals and practice and not in shortcuts or gimmicks.

I'm very passionate about web application development and I prototype and build web apps in entrepreneurial pursuits. Ruby on Rails has proven to be a very strong force in this field and is especially powerful for startups looking to prototype ideas rapidly and subsequently building on that platform as the ideas catch on.

So join me for my comprehensive Ruby on Rails Developer courses as I guide you through the world of web application development using Rails and bringing your ideas to life.

Codestars by Rob Percival
4.6 Average rating
69,119 Reviews
349,153 Students
21 Courses
Teaching the Next Generation of Coders

Best-selling Udemy instructor Rob Percival wants to revolutionize the way people learn to code by making it simple, logical, fun and, above all, accessible.  But as just one man, Rob couldn’t create all the courses his students - more than half a million of them - wanted.  

That’s why Rob created Codestars.  Together, the instructors that make up the Codestars team create courses on all the topics that students want to learn in the way that students want to learn them: courses that are well-structured, super interactive, and easy to understand.  Codestars wants to make it as easy as possible for learners of all ages and levels to build functional websites and apps.