Free online book “MySQL Essentials” from Techotopia. This eBook is intended to teach the basics of using the MySQL relational database management system (RDBMS) to create and manage databases and is ideal for those unfamiliar with both databases in general and MySQL in particular.
Book Description
Topics covered include the basics of relational databases, MySQL installation on Linux and Windows systems, an overview of the MySQL administration tools, database security and detailed tutorials on using SQL to create, manage and retrieve data.
Table of Contents
- 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
- An Introduction to MySQL Views
- MySQL Calculations and Concatenations
- Manipulating Text in MySQL
- MySQL Mathematical Functions
- Working with Dates and Times in MySQL
- MySQL Data Aggregation Functions
- MySQL Users and Security
- Administering and Monitoring MySQL using the MySQL Workbench
- Using MySQL Workbench to Execute SQL Queries and Create SQL Scripts
- Using MySQL Workbench to Create a Database Model