The Complete MySQL Developer Course

Learn how to build Reports and work with Databases for Web Applications using MySQL and PHP
4.4 (672 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.
8,258 students enrolled
$19
$175
89% off
Take This Course
  • Lectures 129
  • Length 10 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2016 English Closed captions available

Course 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!

What are the requirements?

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

What am I going to get from this course?

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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to the course and MySQL
01:35

Introduction to the course

03:15

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

01:35

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

10:50

Use cloud9 to sign up for development environment

Article

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

Section 2: Creating Databases and Introduction to Queries
01:55

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

07:03

How to create a database/schema

Article

Text information for Create a Database/Schema video

04:45

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

12:48

Learn how to work with tables in databases

Working with tables - Text lecture
Article
11:49

Learn how to insert data into tables

Article

Text follow-up to inserting rows of data video

02:57

Working with select in MySQL

Article

Text follow-up for working with select video

10:40

Working with the concat and substring operators

Article

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

03:07

Homework code challenge

Article

Text version of homework challenge

10:54

Solution to homework assignment

Article

Text solution to homework challenge

04:02

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

Article

Text description of how to run queries via scripts

03:22

A look at SQL

09:14

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

Article

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

07:46

Learn how to use count, like and group by features

Article

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

06:40

Learn how to use min and max

Article

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

11:00

Code challenge to create a new report

Article

Text solution to report

Section 3: Logical operators and dates
05:20

Learn about different data types and their features

Article

Text lecture follow-up to video on data types

05:19

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

Article

Text lecture follow-up to where and not equal

07:10

Working with comparison operators

Article

Text lecture follow-up to comparison operators video

02:06

Working with or 

Article

Text lecture follow-up for working with Or 

08:28

Working with null entries and blanks

Article

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

03:27

Working with case

Article

Text lecture follow-up for working with case statements

06:37

Working with date and time formats

Article

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

13:28

More date, time and date math

Article

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

19:35

Final project for section 3, report on working with birthdays

Article

Text solution to final project on section 3 - birthday reporting

Section 4: Update and delete rows
05:33

Update rows of data in tables

Article

Text lecture follow-up to updating

10:33

More info and usage of update

Article

Text follow-up to more use of updates

02:43

How to use delete to remove data

Article

Text lecture follow-up on how to use delete

Section 5: Multiple tables and JOINS
05:44

Learn what are primary and foreign keys

Article

Text version of primary and foreign keys video

11:07

Setup our tables and data to work with joins

Article

Text follow up to data prep for joins video

08:22

Learn about joins and using aliases

Article

Text follow-up to Joins and aliases video

12:39

Joins more in-depth

Article

Text follow-up to more about joins video

04:28

Learn about inner, left, outer and right joins

Article

Text follow-up to video on different types of joins

07:58

Learn about left joins

Article

Text follow-up to video on left joins

04:15

Code challenge to fix a bad join

Article

Text follow up to fixing a bad join challenge

06:54

Learn about subselects

Article

Text follow-up to lecture on subselects

08:35

Subselects more in-depth

Article

Text followup to video on subselects more in-depth

12:39

Part 1 of final project for section 5

Article

Text solution to final project part 1

04:36

Part 2 of final project for section 5

Article

Text solution to final project part 2 of section 5

Section 6: Web apps - Data collection from a survey
08:09

Intro to building web applications

02:33

Working with HTML and CSS - web building blocks

Article

Text follow-up to video on HTML and CSS

13:28

Start the web app

Article

Text follow-up to form collector project

08:01

Add styling to the form collector

Article

Text follow-up lecture to adding styling

06:37

Create a table for the app using sql

Article

Text follow-up to creating a table with sql

13:51

Create a config file along with other php

Article

Text lecture follow-up to config and other php

15:21

Complete the code for receiver.php

Article

Text lecture follow-up to complete receiver.php file

12:40

Start working on SQLFunctions file

Article

Text lecture follow-up to SQL Functions

15:44

Preview the web app and steps taken 

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rob Percival, 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.

Instructor Biography

Mashrur Hossain, 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.

Ready to start learning?
Take This Course