MySQL

Introduction to RDBMS

Introduction to SQL
Evolution of RDBMS

Introduction to MySQL
Introduction to MySQL
Why use MySQL?
Features of MySql

Installing MySQL
Getting the Software
Installing MySQL*
Post Inastall configuration*

SQL & MySQL Terminologies
Database Theory
Sample Database
Basic Database Terminology
MySQL & You

MySQL Basics
MySQL Data types
MySQL column types
Choosing column type
Working with Sequences
Character Set Support

Expressions & Operators
MySQL Expressions
Arithmetic Operators
Logical Operators
Bit Operators
Comparison Operator
Operator Precedence
Type Conversion

Working with Tables
MySQL Table types
Table Representation on memory
Portability Characterstics
Creating a Table*
Temporary Tables
Creating Tables the Other way
Merge Tables
Dropping Tables
Indexing Tables
Creating & Dropping Index
Altering Table Structure
Foreign Keys & Referential Integrity

MySQL SQL Syntax
Naming Rules
Working with Database
Select statement
Insert statement
Update statement
Delete statement
Using UNION

Query
Select Statement Revisited
Selecting Records by condition

Advance Queries
Using JOIN
Performing Transaction
Using FULLTEXT Searches

Query Optimization
Advantages and Disadvantages of Indexing
Choosing Index type
MySQL Query optimizer
Overriding Optimization
Efficient Data Loading
Locking
Optimization for Administrations

Security
Introduction
Securing MySQL under Linux/Unix
Protecting MySQL under Windows
Creating New Database user and Granting Permission
What if you forgot Root password?

Access System
Internal Workings of Access System
Tools for Setting Access Privileges
Connection Problems

Data Directory
Location of Data Directory
Structure of DD
Repositioning DD Contents

General MySQL Administration
Securing a New Installation
Server Startup and Shutdown
User Account management
Log Files
Importing and Exporting Text Files
Multiple Servers

Advanced MySQL Administration
Synchronizing with the Server
Disaster Recovery through Backup & Restore
Data Recovery and Repair
Maintenance of MyISAM Tables
Administration of InnoDB Tables
Server Tuning

Replication and Other Administration issues
Database Migration
Building Replication Plan
International Customization, Character Sets

Programming
MySQL with Java
MySQL with PHP
MySQL with other languages


* Indicates the Animated      Presentation