Introduction to MySQL™ Development and Administration

MySQL Training Philippines

Course: 441

Type: Hands-On Training

Duration: 5 days

Courses 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

  • November 17 - 21, 2014 (9am - 5pm)
  • Saturday Classes: November 8, 15, 22, 29 & December 6, 2014 (9:00 am - 5:00 pm)

Course Investment

For pricing info, call us at +632-726-8128 or Email us.
Money Saving Tuition Plans

REQUEST MORE INFO ENROLL NOW!
Testimonials

“The course is great. I've come to appreciate SQL even more. Excellent instructor. He is able to explain all the topics very clearly. The content of the course covered most of the basics to get us started in mysql. The hand-out will be an indespensible tool for us.”
- Melvin Ambrosio, GMA Network

“The instructor is very knowledgeable on the subject. His approach is easily understood. All workshops helped me understand fully the commands and syntax.”
- George Gavin, Systems Officer IV - Philippine Exporters Confederation, Inc.

“The course is well organized and very easy to understand. The instructor has a very good teaching method, he connects very well with his students. He uses terms that are easy to understand and he provides helpful examples.”
- Allan San Juan, Hewlett Packard Asia Pacific HK

“I like the completeness and the straight to the point instructions, the course was very easy to learn, interaction between the instructor and student was dynamic.”
- Ralph Aldover kgb Philippines

“The instructor is patient and understanding with his students' skills and technical background. He has full grasp of the course he's teaching. He can answer questions well and relate it to real-life applications.”
- Dan Leonard Rayo , Samba Tech

“I learned something new in each chapter that I could definitely apply to my work.”
- Nathan C. Obregon, Philamlife

More Testimonials...

Enrolling entitles you to...
  • Class participation
  • Team workshops
  • Use of in-class and hands-on equipment
  • Course CD
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate