---

Sams Teach Yourself MySQL in 10 Minutes

ISBN: 0672328631
EAN: 2147483647

Year: 2006
Pages: 165

Authors: Chris Newman

BUY ON AMAZON

• Sams Teach Yourself MySQL in 10 Minutes
• Table of Contents
• 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
• LinuxUNIX Installation
• Windows Installation
• Appendix B. Sample Table Scripts
• Index
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W