MySQLi For Beginners
Course

MySQLi For Beginners

Stone River eLearning
Updated Sep 05, 2019

Course Overview

The course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.

Benefits of MySQLi

  • An object-oriented interface
  • Support for prepared statements
  • Support for multiple statements
  • Support for transactions
  • Enhanced debugging support
  • Embedded server support

A knowledge of PHP and MySQL is recommended for this course.

Target Audience

Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.

Learning Objectives

Work with a MySQL database with PHP to build applications that depend on a database connection. This course covers all required elements of MySQLi from working with data to security.

Requirements

The learner will require a webserver (Apache or Nginx) with PHP 4.1 or greater (although a higher, preferably the latest version, is better), and MySQL installed.

Students will also require database management software such as Sequel Pro (Mac), HeidiSQL (Windows) or MySQL workbench (Linux).