MySQL Introduction

32 Hours / 180 Days / Mentor Supported

Course Overview:

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.

ATTENTION: This course has a strict start and end date.  When a student enrolls into this course, they will need to work with one of our Training Assessment Managers (TAMs) to choose a start date before they can be enrolled in their course.

Course Outline:

  • 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.

 

All necessary materials are included.


System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.


**Outlines are subject to change, as courses and materials are updated.**