MySQL Fundamentals Online Courses in Kenya
2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification.
THIS ONLINE COURSE IS TEMPORARILY UNAVAILABLE
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. 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).
Introduction to the Course
What Is MySQL
Accessing the MySQL Monitor
The Basics of MySQL
Listing and Describing Tables
Auto Increment IDs
Introduction to MySQL and PHP
Introduction to MySQLi
Introduction to PHP Data Objects
Getting Result Counts
Looping Through Results
Variables in Queries
Project | Creating a Database Wrapper
Creating a Test Database
Adding More Functionalities
Project | Building a Contact Form
Creating the Table
Inserting Your Records
Outputting the Data