Visit Vibenet, your one-stop education center

 

 
 Vibenet Pte Ltd.

We want to help make you succeed in the fast-paced world of technology. That is why, we, at Vibenet, are committed to providing customized courses uniquely tailored for each individual person or business. We want to be your one-stop education center. Because we understand that you would rather deal with one than many, we want to provide you courses that will help you and your business succeed. We provide both scheduled short courses for individuals and groups as well as custom courses for your company's training needs. We specialize in programming courses in software engineering essentials, object-oriented software engineering, Java, C++, UML, mobile application development, Android development, JavaScript, PHP/ MySQL, Advanced MySQL, Perl, Oracle, and Ruby on Rails. We also can customize a course directly for your company. And we can be there every step of the way.

 Vibenet Pte Ltd.
 Your one-stop
 education center.

 For more info on how 
 Vibenet can serve
 you, contact:
 

my@vibenet.com.sg
   

 

Advanced MySQL  

Learning Objectives

This course Advanced MySQL will cover advanced topics on MySQL database concepts and administration. Participants will learn the fundamentals required to install, configure, administer, and tune MySQL as a database. This course reviews basic SQL structure and database concepts, and it also examines advanced concepts like setting up and securing users, tuning operations, and performing replication and backups.  

Upon completion of this course, the participants will learn:

* Storage engine and indexing;
* Query and server performance tuning;
* Advanced server configuration and database designs;
* Replication and load balancing;
* Backups and security, user access and privileges.
 

Course Topics

DAY 1:
MySQL Introduction
* Who Owns MySQL? Is it open source?
* Why to use MySQL?
* Who are using MySQL?
* Past, Present & Future features of MySQL
MySQL Storage Engines
* MySQL Architecture
* Locking and Concurrency
* Transactions
* Selecting the Right Engine
* The Storage Engines
Indexes
* Indexing Basics
* Index Structures
* Indexes and Table Types
* Index Maintenance
Hands-on sessions on MySQL Indexing

DAY 2:
Query Performance
* Query Processing Basics
* Optimizer Features and Oddities
* Identifying Slow Queries
* Influencing MySQL with Hints
* Stupid Query Tricks
Server Performance Tuning
* Performance-Limiting Factors
* RAID
* Operating System
* Techniques
Replication
* Replication Overview
* Configuring Replication
* Under the Hood
* Replication Architectures
* Administration and Maintenance
* Common Problems
* The Future of Replication
Hands-on sessions on MySQL performance and replication

DAY 3:
Load Balancing
* Load Balancing Basics
* Configuration Issues
* Cluster Partitioning
* High Availability
Back-up & Recovery
* Why Backups?
* Considerations and Tradeoffs
* Tools and Techniques
* Rolling Your Own Backup Script
Security
* Account Basics
* The Grant Tables
* Grant and Revoke
* Operating System Security
* Network Security
* Data Encryption
* MySQL in a chrooted Environment
Hands-on sessions on MySQL balancing, backup, and security

 

Instructor

Ankur Patel holds a master degree in computer from Utah State University, USA. He has software development experience for over a decade using open source technologies like Linux, Perl, PHP, RoR, Java etc. He has worked with international clients based in USA, UK, Canada, Netherlands, Australia, Italy, Ireland, France etc. He has worked on many different projects - ranging from small software to complex web applications. Ankur has a passion for teaching and his current focus of work has been consulting, training and mentoring teams (at his own company - Infotrex Services Pvt. Ltd.) on Open Source Technologies.

Audience

This course is intended for system administrators, developers, and database administrators who have prior knowledge of MySQL and who want to learn advanced features and MySQL administration. Working experience of MySQL is required before beginning this course.
 

Details

Date(s):

Aug. 25-27, 2012 

Time:

9:00am to 5:00pm 

Venue:

Kuala Lumpur, near General Hospital or Kepong (Selayang)   (For courses in Singapore, click here)

Closing Date:

4 weeks before course commencement 

Course Fee:

RM2700  

 

Registration fees inclusive of:

  • Course materials

  • Light refreshments

  • Certificate of Completion

Laptop:

Note that all participants are requested to bring their own laptop to class. 

Online Registration

Register Online or email my@vibenet.com.sg

 

Payment Options

1. Online Payment (Visa / Mastercard / Amex / Paypal)

2. Invoice to Company (for Company Sponsored Participants)

3. Maybank Internet/ ATM transfer

Cancellation & Refund Policy
Withdrawal or deferment notice must be made in writing to my@vibenet.com.sg at least 4 weeks before course commencement.
In the event that the course is cancelled due to unforeseen circumstances, full refund will be given. Vibenet reserves the right to substitute the course instructor with another of similar experience in case of extenuating conditions.

 
 


 
 

For general questions or comments about the Vibenet site, please send e-mail to webmaster@vibenet.com.sg.

Thanks for taking the time to give us your comments.

© Vibenet Pte Ltd.