MySQL database, MySQLi class, Essentials and Much Much More
4.4 (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.
93 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL database, MySQLi class, Essentials and Much Much More to your Wishlist.

Add to Wishlist

MySQL database, MySQLi class, Essentials and Much Much More

MySQL database design, maintenance and operation
4.4 (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.
93 students enrolled
Created by OnlyKiosk Tech
Last updated 1/2016
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to design a database and its tables
  • Learn data types used by MySQL
  • Learn how to properly connect to database, including how to detect and deal with connection failure
  • Learn CURD operations using MySQLi class
  • Learn Transaction
  • Learn prepared statement
  • Learn how to create new MySQL users
  • Learn how to back up and re-install a database
  • Learn how to do Pagination
  • Learn how to use UNION and JOIN to retrieve data
View Curriculum
Requirements
  • You need to have a basic understanding of OOP
  • You should know how to call class methods and use class properties
  • You should install WAMP or other PHP MySQL development environment
Description

A little more than a year ago, MySQL extension finished its historical mission and retired.

For PHP programmers, this means if they still want to use MySQL database, they only have two choices: using MySQLi or using PDO.

This course will teach you everything a back-end developer needs to know about operating MySQL database using MySQLi.

But considering many new students also have either no or a very weak foundation in MySQL database, therefore, this course will first teach you all the fundamental knowledge about MySQL database.

Learning database operations takes time and practice, this course is doing everything it can to make learning MySQL as effortless as possible. All the important and confusing parts have been adequately emphasized so that you can avoid traps new learners often fall into.

Who is the target audience?
  • This course is for anyone who wants to learn how to use MySQL database
  • This course is for anyone who wants to learn how to operate MySQL database using MySQLi class
Students Who Viewed This Course Also Viewed
Curriculum For This Course
51 Lectures
04:11:04
+
Things You Must Know Before Learning Database Operation
2 Lectures 08:10

Before you can operate a database using any methods, you must have a clear understanding of the structure of the MySQL database, just like before you learn how to drive, you must know what a car is for

Preview 05:05

Before you can operate a database, you just have to know its structure.

As a back-end developer, you will often need to create a database for your project, before you can design and create a database, you must have a clear understanding of MySQL database structure

The structure of a database
03:05
+
PHPMyAdmin
2 Lectures 04:01

there are many third party tools that can help us manage MySQL database. PHPMyAdmin is one of the most popular choices. Hosting service providers like godaddy even offers one-key installation for PHPMyAdmin.

What is PHPMyAdmin
01:48

Let's create a new database using PHPMyAdmin.

Demonstration: create a database using PHPMyAdmin
02:13
+
Data Types Used by MySQL and what is CURD
4 Lectures 21:14

For better efficiency, easier management, and higher safety, MySQL uses different data types to store different kinds of data.

If you want to create a database table, then you just have to know data types used by MySQL database.

Data types used by MySQL database
09:21

To design a workable database, what you need to know and what kinds of principles you just have to follow?

How to design a table and principles you should follow
05:17

What does the word CURD mean?

What is CURD?
01:20

Let's create our first database table.

Demonstration: using PHPMyAdmin
05:16
+
Get Connected to Database Properly
3 Lectures 07:46

Getting connected to database is the first step of operating database. We will learn how to use methods provided by MySQLi class to connect to database.

But you should also prepare for connection failure.

Preview 06:16

Let's get connected to the database using MySQLi properly. Getting connected properly means we should also prepare for connection failures.

Preview 01:30

Class PPT.

Class Resource: database connection
18 pages
+
Create, Update, and Delete
6 Lectures 29:40

First CURD: C

Put data into the database

INSERT: put data into the database
04:20

demonstration of putting data into the database using MySQLi

Demonstration: inserting a new row into the database using MySQLi
10:32

what is SQL injection and how do we protect our database from it

SQL Injection, the hazard the and the countermeasure
02:58

How do you find out the ID of the row you just inserted?

Demonstration: protect database against SQL injection
02:09

Change the value of data stored in database, and delete rows from database table

Preview 04:33

Let's update the field value and delete a few rows from the table.

Demonstration: update field values and delete rows
05:08
+
Retrieve: retrieve and unpack
6 Lectures 16:30

the first step of retrieving data from database: getting the object that contains everything

Retrieve Data- first step: get the object
04:49

Let's retrieve the object and var_dump it!

Demonstration: retrieve the object
02:44

You retrieve data to display them, so how to do the unpacking and display the retrieved data in a user-friendly way?

Retrieve Data: second step: unpacking
03:46

Let's unpack the object and display those retrieved data.

Demonstration: unpack the object and display the data
05:11

Class PPT

Class Resource: retrieve object
12 pages

Class PPT

Class Resource: unpack
8 pages
+
Retrieve information about data stored in database
4 Lectures 18:07

Sometimes, you do not care the value stored in the database, you need to analyze the data stored in database and draw a conclusion

Preview 04:00

a great helper when analyzing data stored in database

Demonstration: analyzing data using statistical functions
07:05

another great tool MySQL offered us

GROUP BY: the greatest MySQL feature
02:14

Let's find out why GROUP BY is so great!

Demonstration: using GROUP BY
04:48
+
Using ALIAS and Dealing with TWO tables simultaneously
5 Lectures 12:52

using Alias can make your SQL statement look much more concise and neat

ALIAS for field/table name and statistical functions
01:04

Let's set ALIAS for table names and field names!

Demonstration: using alias
01:38

sometimes, one table is just not enough. so how to retrieve from two tables simultaneously?

Retrieving data from two tables simultaneously
03:57

Let's find our what all the commodities each seller sells.

Demonstration: retrieving data from two tables simultaneously
06:13

Class PPT

Class Resource: two tables
6 pages
+
Pagination
3 Lectures 16:22

If there were one thousand rows matching your searching condition, you cannot retrieve and display all those rows in one try.

Pagination can divide a very heavy task into several small tasks.

Your server is happy and your user will have a better experience as well.

Pagination: theory and program design
03:59

Let's create our very first pagination program!

Demonstration: creating a pagination program
12:23

Class PPT

Class Resource: Pagination
7 pages
+
Transaction
2 Lectures 12:03

Transaction is a great tool that help protect database data from being damaged by accidents

Imagine you work for a bank: TRANSACTION
07:03

Let's create a program that can safely transfer $1,000 from Mr.Only to Mr.Kiosk!

Demonstration: transfer $1000 from Mr. Only to Mr. Kiosk SAFELY
05:00
5 More Sections
About the Instructor
OnlyKiosk Tech
4.8 Average rating
295 Reviews
10,928 Students
5 Courses
Making Your Efforts More Effective

No matter where and whom you take your lessons from, you will always have to do all the hard work yourself.

You have to spend time and efforts learning, understanding, memorizing and practicing new knowledge. This is NO short-cut here.

But a good course can show the best route and help you avoid traps and detours. You can achieve maximum productivity from your time and efforts.

Based on user feedback, tech development, and our new thoughts and inspirations, we will keep adding new contents and improving existing ones.

We will cover basics as well as advanced applications. You will learn smart and creative tech combinations as well.

Web development has been a popular area for years. The internet has accumulated tons of free tutoring videos and materials.

Even if you are stuck with questions you cannot solve, just post them on stackoverflow, you will have your answers within a few minutes.

With all the free tutoring materials and teachers, what is the point of creating this paid online course?

It depends on what you really want.

If you just want to have a rough idea of how web apps work and create some basic programs, then there is really no need for you to pay for any courses. Free internet information is more than enough to meet your demands.

If you want to be able to turn your design and idea into programs that are safe and efficient enough to be applied in real life and solve all kinds of challenge, then this course is perfect for you.  

We believe a good online course should also be a navigator, not just explaining coding concepts.

It should show you where the real destination is and most importantly, take you there in the most efficient way.  

Why we emphasize real destination?

First of all, you should know a program that can work is very different from a program that can survive in real life.

This is like playing a racing game on your phone is definitely not the same as driving a real car on a real track.

For example, in our PHP lesson, we will teach you how to create an upload program.

We have seen books and courses that only teach how to upload files.

If you run that program in real life, it will not last a day. It will do more damage than good.

For an upload program to work in real life, you need to check file type and size before letting any file being uploaded.

You also need to protect your program from uploading the same file repeatedly by keeping refreshing the uploading page.  

Uploaded files should be properly renamed and stored. Most importantly, this process must be automatic.

Uploaded files must also be retrievable, therefore information about uploaded files should also be automatically recorded into database.

If one step is missing, your upload program will not survive the real life environment.

This is why we emphasize real destination. We want to show you the whole picture, rather than just a segment of it.

Knowing the whole picture is what separates a trustworthy professional programmer from a coding amateur.

Apparently the road to the real destination is quite long.

This is why a good course should be a navigator. It should show students the best route.

When designing our course contents, we acknowledge and most importantly, take in consideration two very important facts:

Everybody forgets and you have other things going on in your life and can only partly devote to your study.

This means your study will be constantly interrupted and when you resume your study, you might find what you have learnt has become rusty.

As a result, all your new knowledge are built on a collapsing foundation. At the end of your study, you will find that despite you have spent time and money, but you just cannot make satisfactory progress. You thought you have learnt everything but just cannot put them together can create a functional program.

So how do we solve this problem?

We divide our whole course content into small segments. At the end of each segment, there will be a review session summarizing everything you have learnt from that session.

When you are creating APPs, we will give a review session on key knowledge as well.

Apart from review sessions, we will also help you control your study pace. You will often hear we tell you that if you cannot answer this quiz, do not proceed and review previous lessons.

The biggest card up our sleeve is our content table.

You might think our upload program lesson starts here. But actually our upload lesson has started long before that. We have started to lay foundations for you since we teach you how to create a file type detector.

We divide a complicated program into components and will only add one component at a time. Most importantly, every time we add a new component, we will review the previous components again.

In the very end, despite the program we are creating is long and complicated, you will be able to master everything.