1-800-THE-TREE (1-800-843-8733)
 

MySQL Development and Administration: Hands-On

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

Quick Enroll    

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

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

Related Courses
MySQL is a trademark of MySQL AB.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save an EXTRA $200 on a 10-Day Training Pass!

MySQL Development and Administration: Hands-On
Upcoming Dates
Dec 10 - 12, 2008
 Ottawa
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)

MySQL Development and Administration: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,250 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,025 Alumni Gold Discount
$ 2,000 Government Discount
 

 

MySQL Development and Administration: Hands-On
MySQL Development and Administration: Hands-On
Course participants configuring a MySQL database.
The most recent 100 evaluations scored this course at:

  (3.72/4.00)


CPE 17 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733