MySQL Essentials

MySQL Essentials is an online book designed to provide everything a user needs to know to install, build, maintain and secure MySQL based databases.

	Table of Contents	Next
		About MySQL Essentials

---

1. About MySQL Essentials
   
2. Database Basics
   • What is a Database?
   • Understanding Database Tables
   • Introducing Database Schema
   • Columns and Datatypes
   • Database Rows
   • Introducing Primary Keys
   • What is SQL?
     
3. MySQL Database Architecture
   
4. The mysql Command-Line Tool
   • The mysql Command-line Utility
   • mysql Command-Line Arguments
   • mysql Commands
     
5. The MySQL Administrator Tool
   • Getting and Installing MySQL Administrator
   • Connecting to the Database Server
   • Using the MySQL Administator
     
6. The MySQL Query Browser
   • Getting and Installing MySQL Query Browser
   • Connecting the MySQL Query Browser to a Database Server
   • A Tour of MySQL Browser
   • Executing SQL Statements
     
7. Creating New Databases and Tables with MySQL Administrator
   • Creating a New Database
   • Creating New Tables
8. Creating Databases and Tables Using SQL Commands
   • Creating a New MySQL Database
   • Creating Tables with SQL
   • Understanding NULL and NOT NULL Values
   • Primary Keys
   • AUTO_INCREMENT
   • Defining Default Values During Table Creation
   • MySQL Database Engine Types
     

1. Updating and Deleting MySQL Tables
2. Inserting Data into a MySQL Database
3. Updating and Deleting MySQL Data
4. Retrieving Data From a MySQL Database
5. Sorting Data Retrieved from a MySQL Database
6. Using WHERE to Filter MySQL Data
7. Advanced MySQL Data Filtering - AND, OR, NOT and IN
8. MySQL Wildcard Filtering using LIKE
9. MySQL Regular Expression Searches
10. Joining Tables in MySQL
11. An Introduction to MySQL Views
12. MySQL Calculations and Concatenations
13. Manipulating Text in MySQL
14. MySQL Mathematical Functions
15. Working with Dates and Times in MySQL
16. MySQL Data Aggregation Functions
17. MySQL Users and Security

---

	Table of Contents	Next
		About MySQL Essentials