Trog
Get a crash course in MySQL's date and time functions.
Use the powerful string processing toolkit in MySQL for common string manipulation tasks.
Learn to avoid data corruption with MySQL's various isolation levels, and see examples of transaction usage at the application level.
Implement a transactional environment with MySQL.
Do more with subqueries with the IN and EXISTS operators.
Build sophisticated nested queries with MySQL 4.
Simplify date and time arithmetic with built-in MySQL functions.
Left join. Right join. Inner join. Welcome to the wild, the wacky, the insanely cool world of SQL joins.
Precisely control access to information with the mySQL grant tables.
A discussion of basic database concepts.
Use SELECT
queries, joins, sub-queries and built-in SQL functions to
focus in on the data you need.
Learn the basics of creating databases and tables, and inserting data into them, with this introduction to SQL.