MySQL Essentials

• About MySQL Essentials
• Database Basics
• MySQL Database Architecture
• The mysql Command-Line Tool
• The MySQL Administrator Tool
• The MySQL Query Browser
• Creating New Databases and Tables with MySQL Administrator
• Creating Databases and Tables Using SQL Commands
• Updating and Deleting MySQL Tables
• Inserting Data into a MySQL Database
• Updating and Deleting MySQL Data
• Retrieving Data From a MySQL Database
• Sorting Data Retrieved from a MySQL Database
• Using WHERE to Filter MySQL Data
• Advanced MySQL Data Filtering - AND, OR, NOT and IN
• MySQL Wildcard Filtering using LIKE
• MySQL Regular Expression Searches
• Joining Tables in MySQL
• MySQL Calculations and Concatenations
• Manipulating Dates, Times, Numbers and Text in MySQL