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.

	Table of Contents	Next
		About MySQL Essentials

eBookFrenzy.com

Purchase and download the full PDF and ePub versions of this MySQL eBook for only $9.99

About MySQL Essentials
Database Basics
- What is a Database?
- Understanding Database Tables
- Introducing Database Schema
- Columns and Datatypes
- Database Rows
- Introducing Primary Keys
- What is SQL?
MySQL Database Architecture
The mysql Command-Line Tool
- The mysql Command-line Utility
- mysql Command-Line Arguments
- mysql Commands
The MySQL Administrator Tool
- Getting and Installing MySQL Administrator
- Connecting to the Database Server
- Using the MySQL Administator
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
Creating New Databases and Tables with MySQL Administrator
- Creating a New Database
- Creating New Tables
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
Updating and Deleting MySQL Tables
- Altering a MySQL Table
- Adding and Deleting Table Columns
- Renaming Tables and Columns
- Changing The Data Type of a Column
- Deleting a Database Table
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
Updating and Deleting MySQL Data
- Updating Database Data
- Ignoring Update Errors
- Deleting Database Data
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
Sorting Data Retrieved from a MySQL Database
- Sorting Data from a SELECT Statement
- Sorting on Multiple Columns
- Sorting Data in Descending Order
Using WHERE to Filter MySQL Data
- The Basics of the WHERE Clause
- Comparison Operators
- Checking for NULL Values
- Searching within Range Values
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
MySQL Wildcard Filtering using LIKE
- What are Wildcards?
- Single Character Wildcards
- Multiple Character Wildcards
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
- 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
An Introduction to MySQL Views
- Creating a Basic View
- Joins and Views
- Getting Information About a View
- Deleting a View
- Replacing a View
MySQL Calculations and Concatenations
- Performing Calculations on Retrieved Data
- Concatenating Data Fields
- Trimming Trailing Whitespace from Text
- Trimming Leading Whitespace from Text
Manipulating Text in MySQL
- MySQL String Manipulation Functions
MySQL Mathematical Functions
- MySQL Arithmetic Functions
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
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
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
Administering and Monitoring MySQL using the MySQL Workbench
- Getting and Installing MySQL Workbench
- Creating a Server Instance Profile
- Connecting to a MySQL Database Server
- A Tour of the MySQL Workbench Admin Panel
- Server Status
- Configuration
Using MySQL Workbench to Execute SQL Queries and Create SQL Scripts
- Connecting to a MySQL Database Server
- The MySQL Workbench SQL Editor
Using MySQL Workbench to Create a Database Model
- Creating a New Model
- Generating a Model Diagram
- Generating a Script and Creating a Database
- Reverse Engineering an Existing Database
- Summary

eBookFrenzy.com

Purchase and download the full PDF and ePub versions of this MySQL eBook for only $9.99

	Table of Contents	Next
		About MySQL Essentials

MySQL Essentials

Techotopia