---

MySQL Crash Course

ISBN: 0672327120
EAN: 2147483647

Year: 2004
Pages: 214

Authors: Ben Forta

BUY ON AMAZON

• MySQL Crash Course
• Table of Contents
• Copyright
• About the Author
• Acknowledgments
• We Want to Hear from You
• Introduction
• Who Is This Book For?
• Companion Website
• Conventions Used in This Book
• Chapter 1. Understanding SQL
• Database Basics
• What Is SQL?
• Try It Yourself
• Summary
• Chapter 2. Introducing MySQL
• What Is MySQL?
• MySQL Tools
• Summary
• Chapter 3. Working with MySQL
• Making the Connection
• Selecting a Database
• Learning About Databases and Tables
• Summary
• Chapter 4. Retrieving Data
• The SELECT Statement
• Retrieving Individual Columns
• Retrieving Multiple Columns
• Retrieving All Columns
• Retrieving Distinct Rows
• Limiting Results
• Using Fully Qualified Table Names
• Summary
• Chapter 5. Sorting Retrieved Data
• Sorting Data
• Sorting by Multiple Columns
• Specifying Sort Direction
• Summary
• Chapter 6. Filtering Data
• Using the WHERE Clause
• The WHERE Clause Operators
• Summary
• Chapter 7. Advanced Data Filtering
• Combining WHERE Clauses
• Using the IN Operator
• Using the NOT Operator
• Summary
• Chapter 8. Using Wildcard Filtering
• Using the LIKE Operator
• Tips for Using Wildcards
• Summary
• Chapter 9. Searching Using Regular Expressions
• Understanding Regular Expressions
• Using MySQL Regular Expressions
• Summary
• Chapter 10. Creating Calculated Fields
• Understanding Calculated Fields
• Concatenating Fields
• Performing Mathematical Calculations
• Summary
• Chapter 11. Using Data Manipulation Functions
• Understanding Functions
• Using Functions
• Summary
• Chapter 12. Summarizing Data
• Using Aggregate Functions
• Aggregates on Distinct Values
• Combining Aggregate Functions
• Summary
• Chapter 13. Grouping Data
• Understanding Data Grouping
• Creating Groups
• Filtering Groups
• Grouping and Sorting
• SELECT Clause Ordering
• Summary
• Chapter 14. Working with Subqueries
• Understanding Subqueries
• Filtering by Subquery
• Using Subqueries As Calculated Fields
• Summary
• Chapter 15. Joining Tables
• Understanding Joins
• Creating a Join
• Summary
• Chapter 16. Creating Advanced Joins
• Using Table Aliases
• Using Different Join Types
• Using Joins with Aggregate Functions
• Using Joins and Join Conditions
• Summary
• Chapter 17. Combining Queries
• Understanding Combined Queries
• Creating Combined Queries
• Summary
• Chapter 18. Full-Text Searching
• Understanding Full-Text Searching
• Using Full-Text Searching
• Summary
• Chapter 19. Inserting Data
• Understanding Data Insertion
• Inserting Complete Rows
• Inserting Multiple Rows
• Inserting Retrieved Data
• Summary
• Chapter 20. Updating and Deleting Data
• Updating Data
• Deleting Data
• Guidelines for Updating and Deleting Data
• Summary
• Chapter 21. Creating and Manipulating Tables
• Creating Tables
• Updating Tables
• Deleting Tables
• Renaming Tables
• Summary
• Chapter 22. Using Views
• Understanding Views
• Using Views
• Summary
• Chapter 23. Working with Stored Procedures
• Understanding Stored Procedures
• Why Use Stored Procedures
• Using Stored Procedures
• Summary
• Chapter 24. Using Cursors
• Understanding Cursors
• Working with Cursors
• Summary
• Chapter 25. Using Triggers
• Understanding Triggers
• Creating Triggers
• Dropping Triggers
• Using Triggers
• Summary
• Chapter 26. Managing Transaction Processing
• Understanding Transaction Processing
• Controlling Transactions
• Summary
• Chapter 27. Globalization and Localization
• Understanding Character Sets and Collation Sequences
• Working with Character Set and Collation Sequences
• Summary
• Chapter 28. Managing Security
• Understanding Access Control
• Managing Users
• Summary
• Chapter 29. Database Maintenance
• Backing Up Data
• Performing Database Maintenance
• Diagnosing Startup Problems
• Review Log Files
• Summary
• Chapter 30. Improving Performance
• Improving Performance
• Summary
• Appendix A. Getting Started with MySQL
• What You ll Need
• Obtaining the Software
• Installing the Software
• Preparing for Your Chapters
• Appendix B. The Example Tables
• Understanding the Sample Tables
• Creating the Sample Tables
• Appendix C. MySQL Statement Syntax
• ALTER TABLE
• COMMIT
• CREATE INDEX
• CREATE PROCEDURE
• CREATE TABLE
• CREATE USER
• CREATE VIEW
• DELETE
• DROP
• INSERT
• INSERT SELECT
• ROLLBACK
• SAVEPOINT
• SELECT
• START TRANSACTION
• UPDATE
• Appendix D. MySQL Datatypes
• String Datatypes
• Numeric Datatypes
• Date and Time Datatypes
• Binary Datatypes
• Appendix E. MySQL Reserved Words
• Developer s Library
• 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