Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 165
Pages: 165
Authors: Chris Newman
- 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
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 165
Pages: 165
Authors: Chris Newman