COURSE NAME: My SQL (75 hrs)

Implementing databases with My SQL

• Introduction
• Database Fundamentals
• Database Normalization
• MySQL Overview
• MySQL Software
• The MySQL Features
• Installing & Configuring a MySQL Server
• Using MySQL Clients
• Using the mysql Client
• Using mysqlimport & mysqldump
• Checking Tables for Consistency
• Other MySQL Clients
• Using SHOW and DESCRIBE
• Understanding MySQL Storage
• Data Definition Language
• MySQL Data Types
• The SELECT Statement
• SQL Expressions and Functions
• Updating Tables Using SQL
• Joins
• Importing and Exporting Data

My SQL Administration

• Introduction
• MySQL Architecture
• Installing & configuring MySQL
• MySQL Installation for Windows
• MySQL Installation for Linux/Unix
• Compiling MySQL Server
• Upgrading MySQL Servers
• OS & Hardware Optimization
• Understanding & using MySQL client software
• Understanding MySQL Storage
• Choosing a storage engine
• Managing MySQL Configuration
• MySQL Server Security
• MySQL security-related configuration
• Understanding the MySQL privilege system
• Managing users in MySQL
• Installing & using OpenSSL
• Optimizing Queries
• Using Explain to analyze queries
• Optimizing Indexes
• Optimizing updates
• Understanding and using FULLTEXT indexes
• Understanding MyISAM Tables
• MyISAM storage engine features
• MyISAM table locking mechanisms
• MyISAM table relocation
• Backup up & restoring MyISAM tables
• Understanding & managing InnoDB Tables
• Managing InnoDB tablespaces
• Configuring InnoDB buffers and logs
• Utilizing multiple InnoDB tablespace
• Using Raw devices for InnoDB tablespaces
• Determining InnoDB engine status
• InnoDB table restrictions
• Table Backup & Maintenance
• Using myisamcheck and mysqlcheck to perform table maintenance.
• Using mysqldump to perform server backups
• Performing MyISAM file-level backups
• Performing InooDB tablespace backups
• Using & managing MySQL binary logs
• Other backup methods
• Using Advanced MySQL Server Features
• Measuring & managing server load
• Understanding the MySQL query cache
• Performance tuning the MyISAM engine
• Performance tuning the InnoDB engine
• Configuring MySQL replication
• Multiple servers and replication
• Configuring MySQL 4.x replication
• Configuring MySQL 5.x replication
• Circular replication
• Querying replication status

My SQL performance and tuning

• Review of MySQL fundamentals
• Understanding MySQL storage engines
• Benchmarking MySQL server performance
• Optimizing indices for queries
• Server performance tuning
• Configuring and managing replication
• Load balancing and high availability
• Backup and recovery
• MySQL system security

My SQL for developers

• Installing and configuring a MySQL server
• OS and Hardware optimization for MySQL
• Understanding MySQL client software
• The mysql client
• Managing MySQL with mysqladmin
• Understanding client option files
• Understanding MySQL utilization of the file system
• Understanding MySQL storage
• Choosing a storage engine
• Transactional versus non-transactional storage engines
• Understanding the MyISAM storage engine
• Understanding the InnoDB storage engine
• Understanding other storage engines (BDB, MEMORY, MERGE, etc.)
• Understanding the MySQL server security model
• Implementing effective MySQL security
• Developing & implementing MySQL stored procedures
• Developing & implementing MySQL triggers
• Benchmarking & optimizing MySQL queries using the query optimizer
• Understanding the FULLTEXT indexing engine
• Backup, recovery, and bulk load techniques
• Using mysqlimport to import data
• Using mysqldump to extract and back up data
• Performing disk level system backups
• Understanding online backup methods and strategies
• Understanding MySQL data types, their uses, and limitations