MySQL Training Philippines:

Introduction to MySQL™ Development and Administration

Course: 441
Type: Hands-On Training
Duration: 5 days

Share |

Course Benefits:

This MySQL Training course allows you to take advantage of the leading open source relational database management system that is extensively deployed around the world. MySQL runs on a variety of platforms, including UNIX/Linux, Windows and MacOS X. The combination of its low cost, ease of maintenance and high speed makes MySQL ideal for many application areas. This course provides a comprehensive introduction to the MySQL RDBMS.

You will learn how to:

  • Understand the features and benefits of MySQL
  • Understand the basics of relational databases
  • Understand the SQL and MySQL languages
  • Understand Data/Column types with regard to efficient database design
  • View a database design structure
  • Extract basic database information using the SELECT command
  • Delete or modify a database
  • Delete or modify table row data
  • Grouping query data using aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use simple functions (String, Date, Numerical)
  • Backup and restore the database
  • Understand the MySQL storage engines, transactions and concurrency
  • Administer databases with native tools like MySQL Administrator and MySQL Query Browser
  • Enhance database performance using stored procedures and triggers (NEW!)

Who Should Attend:

This course is valuable for anyone involved in administering and developing on a MySQL relational database management system (RDBMS). Basic familiarity with database concepts is helpful, but not essential.

Course Content

  • Introduction to MySQL
  • Database Design Basics
  • Normalization
  • Data Definition Language
  • Retrieving Data
  • Inserting, Modifying and Deleting Data
  • Working with Multiple Tables
  • Advanced Queries
  • Subqueries, Indexes, and Views
  • MySQL Functions
  • Concurency and Transactions
  • MySQL Administration
  • User Management and Access Privileges
  • Backup and Restore
  • Stored Procedures and Triggers

Upcoming Dates

  • April 21 - 25, 2014 (9am - 5pm)
  • Saturday Classes: April 26, May 3, 10, 17 & 24, 2014 (8:30 am - 5:30 pm)

Course Investment

Related Courses

MySQL is a registered trademark of Oracle Corporation in the United States and other countries.