MySQL Essentials
MySQL Essentials
Publisher: Techotopia 2008
Description:
This online ebook is designed to provide a step by step path to proficiency with MySQL, a fully featured, scalable relation database management system. Beginning with the relational database basics and the installation of MySQL, the book covers everything needed to successfully build, maintain and secure MySQL based databases.
Download or read it online here:
Read online
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
|
- 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
- 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
- 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