Course Outline
Upon completing this course, the learner will be able to meet these overall objectives:

  • To use SQL to output reports with MySQL
  • To modify MySQL data with SQL
  • To create a simple MySQL database
  • To create simple work with Views and Stored Procedures in MySQL
  • To create tables in MySQL
  • Course Overview
  • Introduction to MySQL
  • Designing Databases
  • Basic SQL
  • Database Structures
  • Advanced MySQL Concepts
  • Managing Users and Privileges
  • Backing Up and Restoring MySQL Databases
  • MySQL Options File and Configuring and Tuning the MySQL Server
  • Setting Up MySQL Replication