MySQL Fundamentals Online Course

MySQL Fundamentals Online Courses in South Africa

2KO Africa is a network of companies that offers a substantial series of computer courses across the entire African region, and is a leading provider of internationally recognised online IT training, online, IT training from the comfort of home or work. 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. 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

Installing MySQL

Accessing the MySQL Monitor

Using PHPmyAdmin

 

The Basics of MySQL

Creating Databases

Deleting Databases

Creating Tables

Listing and Describing Tables

Auto Increment IDs

Inserting Records

Selecting Records

Renaming Tables

Deleting Records

Updating Records

Ordering Records

Limiting Records

Joins

Like Clause

Counting Records

 

Introduction to MySQL and PHP

Introduction to MySQLi

Introduction to PHP Data Objects

 

MySQLi Basics

Getting Connected

Basic Queries

Getting Results

Getting Result Counts

Looping Through Results

SQL Injections

Variables in Queries

Escaping Values

Prepared Statements

 

Project | Creating a Database Wrapper

Introduction

Creating a Test Database

Basic Functionalities

Adding More Functionalities

 

Project | Building a Contact Form

Introduction

Creating the Table

Inserting Your Records

Outputting the Data