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

MySQL: A Comprehensive Hands-On Introduction

 
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
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 Up to 45% per course with this limited offer!

MySQL: A Comprehensive Hands-On Introduction
Classroom Dates
Aug 26-28: New York enroll
See the complete schedule of classroom sessions scheduled in our training locations.
 
On-Site Training
Bring this or any Learning Tree course to your location.
 
Course Tuition
$ 2,390 Standard Tuition
Tuition with a Savings Plan
$ 1,667 Training Passport
$ 1,700 Premium-Pass
$ 2,170 Triple-Pack
$ 2,200 Voucher 10-Pack
$ 2,155 Alumni Gold Discount
$ 2,124 Government Discount
 

 

MySQL: A Comprehensive Hands-On Introduction
MySQL: A Comprehensive Hands-On Introduction
Course participants configuring a MySQL database.


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