Herong's Tutorial Notes on SQL
Dr. Herong Yang, Version 3.02

About This Book

Listing information:

Web site URL: http://www.herongyang.com/sql/

Title: Herong's Tutorial Notes on SQL

Author: Dr. Herong Yang

Category: SQL/Book/Tutorial

Version/Edition: 3.02, 2006.

Number of pages: 81

Short description: 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.

Long description: 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.

Keywords: 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.

Cost/Price: Free

Viewing statistics:

This book has been viewed a total of:

  • 54,562 times as of September 2006.
  • 2,251 times as of March 2005.

Revision history:

  • Version 3.02, 2006. Minor updates.
  • Version 3.00, 2004. Reformatted in XHTML and PDF.
  • Version 2.00, 1999. Updated with MySQL.
  • Version 1.00, 1997. Started with mSQL.

Copyright:

  • The notes and example codes are Copyright © 1997 - 2006 by Dr. Herong Yang. All rights reserved.
  • Using and distributing the notes and example codes are permitted, as long as the above copyright notice is retained.
  • The example codes is provided as-is, with no warranty of any kind.
Dr. Herong Yang, updated in 2006
Herong's Tutorial Notes on SQL - About This Book