Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Learn MySQL From Scratch to your Wishlist.

Add to Wishlist

Learn MySQL From Scratch

Learn to use MySQL like professional web developers. Real life projects included.
3.7 (9 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.
294 students enrolled
Last updated 5/2016
English
$10 $75 87% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • A computer
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.

Who is the target audience?
  • Web developers
  • Web designers
  • Programmers
  • Aspiring web developers/designers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 04:58:12
+
Introduction to MySQL
4 Lectures 29:04

A quick introduction to what MySQL is.

Download the source code for the entire course here.

Preview 06:00

Learn how to install MySQL here.

Preview 07:27

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

Accessing the MySQL Monitor
06:42

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

Using PHPmyAdmin
08:55
+
The Basics of MySQL
15 Lectures 01:52:56

Now let us learn the basics of creating databases.

Creating Databases
06:40

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

Deleting Databases
04:33

How to create tables

Creating Tables
07:51

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

Listing and Describing Tables
04:38

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

Inserting Records
09:42

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

Selecting Records
07:05

How to rename tables

Renaming Tables
01:27

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

Auto Increment IDs
10:02

Working with Record updates

Updating Records
09:11

How to delete records will be discussed in this lesson.

Deleting Records
02:10

Here students learn how to set limit to record views.

Limiting Records
08:27

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

Ordering Records
06:39

How to join tables.

Joins
16:13

Another MySQL workbench on using Like clauses.

Like Clause
07:24

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

Counting Records
10:54
+
Introduction to MySQL and PHP
2 Lectures 11:02

A quick introduction on MySQLi

Introduction to MySQLi
05:46

Learn about the functions of PHP Data Objects

Introduction to PHP Data Objects
05:16
+
MySQLi Basics
9 Lectures 01:17:32

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

Getting Connected
08:58

Working with Basic Queries

Basic Queries
05:37

Getting Results

Getting Results
09:06

How to loop through results

Looping Through Results
08:24

Getting Result counts.

Getting Result Counts
03:43

Working with Variables in Queries

Variables in Queries
08:43

Working with MySQL injections.

SQL Injections
16:22

Escaping Values

Escaping Values
06:54

Working with Prepared statements

Prepared Statements
09:45
+
Project | Creating a Database Wrapper
4 Lectures 47:10

Introduction to Database Wrapper creation.

Introduction
04:46

Creating a table database will be learnt here.

Creating a Test Database
02:05

Learn about its basic functions.

Basic Functionalities
18:28

More on functionalities.

Adding More Functionalities
21:51
+
Project | Building a Contact Form
4 Lectures 19:55

Introduction on how to build a contact form

Introduction
01:43

Creating the table.

Creating the Table
01:07

How to insert records.

Inserting Your Records
06:11

Create the data output

Outputting the Data
10:54
+
Conclusion
2 Lectures 00:35

Thanks for taking the course!

Conclusion
00:13

Request a Course
00:22
About the Instructor
4.2 Average rating
11,190 Reviews
229,006 Students
185 Courses
220,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.

Report Abuse