MySQL Introduction

Next start date:

9/8/2010 - 10/27/2010 Enroll Now

You can enroll up to 10 days after the start date of the class.

Price: $249

This course will give students the skills they need to set up and manage a MySQL database. Students will learn the basics of designing a relational database and learn to use SQL statements to create databases, tables and manage data in the data tables. Students will create a MySQL database and will identify the types of data that can be stored in data tables. Students will use the PHPMyAdmin tool to view and manage their MySQL databases. Students will learn to write applications which use MySQL databases.

For questions about enrolling, please contact the ClassroomManager@InteractiveOnlineClassroom.com.

Course Objectives

Students will install MySQL, connect to the MySQL database application and create a database and set up users for their database.
Students will design a relational database.
Students will use MySQL commands to define a database and tables.
Students will add records to their database, edit records, delete records and select records.
Students will use MySQL functions to work with database data.
Students will explore tools, applications and programming environments that work with MySQL.
Students will work with transactions and advanced SQL queries.
Students will explore feature that are new to MySQL 5.
Students will use the MySQL Adminitrator to perform database maintenance.
Students will create a final project using what they learned in the course.