Tutorial Notes on SQL

Tutorial Notes on SQL
This free book is an excellent tutorial book for beginners. It is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, 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, UPDATE, WHERE, Windows, XML. Key sections: Relational Database Management System (RDBMS) - Installing MySQL - Introduction to MySQL - Accessing MySQL from Perl Programs - Data Types and Literals - Operations and Expressions - Functions - Table Column Types - Data Definition Statements - Data Manipulation Statements - Select Statements - Transaction Management - Locks And Deadlocks - MySQL - Stored Procedures - MySQL - Stored Procedure Language.
Herong Yang