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 Optimization Training
Description:
This MySQL class is delivered for private groups onsite at your offices or a location of your choice. It can also be delivered via the Internet for geographically distributed staff.
- Cost: Price on application
- Duration: 1 Day
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Experience in the following areas is required:
- General RDBMS and SQL knowledge and principles
- Understanding of DDL objects - tables, Indexes, constraints and others
- Understanding of database installation and deployment
- Basic knowledge hardware and OS
Experience in the following areas would be beneficial.
- Understands different methodologies for modeling database structures
- Understanding of database installation and deployment
- Basic knowledge hardware and OS
- General RDBMS and SQL knowledge and principles
- Understanding of DDL objects - tables, Indexes, constraints and others
- Understanding of database installation and deployment
- Basic knowledge hardware and OS
Experience in the following areas would be beneficial.
- Understands different methodologies for modeling database structures
- Understanding of database installation and deployment
- Basic knowledge hardware and OS
Optimizing Databases and Their Objects :
Optimizing Databases
Improving Application Design
Precomputing Queries
Materialized Views
Transactions
Indexing
- Types Of Indexes
- Indexes are not used when ...
- Client-Server Interactions
MyISAM Index Collecting Statistics
Improving Application Design
Precomputing Queries
Materialized Views
Transactions
Indexing
- Types Of Indexes
- Indexes are not used when ...
- Client-Server Interactions
MyISAM Index Collecting Statistics
Optimizing and Tuning Queries :
Query Execution Plan
Analyzing the output from EXPLAIN Statement
- Explain Table
Join Optimization
- Cartesian Product
- Match Elimination: Filtering Joins
- Using Joins in Aggregation
- Optimizing Joins
- Driving Tables
When to Index
- Index Types
SQL Queries: Other Optimizations
- Optimizing Data Retrieval
- Cardinality of a Table
- Using the OPTIMIZE TABLE Statement
The Slow Query Log
Analyzing the output from EXPLAIN Statement
- Explain Table
Join Optimization
- Cartesian Product
- Match Elimination: Filtering Joins
- Using Joins in Aggregation
- Optimizing Joins
- Driving Tables
When to Index
- Index Types
SQL Queries: Other Optimizations
- Optimizing Data Retrieval
- Cardinality of a Table
- Using the OPTIMIZE TABLE Statement
The Slow Query Log
Tuning MySQL for Performance :
System Characteristics
- Disk I/O Speed
- Memory
- How MySQL Uses Memory
- Processor Speed
- Network Bandwidth
Tuning Server Parameters
MySQL Query Cache
The MyISAM Key Cache
Examining Thread Information
- Disk I/O Speed
- Memory
- How MySQL Uses Memory
- Processor Speed
- Network Bandwidth
Tuning Server Parameters
MySQL Query Cache
The MyISAM Key Cache
Examining Thread Information
MySQL Table Types :
MySQL Table Types (Storage Engines)
Setting/Changing Engine
MyISAM Tables
- Full-Text Search on MyISAM Tables
- Creating a Full-Text Index
- Using Full-Text Search
InnoDB Tables
- InnoDB - Limitations and Drawbacks
- InnoDB Disk Management
- Preventing Problems
- Moving Files
FOREIGN KEY Constraints in InnoDB
Checking Foreign Keys
Choosing - MyISAM or InnoDB?
HEAP or MEMORY Tables
Temporary Tables
MERGE Tables
Other Table Types
ARCHIVE or Compressed Tables (since MySQL 4.1)
CSV Type Tables(since MySQL 4.1)
NDB or Cluster Tables (since MySQL 4.1)
FEDERATED or External Tables (since MySQL 5.0)
BDB Tables
Table Files Storage
Setting/Changing Engine
MyISAM Tables
- Full-Text Search on MyISAM Tables
- Creating a Full-Text Index
- Using Full-Text Search
InnoDB Tables
- InnoDB - Limitations and Drawbacks
- InnoDB Disk Management
- Preventing Problems
- Moving Files
FOREIGN KEY Constraints in InnoDB
Checking Foreign Keys
Choosing - MyISAM or InnoDB?
HEAP or MEMORY Tables
Temporary Tables
MERGE Tables
Other Table Types
ARCHIVE or Compressed Tables (since MySQL 4.1)
CSV Type Tables(since MySQL 4.1)
NDB or Cluster Tables (since MySQL 4.1)
FEDERATED or External Tables (since MySQL 5.0)
BDB Tables
Table Files Storage