MySQL Essentials


Publisher: Techotopia 2008

This online ebook is designed to provide a step by step path to proficiency with MySQL, a fully featured, scalable relation management system. Beginning with the relational database basics and the installation of MySQL, the book covers everything needed to successfully build, maintain and secure based databases.

Home page url

Download or read it online here: 
Read online


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


  1. About MySQL Essentials
  2. Database Basics
  3. MySQL Database Architecture
  4. The mysql Command-Line Tool
  5. The MySQL Administrator Tool
  6. The MySQL Query Browser
  7. Creating New Databases and Tables with MySQL Administrator
  8. Creating Databases and Tables Using SQL Commands
  9. Updating and Deleting MySQL Tables
  10. Inserting Data into a MySQL Database
  11. Updating and Deleting MySQL Data
  12. Retrieving Data From a MySQL Database
  13. Sorting Data Retrieved from a MySQL Database
  14. Using WHERE to Filter MySQL Data
  15. Advanced MySQL Data Filtering – AND, OR, NOT and IN
  16. MySQL Wildcard Filtering using LIKE
  17. MySQL Regular Expression Searches
  18. Joining Tables in MySQL
  19. An Introduction to MySQL Views
  20. MySQL Calculations and Concatenations
  21. Manipulating Text in MySQL
  22. MySQL Mathematical Functions
  23. Working with Dates and Times in MySQL
  24. MySQL Data Aggregation Functions
  25. MySQL Users and Security
  26. Administering and Monitoring MySQL using the MySQL Workbench
  27. Using MySQL Workbench to Execute SQL Queries and Create SQL Scripts
  28. Using MySQL Workbench to Create a Database Model
You might also like
Leave A Reply