Course Outline
I. General MySQL Use
1 Getting Started with MySQL and SQL How MySQL Can Help You
A Sample Database
Basic Database Terminology
A MySQL Tutorial
Tips for Interacting with MySQL
Where to Now?
2 Working with Data in MySQL
MySQL Data Types
MySQL Column Types
Working with Sequences
Character Set Support
Choosing Column Types
Expression Evaluation and Type Conversion
3 MySQL SQL Syntax and Use
MySQL Naming Rules
Selecting, Creating, Dropping and Altering Databases
Creating, Dropping, Indexing and Altering Tables
Getting Information about Databases and Tables
Retrieving Records from Multiple Tables
Multiple-Table Deletes and Updates
Performing Transactions
Foreign Keys and Referential Integrity
Using FULLTEXT Searches
Writing Comments
Features That MySQL Does Not Support
4 Query Optimization
Using Indexing
The MySQL Query Optimizer
Column Type Choices and Query Efficiency
Loading Data Efficiently
Scheduling and Locking Issues
Optimization for Administrators
II Using MySQL Programming Interfaces
5 Introduction to MySQL Programming
Why Write Your Own MySQL Programs?
APIs Available for MySQL
Choosing an API
6 The MySQL C API
General Procedure for Building Client Programs
Client 1 – Connecting to the Server
Client 2 – Adding Error Checking
Client 3 – Getting Connection Parameters at Runtime
Processing Queries
Client 4 – An Interactive Query Program
Writing Clients That Include SSL Support
Using the Embedded Server Library
Miscellaneous Topics
7 The Perl DBI API
Per Script Characteristics
Per DBI Overview
Putting DBI to Work
Using DBI in Web Applications
8 The PHP API
PHP Overview
Putting PHP to Work
III MySQL Administration
9 Introduction to MySQL Administration
Overview of Administrative Duties
General Administration
Security
Database Repair and Maintenance
10 The MySQL Data Directory
Location of the Data Directory
Structure of the Data Directory
Relocating Data Directory Contents
11 General MySQL Administration
Securing a New MySQL Installation
Arranging for MySQL Server Startup and Shutdown
Managing MySQL User Accounts
Maintaining Log Files
Additional Server Configuration Topis
Running Multiples Servers
Setting Up Replication Servers
Updating MySQL
12 Security
Internal Security: Preventing Unauthorized File System
Access
External Security: Preventing Unauthorized Network Access
Setting Up Secure Connections
13 Database Backups, Maintenance, and Repair
Coordinating with the Server
Preparing for Disaster
Table Repair and Data Recovery |