Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageMySQL Training: Administering MySQL
Description:
MySQL is the world`s most popular open source client-server database. In this four-day, hands-on course, attendees learn the fundamentals of writing MySQL queries, administering the MySQL database, and writing applications that automate tasks within MySQL.
- Cost: Price on application
- Duration: 4 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
This course can be customized to any level of experience. The last section, Integrating Applications with MySQL, presumes that attendees already know the language in question and merely need to learn how to use the language to automate MySQL.
MYSQL BASICS :
Installing MySQL
Installing on Linux
Configuring Your System
Checking Your System Works
Setting the Root Password
Deleting Anonymous Accounts
Creating an Account for Basic Use
Quick Tour
MySQL Directory Structure
Overview of Executables
Overview of User Interfaces
Quick Introduction to the MySQL Monitor
Installing on Linux
Configuring Your System
Checking Your System Works
Setting the Root Password
Deleting Anonymous Accounts
Creating an Account for Basic Use
Quick Tour
MySQL Directory Structure
Overview of Executables
Overview of User Interfaces
Quick Introduction to the MySQL Monitor
DESIGNING AND CREATING DATABASES WITH MYSQL :
Database Design Crash Course
Database Concepts and Terminology
Database Design Principles
Normalization
Creating Databases, Tables, and Indexes
Case Sensitivity
Identifiers in MySQL
Creating a Database
Selecting a Database
Creating Tables
Column and Data Types in MySQL
Creating Indexes
Deleting Databases, Tables, and Indexes
Altering Existing Table Structures
Database Concepts and Terminology
Database Design Principles
Normalization
Creating Databases, Tables, and Indexes
Case Sensitivity
Identifiers in MySQL
Creating a Database
Selecting a Database
Creating Tables
Column and Data Types in MySQL
Creating Indexes
Deleting Databases, Tables, and Indexes
Altering Existing Table Structures
WRITING SQL QUERIES :
Simple SELECTs
Introduction to the Northwind Database
Some Basics
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records
The WHERE Clause and Operator Symbols
The WHERE Clause and Operator Words
Checking Multiple Conditions
Advanced SELECTs
Calculated Fields
Aggregate Functions and Grouping
Built-in Data Manipulation Functions
Subqueries, Joins, and Unions
Subqueries
Joins
Unions
Inserting, Updating and Deleting Records
Using INSERT
Using UPDATE
Using DELETE
Using MySQL Built-In Functions with SELECT
Operators
Control Flow Functions
String Functions
Numeric Functions
Date and Time Functions
Cast Functions
Other Functions
Functions for Use with GROUP BY Clauses
Introduction to the Northwind Database
Some Basics
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records
The WHERE Clause and Operator Symbols
The WHERE Clause and Operator Words
Checking Multiple Conditions
Advanced SELECTs
Calculated Fields
Aggregate Functions and Grouping
Built-in Data Manipulation Functions
Subqueries, Joins, and Unions
Subqueries
Joins
Unions
Inserting, Updating and Deleting Records
Using INSERT
Using UPDATE
Using DELETE
Using MySQL Built-In Functions with SELECT
Operators
Control Flow Functions
String Functions
Numeric Functions
Date and Time Functions
Cast Functions
Other Functions
Functions for Use with GROUP BY Clauses
MYSQL TABLE TYPES AND TRANSACTIONS :
Understanding MySQL`s Table Types
ISAM Tables
MyISAM Tables
InnoDB Tables
BerkeleyDB (BDB) Tables
MERGE Tables
HEAP Tables
Using Transactions with InnoDB Tables
What Are Transactions? Using Transactions in MySQL
The InnoDB Transaction Model
ISAM Tables
MyISAM Tables
InnoDB Tables
BerkeleyDB (BDB) Tables
MERGE Tables
HEAP Tables
Using Transactions with InnoDB Tables
What Are Transactions? Using Transactions in MySQL
The InnoDB Transaction Model
ADMINISTERING MYSQL :
Managing User Privileges
Creating User Accounts with GRANT and REVOKE
Privilege Levels
Evaluating Privileges
Using the REVOKE Statement
Understanding the Privilege Tables
Configuring MySQL
Setting MySQL Configuration Options
Setting InnoDB Configuration Options
Multi-Install Configuration Options
Configuring for Internationalization
Administering Your Database
Starting Up and Shutting Down the MySQL Server
Getting Information about the Server and Databases
Setting Variables
Killing Threads
Clearing Caches
Understanding the Log Files
mysqladmin Option
Backup and Disaster Recovery
Backing Up and Restoring Your Database
Testing Your Backup
Checking and Repairing Tables
Securing Your MySQL Installation
How the Privilege System Works in Practice
Securing Accounts
Securing Your Installation Files
Filtering User Data
Other Tips
Replicating Your Database
Replication Principles
Setting Up and Configuring for Replication
Advanced Topologies
The Future of MySQL Replication
Creating User Accounts with GRANT and REVOKE
Privilege Levels
Evaluating Privileges
Using the REVOKE Statement
Understanding the Privilege Tables
Configuring MySQL
Setting MySQL Configuration Options
Setting InnoDB Configuration Options
Multi-Install Configuration Options
Configuring for Internationalization
Administering Your Database
Starting Up and Shutting Down the MySQL Server
Getting Information about the Server and Databases
Setting Variables
Killing Threads
Clearing Caches
Understanding the Log Files
mysqladmin Option
Backup and Disaster Recovery
Backing Up and Restoring Your Database
Testing Your Backup
Checking and Repairing Tables
Securing Your MySQL Installation
How the Privilege System Works in Practice
Securing Accounts
Securing Your Installation Files
Filtering User Data
Other Tips
Replicating Your Database
Replication Principles
Setting Up and Configuring for Replication
Advanced Topologies
The Future of MySQL Replication
OPTIMIZING MySQL :
Optimizing Your MySQL Server Configuration
Compiling and Linking for Speed
Tuning Server Parameters
Tuning Other Factors
Optimizing Your Database
What`s Slow in MySQL Databases? Making the Right Design Choices
Indexing for Optimization
ANALYZE TABLE
Using OPTIMIZE TABLE
Optimizing Your Queries
Finding Slow Queries
Benchmarking Your Queries
Using the Slow Query Log
Using EXPLAIN to See How Queries Are Executed
Understanding MySQL`s Built-In Query Optimization
Optimization Tips
Compiling and Linking for Speed
Tuning Server Parameters
Tuning Other Factors
Optimizing Your Database
What`s Slow in MySQL Databases? Making the Right Design Choices
Indexing for Optimization
ANALYZE TABLE
Using OPTIMIZE TABLE
Optimizing Your Queries
Finding Slow Queries
Benchmarking Your Queries
Using the Slow Query Log
Using EXPLAIN to See How Queries Are Executed
Understanding MySQL`s Built-In Query Optimization
Optimization Tips
INTEGRATING APPLICATIONS WITH MYSQL:
Integrating MySQL with Applications [Note: This section can be taught in Perl, PHP, Java, Python, C#, VB.NET, Visual Basic, or ColdFusion]
Loading the MySQL database driver
Connecting to the database [and handling connection errors]
Preparing a SQL statement
Executing a SQL statement [and handling SQL or database errors]
Displaying results
Obtaining and using database metadata
Using prepared statements to accelerate queries and defend against SQL injection attacks
Executing queries inside transactions [including how to subsequently commit or rollback each transaction]
If MySQL 5.0 is being used, we can also show how to invoke stored procedures (presuming the appropriate driver for the programming language being used supports stored procedure calls
Loading the MySQL database driver
Connecting to the database [and handling connection errors]
Preparing a SQL statement
Executing a SQL statement [and handling SQL or database errors]
Displaying results
Obtaining and using database metadata
Using prepared statements to accelerate queries and defend against SQL injection attacks
Executing queries inside transactions [including how to subsequently commit or rollback each transaction]
If MySQL 5.0 is being used, we can also show how to invoke stored procedures (presuming the appropriate driver for the programming language being used supports stored procedure calls