MySQL Essentials 2 Training

General Course Description

This instructor led hands on training course focuses on the second half of the essentials training course of MySQL and is an EXCELLENT training to the world's most powerful, friendly and most popular open source database. Students will get over 8+ hours of hands-on-labs! The labs account for over 80% of the class and allows the student to learn FIRST hand from real world scenarios. Your instructor is a former Sun Microsystems employee & a MySQL Certified DBA & have a minimum of 10 years of MySQL deployment experience.

Course Details: MySQL Essentials 2

Class Details

Who Should Attend
  • Sales Engineers
  • Systems Engineers
  • Database Administrators
  • IT Managers
  • Developers
  • Prerequisites
  • Basic understanding of databases - helpful but NOT necessary.
  • Understanding of installing and uninstalling programs.
  • Basic knowledge of the Internet, networks and ports.
  • Have read and know a little about MySQL.
  • Basic grasp of command line execution syntax and editors.
  • Course Outline

    Module 1 - Modeling and Designing MySQL Databases

  • Good and Bad database designs
  • Basic Database Design Process
  • Entity Relationship Model Overview
  • Common database design tools
  • Considerations when designing your database

  • Module 2 - Advanced MySQL Querying

  • Must know MySQL querying commands
  • Aliases
  • Joins and why use joins
  • Nested Queries Overview
  • MySQL Locking fundamentals and tips

  • Module 3 - Managing Users and Privileges

  • MySQL Users & Privileges
  • Creating, editing and deleting users
  • Overview of GRANT
  • Understanding MySQL Privileges
  • Performance considerations

  • Module 4 - Stored Routines, Triggers and Events

  • What are routines or stored procedures
  • Benefits of stored routines and when to use them
  • Overview of triggers
  • When and why to use triggers
  • Events overview and usage

  • Module 5 - Database and Table Management

  • When, why and how to manage your database & tables
  • Basic database and table management techniques
  • Using databases as query repositories
  • Creating temporary tables
  • Database engines and changing engines

  • Module 6 - Basic MySQL configuration and tuning

  • A look at the MySQL server daemon
  • Modifiable server settings
  • Operating system setting to consider
  • Built in tools to improve performance
  • Creating simple benchmarks