MySQL Fundamentals

MySQL Fundamentals
Product Code: MYSQLFUND
Availability: In Stock
Price: R660.00

MySQL Fundamentals

PS You can change currency to see the price in your country at the top of the screen, just below the search box

2KO International delivers computer courses in dozens of countries across Africa, as well as being a leading supplier of 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

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below: