Introduction to MySQL Databases

The MySQL training course targets new or existing users of MySQL with some experience with relational database management systems. The MySQL course covers several essential elements of MySQL and general database theories.

Experience in the following areas is required:

Basic computer literacy with previous experience with command-line programs.
Some knowledge of database concepts.
Experience in the following areas would be beneficial.

Some knowledge of data retrieval and reporting.

MySQL Programs and Executables
Common Options to Various Commands
Specifying Options
Options on the Command Line
my_print_defaults: Display options from files
perror: Explain Error Codes

Overview of User Interfaces
Establishing a Connection
MySQL Query Browser
1. Keyboard Shortcuts
2. Main Query Window
3.Query Toolbar
4. Result Area
4. Advanced Toolbar
5. SQL commands with Mouse Clicks
6. History and Bookmarks for SQL Commands
7. Using Scripts: Executing Several Commands
8. MySQL Help - Information Browser
9. Object Browser
10. The Script Editor
11. Changing Data in SELECT Results
12. Stored Procedures
13. MySQL Administrator
MySQL Migration Toolkit
1. A Brief Overview of the Migration Process
phpMyAdmin

Using MySQL Monitor (SQL Command Interpreter)
Some Useful Options
Formatting and Output Options
Commands for Interactive Mode
Executing a Script from the Monitor
Using the mysql Command to run a Script
See Database Status

Relational Database Concepts
1. Brief History of SQL
2. Relational Database Management System
3. Popular Databases
4. Tables
5. Rows
6. Columns
7. Relationships
8. Datatypes
9. Primary Keys
10. Foreign Keys
11. Valid Object References
12. SQL Statements
Database Design Principles
Film Rentals - sakila
Basic Modeling Process: Creating a Data Model
1. Logical versus Physical Model
2. The Entity-Relationship Model
3. Entities And Entity Sets
4. Attributes
5. Relationships
6. Relationship Types
7. Graphical Representation of a Model
8. Physical Model: Mapping The ER Model To A Relational Database
Database Normalization
1. First Normal Form
2. Warning: Abnormal Normal Form!
3. Second Normal Form
4. Third Normal From

Creating Databases
1. Deleting Databases
Creating Tables
1. Dropping Tables
2. Defining Table Types
3. Altering Existing Table Structures
4. Add a column
5. Renaming Tables
6. Temporary Tables
Creating Column Definitions
Data Types in MySQL
1. Numeric Data Types
2. String Data Types
3. Character Set Fundamentals
4. Set Types
5. Date/Time Data Types
6. Options and Attributes
Constraints
1. NOT NULL Constraint: Defining a Column`s Nullability
2. UNIQUE Constraint
3. PRIMARY KEY Constraint: Defining a Master Key
4. Defining Auto-Increment Columns
5. Referential Integrity Constraints: Defining Foreign Keys
6. Constraint Checking on a Transaction
7. Deferred Checking
8. Defining Default Values
Managing Indexes
1. Defining Indexes when Creating Tables
2. CREATE INDEX Statement
3. Full-Text Indexes
4. Deleting Indexes
Identifiers in MySQL
Identifiers in MySQL
Identifier Names
Schema Object Names
Using Double Quotes
Using Quote Within Names
Using Digits
Some Restrictions
Identifier Qualifiers
Mapping of Identifiers to Filenames
Identifier Case Sensitivity
lower_case_table_names Setting
Avoiding Data Transfer Problems

Identifiers in MySQL
1. Identifier Names
2. Schema Object Names
3. Using Double Quotes
Using Quote Within Names
Using Digits
Some Restrictions
Identifier Qualifiers
Mapping of Identifiers to Filenames
Identifier Case Sensitivity
1. lower_case_table_names Setting
2. Avoiding Data Transfer Problems

SHOW and DESCRIBE Statements
1. Using Table-Related SHOW Statements
2. Using DESCRIBE Statement
INFORMATION_SCHEMA Tables
1. Showing Databases

MySQL Table Types (Storage Engines)
Setting/Changing Engine
MyISAM Tables
1. Full-Text Search on MyISAM Tables
2. Creating a Full-Text Index
3. Using Full-Text Search
InnoDB Tables
1. InnoDB - Limitations and Drawbacks
2. InnoDB Disk Management
3. Preventing Problems
4. Moving Files
FOREIGN KEY Constraints in InnoDB
1. Checking Foreign Keys
Choosing - MyISAM or InnoDB?
HEAP or MEMORY Tables
Temporary Tables
MERGE Tables
Other Table Types
1. ARCHIVE or Compressed Tables (since MySQL 4.1)
2. CSV Type Tables(since MySQL 4.1)
3. NDB or Cluster Tables (since MySQL 4.1)
4. FEDERATED or External Tables (since MySQL 5.0)
5. BDB Tables
Table Files Storage