1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

MySQL Development and Administration: Hands-On

 
Course: 520   Type: Hands-On Training   Duration: 3 Days
 
 

You Will Learn How To

  • Configure and optimize MySQL on multiple platforms
  • Design, create and maintain MySQL databases
  • Construct efficient SQL queries incorporating MySQL extensions
  • Identify the correct database table types to use in your application
  • Manage MySQL using graphical tools
  • Optimize database performance and enhance reliability

Course Benefits

MySQL is an open-source relational database management system (RDBMS) that runs on a variety of platforms, including UNIX, Linux and Windows. This course provides the knowledge and extensive hands-on experience to successfully administer and maintain MySQL databases. You learn to build SQL queries that include MySQL extensions, control the MySQL server, and perform advanced SQL techniques.

Who Should Attend

Anyone involved in administering a MySQL relational database management system, including developers, Web designers, database administrators and project leaders. Basic familiarity with database concepts is helpful, but not essential.

Hands-On Training

You gain hands-on experience using a MySQL database management system to organize, manipulate and retrieve data. Exercises include:
  • Employing the MySQL command line interface to manipulate data
  • Building databases and manipulating data with SQL queries
  • Structuring data in Third Normal Form
  • Importing and exporting data to and from flat files
  • Modifying MySQL configuration with graphical and command line tools
  • Removing SQL from external applications with stored procedures

Related Courses

 
MySQL is a trademark of MySQL AB. 		 

Upcoming Dates

Dec 10 - 12, 2008
 Washington, DC (Rockville, MD)
Feb 25 - 27, 2009
 New York
Jun 3 - 5, 2009
 Ottawa
Jun 3 - 5, 2009
 Washington, DC (Rockville, MD)

For complete schedule, please visit www.learningtree.com
 
http://www.lerningtree.com/courses/520pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

MySQL Development and Administration: Hands-On

 
Course: 520   Type: Hands-On Training   Duration: 3 Days
 
 
Course 520 Content
 

Designing and Querying Databases

Database modeling

  • Defining RDBMS concepts
  • Mapping real-world object to databases and tables
  • Determining appropriate table schemas
  • Normalizing database tables for optimal data management

Implementing basic SQL queries

  • Retrieving data from tables
  • Adding and removing rows with INSERT and DELETE
  • Modifying existing data with UPDATE
  • Building stored procedures and employing triggers

Controlling and Managing the MySQL Server

Choosing and installing MySQL

  • Identifying the different licensing models for MySQL
  • Comparing MySQL to other commercial RDBMSs
  • Determining which version of MySQL to download

Accessing the database server

  • Creating user accounts
  • Allocating user privileges with GRANT and REVOKE
  • Avoiding denial-of-service (DoS) attacks
  • Directly manipulating the MySQL access privilege tables

Leveraging graphical front-ends

  • Managing the MySQL server with MySQL Administrator
  • Querying databases and tables with MySQL Query Builder

Managing Databases with MySQL

Administering databases

  • Constructing a database using command line tools
  • Identifying different SQL data types
  • Building and altering tables
  • Adding indexes to tables for best performance

MySQL table types

  • Building temporary MEMORY tables
  • Achieving the greatest speed with MyISAM tables
  • Avoiding operating system limitations with MERGE tables

Importing and exporting data

  • Importing flat-file data with LOAD DATA INFILE
  • Exporting data to text files
  • Saving complete table and data definitions with mysqldump
  • Safeguarding data integrity
  • Backing up databases using MySQL and operating system tools

Advanced SQL Techniques

Creating advanced queries

  • Manipulating and formatting data
  • Organizing output using ORDER BY
  • Employing outer joins
  • Building queries incorporating subqueries
  • Safeguarding data integrity with transactions

Taking advantage of SQL functions

  • Manipulating data and time data
  • Aggregating data with GROUP BY
  • Calculating mean, sum, maximum and minimum values from columns

Optimizing MySQL Configuration

Increasing performance

  • Implementing full-text indexing
  • Identifying slow and problematic SQL queries
  • Activating the Query Cache

Building reliability and scalability into your applications

  • Replicating databases on multiple servers
  • Identifying different replication configurations
  • Repairing database tables
  • Ensuring 99.999% uptime with MySQL Cluster

Implementing stored procedures

  • Creating user variables
  • Building user-defined functions
  • Writing stored procedures
  • Passing data to and from stored procedures
 
http://www.lerningtree.com/courses/520pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

MySQL Development and Administration: Hands-On Tuition

 
Course: 520   Type: Hands-On Training   Duration: 3 Days
 
 

Course Tuition
$ 2,390 Standard Tuition
Tuition with a Savings Plan
$ 1,350 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,155 Alumni Gold Discount
$ 2,124 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.lerningtree.com/courses/520pf.htm