Herong's Tutorial Notes on SQL

Version 3.02

Dr. Herong Yang

Copyright © 1997 - 2006 by Dr. Herong Yang. All rights reserved.

Table of Contents

About This Book

Relational Database Management System (RDBMS)

• Terminologies

Installing MySQL

• What is MySQL?
• Installing MySQL
• Creating First Table in MySQL

Introduction to MySQL

• What's in MySQL?
• Using the SQL Client Tool - mysql
• Dumping Data into Files - mysqldump
• Loading Data from Files - mysqlimport

Accessing MySQL from Perl Programs

• Installing Perl Database Driver for MySQL
• HelloMySQL.pl - My First Perl Program with MySQL

Data Types and Literals

• Data Types
• Data Binary Representations
• Data Literals
• Data Literal Evaluation
• Data Literal Evaluation Examples

Operations and Expressions

• Expressions
• Arithmetic Operations
• Predicate Operations
• Date and Time Operations
• Operation Examples

Functions

• Flow Control Functions
• Character String Functions
• Numeric Functions
• Date and Time Functions
• Cast Function

Table Column Types

• Table Column Types for Character Strings
• Table Column Types for Bit Strings
• Table Column Types for Exact Numbers
• Table Column Types for Approximate Numbers
• Table Column Types for Date and Time Values

Data Definition Statements

• Create Table Statements
• Column Options
• Creating Indexes
• Alter Table Statements

Data Manipulation Statements

• Insert Statements
• Update Statements
• Delete Statements

Select Statements

• Select Statements
• FROM Clause
• Join Tables
• JointTable.sql - Example of Join Tables
• WHERE Clause
• GROUP BY Clause
• ORDER BY Clause

Installing MySQL 5.0

• Installing MySQL 5.0.2 (Alpha)

Transaction Management

• What Is A Transaction
• MySQL Support of Transaction Management
• Transaction Isolation Levels
• MySQL Support of Transaction Isolation Levels
• MySQL Transaction Isolation Level Test - Read Uncommitted
• MySQL Transaction Isolation Level Test - Read Committed
• MySQL Transaction Isolation Level Test - Repeatable Read

Locks And Deadlocks

• Types and Levels of Locks
• Table Level Locks in MySQL
• Row Level Locks in MySQL

MySQL - Stored Procedures

• What Is A Stored Procedure
• Creating Stored Procedures
• Stored Procedure Parameters

MySQL - Stored Procedure Language

• Local Variables
• Execution Flow Control Statements
• Cursors

References

Key Words: book, CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, example, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, tutorial, UPDATE, WHERE, Windows, XML