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.
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.
A quick introduction to what MySQL is.
Download the source code for the entire course here.
Here you will gain access to the MySQL monitor.and start working around it.
In this tutorial, students will learn how to setup MySQL using PHPmyAdmin.
Now let us learn the basics of creating databases.
This time, let us look into how a database can be deleted.
How to create tables
In this lessson, learn how to list and describe tables.
Here we will look into another important function of MySQL, that is, inserting records.
Working with record selection will be taught in this video tutorial.
How to rename tables
Learn how to add the Auto Increment setting to a MySQL table column through phpMyAdmin.
Working with Record updates
How to delete records will be discussed in this lesson.
Here students learn how to set limit to record views.
The step-by-step process of ordering records will be discussed here.
How to join tables.
Another MySQL workbench on using Like clauses.
Learn how to count the number of records in a table and return the total in a couple of different ways.
A quick introduction on MySQLi
Learn about the functions of PHP Data Objects
Connecting a MySQL database to PHP Data Objects will be discussed in this tutorial.
Working with Basic Queries
How to loop through results
Getting Result counts.
Working with Variables in Queries
Working with MySQL injections.
Working with Prepared statements
Introduction to Database Wrapper creation.
Creating a table database will be learnt here.
Learn about its basic functions.
More on functionalities.
Introduction on how to build a contact form
Creating the table.
How to insert records.
Create the data output
Thanks for taking the course!
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 450,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.