Tutorials and Online Training Videos

MySQL 5 Development (Part 1) Tutorial


As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and "why" those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!

Introduction

Welcome
What This Course Will Cover
System Requirements
A Brief History of MySQL
Help on the MySQL Web Site
Online Manual Demonstration pt. 1
Online Manual Demonstration pt. 2

Database Basics

Definitions
Client/Server Systems
Tables/Columns/Rows
Database Design in a Nutshell
Indexes
Databases in MySQL

Installation

Installation Basics
Windows
Mac OS X
Linux
What We Installed
Starting and Stopping MySQL

Configuration

MySQL Server Configuration
Server Startup Options
MySQL Configuration File
Important Configuration Options

Client Programs

Command Line Operations
Using a Command Line Client
Command Line Client Help File
MySQL Client Batch Mode
MySQL Client Interactive Mode pt. 1
MySQL Client Interactive Mode pt. 2
MySQL Client Interactive Mode pt. 3
Executing Scripts
Exploring Databases and Tables

SELECT Statement Basics

SELECT Arithmetic
Selecting More Than One Column
Operators and Functions
Column Aliases
NULL
Data Type Basics

Variables

What is a Variable?
User Variables
Assignment Operator
SET Statement
System Variables
Variable Scope

Calculations and Expressions

New Values From Old
Operators and Operands
Arithmetic Operators
String Operators
Comparison Operators
Logical Operators
Order of Precedence
Functions and Parameters
Useful Numeric Functions
Useful Character String Functions
Temporal Operations
Useful Temporal Functions
Decision-Making Functions
NULL-Related Functions
Useful System Functions

Querying SQL Data

Using a Database
Selecting FROM a Table
Targeting Rows Using WHERE
Complex WHERE Criteria
Sorting Results Using ORDER BY
Going to Extremes Using LIMIT
Avoiding Duplicates Using DISTINCT
Aggregation Queries
Subtotals Using GROUP BY
Filter Derived Columns with HAVING
Multilevel Sums Using WITH ROLLUP
Summarizing SELECT Clauses
Some Clauses Cannot Coexist

Databases and Tables

Databases in MySQL
Creating a Database
Aspects of a Table
Creating a Table
Table Options
Column Options
Auto-Incrementation
Altering a Table
Adding and Dropping Columns
Altering a Column
Dropping a Table
Dropping a Database

Data Type Details

Data Type Categories
Integer Numbers
Floating Point Numbers
Fixed Decimal Numbers
BIT Data Type
Strings
Basic Character Strings
ENUM Character Strings
SET Character Strings
Character Sets
Collations
Fonts and Keystroke Mapping
Binary Strings
Temporal Data
Timestamp and Time Types

Storage Engines

Storage Engine Basics
Discovering Storage Engines
MyISAM
InnoDB
Memory
Example
CSV
Archive
Federated
Blackhole
Third Party Engines

Exporting Data

Basic Export Concepts
Exporting Using SQL Commands pt. 1
Exporting Using SQL Commands pt. 2
Exporting on the Shell Command Line
Using MySQLDUMP for Scripts
Using MySQLDUMP for Exporting

Prepared Statements

Prepared Statement Basics
Prepared Statement Demonstration
Commands That Can Be Prepared
When to Use Them

Server Information

Metadata
SHOW Commands
DESCRIBE Command
MySQLSHOW Command Line Client
Information_Schema Database pt. 1
Information_Schema Database pt. 2

Conclusion

What We Covered
Where to Go from Here

Credits

About the Author


Related Books on MySQL 5 Development (Part 1)







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts