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.

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
     
9. Updating and Deleting MySQL Tables
10. Altering a MySQL Table
11. Adding and Deleting Table Columns
12. Renaming Tables and Columns
13. Changing The Data Type of a Column
14. Deleting a Database Table
    
    
15. Inserting Data into a MySQL Database
    • The Basics of Data Insertion
    • Inserting a Complete Row
    • Adding Multiple Rows to a Table
    • Inserting Results from a SELECT Statement
    • Reducing the INSERT Performance Load
    • Reducing the INSERT Performance Load
      
      
16. Updating and Deleting MySQL Data
    • Updating Database Data
    • Ignoring Update Errors
    • Deleting Database Data
      
      
17. Retrieving Data From a MySQL Database
    • Retrieving a Single Column
    • Using SELECT to Retrieve Mutiple Columns
    • Restricting Number of Results
    • Eliminating Duplicate Values from Results
      
      
18. Sorting Data Retrieved from a MySQL Database
    • Sorting Data from a SELECT Statement
    • Sorting on Multiple Columns
    • Sorting Data in Descending Order
      
      
19. Using WHERE to Filter MySQL Data
    • The Basics of the WHERE Clause
    • Comparison Operators
    • Checking for NULL Values
    • Searching within Range Values
      
      
20. Advanced MySQL Data Filtering - AND, OR, NOT and IN
    • Filtering Data Using the OR Operator
    • Filtering Data Using the AND Operator
    • Combining AND and OR Operators
    • Understanding Operator Precedence
    • Specifying a Range of Conditions using the IN Clause
    • Using the NOT Operator
      
      
21. MySQL Wildcard Filtering using LIKE
    • What are Wildcards?
    • Single Character Wildcards
    • Multiple Character Wildcards
      
      
22. MySQL Regular Expression Searches
    • What are Regular Expressions?
    • Regular Expression Character Matching
    • Matching from a Group of Characters
    • Matching from a Range of Characters
    • Handling Special Characters
    • Regular Expressions and Whitespace Characters
    • Matching by Character Type
    • Regular Expression Repetition Metacharacters
    • Matching by Text Position
      
      
23. Joining Tables in MySQL
    • How Does a Join Work?
    • Performing a Cross-Join
    • Equi-Join (aka the Inner Join)
    • Performing a Left Join or a Right Join
    • Creating Joins with WHERE and USING
      
      
24. An Introduction to MySQL Views
    • Creating a Basic View
    • Joins and Views
    • Getting Information About a View
    • Deleting a View
    • Replacing a View
      
      
25. MySQL Calculations and Concatenations
    • Performing Calculations on Retrieved Data
    • Concatenating Data Fields
    • Trimming Trailing Whitespace from Text
    • Trimming Leading Whitespace from Text
      
      
26. Manipulating Text in MySQL
    • MySQL String Manipulation Functions
      
      
27. MySQL Mathematical Functions
    • MySQL Arithmetic Functions
28. Working with Dates and Times in MySQL
    • Date and Time Formats
    • Creating Date and Time Fields
    • Date and Time Formats
    • Date and Time Functions
    • Inserting Date and Time Values into Table Columns
    • Retrieving Data Based on Date and Time Criteria
      
      
29. MySQL Data Aggregation Functions
    • The MySQL Aggregate Functions
    • Using the Aggregate Functions
    • Using the MySQL AVG() Function
    • Using the MySQL COUNT() Function
    • Using the MySQL MAX() Function
    • Using the MySQL MIN() Function
    • Using the SUM() Function
    • Using Multiple Aggregate Functions
      
      
30. MySQL Users and Security
    • MySQL Security
    • Getting Information About Users
    • Creating a New MySQL User
    • Deleting a MySQL User
    • Renaming a MySQL User
    • Changing the Password for a MySQL User
    • User Privileges