MySQL Tutorials

MySQL Pronounced "my S-Q-L" or "my-see-quill," it is a very popular open source, Relational DBMS from MySQL AB, Uppsala, Sweden (www.mysql.com) that runs under various versions of Unix, Windows and Mac.

Widely used for Web applications and Embedded applications, MySQL is available for free from MySQL AB under the GNU license as well as for a fee without restrictions. MySQL includes a C/C++ interface.

There are also ODBC and JDBC drivers available, and many scripting languages such as Perl, Python, TCL, etc. support it.

• Introduction to RDBMS
  • Introduction to SQL
  • Evolution Of RDBMS
• Introduction to MySQL
  • Introduction of MySQL
  • Why use MySQL?
  • Features of MySQL
• Installing MySQL
  • Getting the Software
  • Installing MySQL
  • Post Install Configuration
• SQL & MySQL Terminologies
  • Database Theory
  • A Sample Database
  • Basic Database Terminology
  • MySQL & You
• MySQL Basic
  • MySQL Data types
  • MySQL Column type
  • Choosing Column Type
  • Working with Sequences
  • Character Set Support
• Expression & Operators
  • MySQL Expressions
  • Arithmatic Operators
  • Logical Operators
  • Bit Operators
  • Comparison Operators
  • 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 Querys
  • Using JOIN
  • Performing Tranactions
  • Using FULLTEXT Searches
• Query Optimization
  • Advantages & Disadvantages of Indexing
  • Choosing Index Type
  • MySQL Query Optimizer
  • Overriding Optimization
  • Efficient Data Loading
  • Locking
  • Optimization for Administration
• Security
  • Introduction
  • Securing MySQL Under Linux/Unix
  • Protecting MySQL Under Windows
  • Creating New DataBase User & Granting Permission
  • What If You Forgot Root Password ?
• Access System
  • Internal Working 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 & Shutdown
  • User Account Management
  • Log Files
  • Importing & Exporting Text Files
  • Multiple Servers
• Advanced MySQL Administration
  • Synchronising with the Server
  • Disaster Recovery Through Backup & Restore
  • Data Recovery & Repair
  • Maintenance of MyISAM Tables
  • Administration of InnoDB Tables
  • Server Tuning
• Replication & Other Administration issues
  • Database Migration
  • Building Replication Plan
  • International Customization ,Character Sets
• Programming
  • MySQL with JAVA
  • MySQL with PHP
  • MySQL with Other Languages