MySQL Crash Course


book cover
MySQL® Crash Course
By Ben Forta
...............................................
Publisher: Sams
Pub Date: December 15, 2005
ISBN: 0-672-32712-0
Pages: 336
 



Table of Contents  | Index
overview

If you are a MySQL user who wants to find out more about the program, but is not interested in becoming a database administrator just to be able to read books on MySQL, then MySQL Crash Course is for you. This tutorial-based book is organized into a series of short, easy-to-follow lessons that take a very hands-on approach to meeting the needs of the average MySQL user. The essentials of MySQL are taught through a series of self-paced lessons in which you will complete exercises that illustrate the most important aspects of MySQL. You will learn how to:

  • Use the MySQL toolset.

  • Use the aggregate functions to analyze data.

  • Perform insert, update and delete operations.

  • Combine queries using unions.

  • Create and modify tables and access table schemas.

  • Manage databases, users and security privileges.

Don't get bogged down in the database theory and relational design of other MySQL books. Let SQL Crash Course teach you what you need to know, when you need to know it, so you can quickly get on your way with MySQL.

 



book cover
MySQL® Crash Course
By Ben Forta
...............................................
Publisher: Sams
Pub Date: December 15, 2005
ISBN: 0-672-32712-0
Pages: 336
 



Table of Contents  | Index

   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