Table of Contents

Sams Teach Yourself MySQL® in 10 Minutes
By Chris Newman
...............................................
Publisher: Sams
Pub Date: May 09, 2006
Print ISBN-10: 0-672-32863-1
Print ISBN-13: 978-0-672-32863-3
Pages: 288

Table of Contents  | Index

		Copyright
		About the Author
		Introduction
		Part 1:  MySQL Foundations
			Lesson 1.  Introducing MySQL
				Database Basics
				MySQL Components
				Summary
			Lesson 2.  Using MySQL
				The mysql Client
				Executing SQL Statements
				Creating the Sample Tables
				Summary
		Part 2:  Getting Started with SQL
			Lesson 3.  Retrieving Data
				The SELECT Statement
				Summary
			Lesson 4.  Filtering and Sorting Data
				The WHERE Clause
				The ORDER BY Clause
				Summary
			Lesson 5.  Advanced Data Filtering
				Combining WHERE Clauses
				Limiting the Number of Rows Returned
				Summary
			Lesson 6.  Numeric Operators and Functions
				Numeric Operators
				Numeric Functions
				Conditional Functions
				Summary
			Lesson 7.  String Operators and Functions
				Using Operators with Strings
				String Functions
				Summary
			Lesson 8.  Date Operators and Functions
				Date Operators
				Date Functions
				Summary
			Lesson 9.  Summarizing Data
				Aggregate Functions
				Grouping Data
				Filtering Summary Data
				Summary
		Part 3:  Advance SQL
			Lesson 10.  Using Subqueries
				Understanding Subqueries
				Summary
			Lesson 11.  Joining Tables
				Understanding Joins
				Summary
			Lesson 12.  Creating Advanced Joins
				The JOIN Keyword
				Inner Joins
				Joining Multiple Tables
				Cross Joins
				Self-Joins
				Natural Joins
				Outer Joins
				Summary
			Lesson 13.  Combining Queries
				Understanding Combined Queries
				Other Compound Operations
				Using Temporary Tables
				Summary
		Part 4:  Creating a New Database
			Lesson 14.  Creating and Modifying Tables
				Creating a New Database
				Character Sets and Collations
				Altering a Database
				Dropping a Database
				Managing Tables
				Temporary Tables
				Using a Query to Create a Table
				Storage Engines
				Altering Tables
				Dropping Tables
				Summary
			Lesson 15.  Working with Data
				The INSERT Statement
				The DELETE Statement
				The UPDATE Statement
				The REPLACE Statement
				Loading Data from a File
				Why Use Transactions?
				Transactions in MySQL
				Autocommit Mode
				Rolling Back a Transaction
				Summary
			Lesson 16.  Designing Your Database
				Relationships
				Normalization
				Naming Tables and Columns
				Data Types
				CHAR and VARCHAR
				Summary
			Lesson 17.  Keys and Indexes
				Understanding Keys and Indexes
				Using Indexes in MySQL
				Summary
			Lesson 18.  Managing User Access
				Understanding MySQL Authentication
				User Management
				Using Wildcards
				Summary
		Part 5:  New Features in MySQL 5.0
			Lesson 19.  Views
				Understanding Views
				Summary
			Lesson 20.  Stored Routines
				Understanding Stored Routines
				Summary
			Lesson 21.  Triggers
				Understanding Triggers
				Using Triggers
				Summary
		Part 6:  Interfacing with MySQL
			Lesson 22.  Using ODBC
				Understanding ODBC
				Connecting to MyODBC
				Summary
			Lesson 23.  Using MySQL with C
				The C Language API
				Summary
			Lesson 24.  Using MySQL with PHP
				Using the mysql API
				Using the mysqli API
				Summary
			Lesson 25.  Using MySQL with Perl
				The Perl DBI
				Using the MySQL DBD
				Summary
		Part 7:  Appendix
			Appendix A.  Installing MySQL
				Obtaining MySQL
				Linux/UNIX Installation
				Windows Installation
			Appendix B.  Sample Table Scripts
		Index