Table of Contents


book cover
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



Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors: Chris Newman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net