Learn MySQL From Scratch
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.
297 students enrolled
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.
297 students enrolled
Last updated 2/2017
English
Current price: $10 Original price: $75 Discount: 87% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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 42 Lectures Collapse All 42 Lectures 04:59:24
+
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
+
Bonus Material
2 Lectures 01:17
Bonus Lecture: Certificate of Completion
01:03

Bonus Lecture: Course Discounts
00:14
About the Instructor
Stone River eLearning
4.3 Average rating
13,853 Reviews
249,913 Students
195 Courses
240,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.