MySQL for Developers

     This course teaches the student how to create a Relational Database Management System (RDBMS) using MySQL. The student will be instructed on how to create a new database and maintain it. Once we have created a database we will utilize it through standard SQL queries for updates, inserting new data and deleting data. MySQL is a popular RDBMS used in the Open Source Community that is very cost effective.

Topics Covered

    General MySQL Use

  • Introduction to MySQL and SQL
  • Working with Data in MySQL
  • MySQL SQL Syntax and Use
  • Query Optimization

    Using MySQL Programming Interfaces

  • Introduction to MySQL Programming
  • The MySQL C API
  • The Perl DBI API
  • The PHP API

    MySQL Administration

  • Introduction to MySQL Administration
  • The MySQL Data Directory
  • General MySQL Administration
  • Security
  • Database Maintenance and Repair

Audience:

     This course is designed for individuals that are new to the administration of a MySQL database.

Prerequisites:

Benefits:

     Student will be able to administer a MySQL RDBMS for their company and understand how to mine information from this database. This course provides the foundation to build on more advanced topics incorporating MySQL into 3 tier solutions.

Furnished Materials:

  • Student Manual
  • Sample databases
  • MySQL by Paul DuBois
    (New Riders)

Recommended Follow-On Course

Length:

  • 5 Days

Price:

  • $2,475

Training Dates:

Sign Up