Learn MySQL From Scratch

Learn to use MySQL like professional web developers. Real life projects included.
4.0 (8 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.
292 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 40
  • Length 5 hours
  • Skill Level Beginner Level
  • Languages English
  • 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 4/2014 English

Course Description

If you're new to web development, MySQL is the most popular database technology out there. This free technology is used to create the majority of database dependent websites (which most are).

This course will start at the very beginning, with lessons on what MySQL is and how it works, to installing MySQL, then moving on to all the basic skills you'll need to use MySQL in the real world. You will also learn the popular new MySQLi framework. MySQLi is the next generation of MySQL, and if you know this now you will be ahead of the competition for a long time to come.

Projects

This course also includes two real life projects. After you've gained an understanding of how MySQL works, you'll learn how this technology is used on real websites.

What are the requirements?

  • A computer

What am I going to get from this course?

  • Learn how MySQL works in the real world
  • Install MySQL
  • Learn about the new MySQLi framework
  • Understand working with databases
  • Complete two real life MySQL projects
  • Learn how MySQL and PHP work together

What is the target audience?

  • Web developers
  • Web designers
  • Programmers
  • Aspiring web developers/designers

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 MySQL
06:00

A quick introduction to what MySQL is.

Download the source code for the entire course here.

07:27

Learn how to install MySQL here.

06:42

Here you will gain access to the MySQL monitor.and start working around it.

08:55

In this tutorial, students will learn how to setup MySQL using PHPmyAdmin.

Section 2: The Basics of MySQL
06:40

Now let us learn the basics of creating databases.

04:33

This time, let us look into how a database can be deleted.

07:51

How to create tables

04:38

In this lessson, learn how to list and describe tables.

09:42

Here we will look into another important function of MySQL, that is, inserting records.

07:05

Working with record selection will be taught in this video tutorial.

01:27

How to rename tables

10:02

Learn how to add the Auto Increment setting to a MySQL table column through phpMyAdmin.

09:11

Working with Record updates

02:10

How to delete records will be discussed in this lesson.

08:27

Here students learn how to set limit to record views.

06:39

The step-by-step process of ordering records will be discussed here.

16:13

How to join tables.

07:24

Another MySQL workbench on using Like clauses.

10:54

Learn how to count the number of records in a table and return the total in a couple of different ways.

Section 3: Introduction to MySQL and PHP
05:46

A quick introduction on MySQLi

05:16

Learn about the functions of PHP Data Objects

Section 4: MySQLi Basics
08:58

Connecting a MySQL database to PHP Data Objects will be discussed in this tutorial.

05:37

Working with Basic Queries

09:06

Getting Results

08:24

How to loop through results

03:43

Getting Result counts.

08:43

Working with Variables in Queries

16:22

Working with MySQL injections.

06:54

Escaping Values

09:45

Working with Prepared statements

Section 5: Project | Creating a Database Wrapper
04:46

Introduction to Database Wrapper creation.

02:05

Creating a table database will be learnt here.

18:28

Learn about its basic functions.

21:51

More on functionalities.

Section 6: Project | Building a Contact Form
01:43

Introduction on how to build a contact form

01:07

Creating the table.

06:11

How to insert records.

10:54

Create the data output

Section 7: Conclusion
00:13

Thanks for taking the course!

Request a Course
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Stone River eLearning, 200,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 370,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.

Ready to start learning?
Take This Course