Previous Section  < Day Day Up >  Next Section

• Table of Contents
• Index
MySQL® Certification Study Guide
By Paul DuBois, Stefan Hinz, Carsten Pedersen
Publisher: Sams Publishing
Pub Date: April 15, 2004
ISBN: 0-672-32632-9
Pages: 648

   About the Authors
   We Want to Hear from You!
   Reader Services
      About This Book
      Conventions Used in This Book
      Other Related Documents
      About the Exams
      Interpreting DESCRIBE Output
      Sample Tables
      Chapter 1.  MySQL and MySQL AB
      Section 1.1.  The Difference Between MySQL and MySQL AB
      Section 1.2.  How MySQL AB Operates
      Section 1.3.  MySQL Core Values
      Section 1.4.  MySQL Dual Licensing
      Section 1.5.  Organization and Structure of the MySQL Reference Manual
      Section 1.6.  The MySQL Mailing Lists
      Section 1.7.  Exercises
      Chapter 2.  MySQL Software
      Section 2.1.  Major Program Components Used in MySQL
      Section 2.2.  Major Operating System Families Supported by MySQL
      Section 2.3.  Differences Between Major MySQL Distributions
      Section 2.4.  Available MySQL Client Interfaces
      Section 2.5.  Exercises
      Chapter 3.  Using MySQL Client Programs
      Section 3.1.  Invoking Command-Line Client Programs
      Section 3.2.  The mysql Client Program
      Section 3.3.  Using mysqlimport
      Section 3.4.  Using mysqldump
      Section 3.5.  Checking Tables with mysqlcheck and myisamchk
      Section 3.6.  Using MySQLCC
      Section 3.7.  MySQL Connectivity Drivers
      Section 3.8.  Exercises
      Chapter 4.  Data Definition Language
      Section 4.1.  General Database and Table Properties
      Section 4.2.  Storage Engines and Table Types
      Section 4.3.  Limits on Number and Size of Database Components
      Section 4.4.  Identifier Syntax
      Section 4.6.  CREATE TABLE
      Section 4.7.  DROP TABLE
      Section 4.8.  ALTER TABLE
      Section 4.9.  Creating and Dropping Indexes
      Section 4.10.  Column Types
      Section 4.11.  Using SHOW and DESCRIBE to Review Table Structures
      Section 4.12.  Exercises
      Chapter 5.  The SELECT Statement
      Section 5.1.  Identifying What Values to Display
      Section 5.2.  Restricting a Selection Using WHERE
      Section 5.3.  Using ORDER BY to Sort Query Results
      Section 5.4.  Limiting a Selection Using LIMIT
      Section 5.5.  Aggregate Functions, GROUP BY, and HAVING
      Section 5.6.  Using DISTINCT to Eliminate Duplicates
      Section 5.7.  Concatenating SELECT Results with UNION
      Section 5.8.  Exercises
      Chapter 6.  Basic SQL
      Section 6.1.  Using SQL Expressions and Functions
      Section 6.2.  Using LIKE for Pattern Matching
      Section 6.3.  Using IN() to Test Membership in a List of Values
      Section 6.4.  Case Sensitivity of Identifiers and Reserved Words
      Section 6.5.  Using Reserved Words as Identifiers
      Section 6.6.  NULL Values
      Section 6.7.  Comments in SQL Statements
      Section 6.8.  Exercises
      Chapter 7.  Update Statements
      Section 7.1.  The INSERT and REPLACE Statements
      Section 7.2.  The UPDATE Statement
      Section 7.3.  The DELETE and TRUNCATE TABLE Statements
      Section 7.4.  Exercises
      Chapter 8.  Joins
      Section 8.1.  Writing Inner Joins
      Section 8.2.  Writing Outer Joins
      Section 8.3.  Converting Subqueries to Joins
      Section 8.4.  Resolving Name Clashes Using Qualifiers and Aliases
      Section 8.5.  Multiple-Table UPDATE and DELETE Statements
      Section 8.6.  Exercises
      Chapter 9.  Importing and Exporting Data
      Section 9.1.  The LOAD DATA INFILE Statement
      Section 9.2.  The SELECT … INTO OUTFILE Statement
      Section 9.3.  Datafile Format Specifiers
      Section 9.4.  Importing and Exporting NULL Values
      Section 9.5.  Exercises
      Chapter 10.  MySQL Architecture
      Section 10.1.  Client/Server Overview
      Section 10.2.  Choosing the Right Client
      Section 10.3.  Connecting the Client to the Server
      Section 10.4.  How MySQL Uses Disk Space
      Section 10.5.  How MySQL Uses Memory
      Section 10.6.  Log and Status Files
      Section 10.7.  MySQL Storage Engines
      Section 10.8.  Exercises
      Chapter 11.  MySQL Installation and Configuration
      Section 11.1.  Running MySQL on Windows
      Section 11.2.  Running MySQL on Unix
      Section 11.3.  Runtime MySQL Configuration
      Section 11.4.  Compiling MySQL from a Source Distribution
      Section 11.5.  Upgrading MySQL
      Section 11.6.  Optimizing the Operating System for MySQL Use
      Section 11.7.  Configuring Disks for MySQL Use
      Section 11.8.  Choosing Hardware for MySQL Use
      Section 11.9.  Exercises
      Chapter 12.  Security Issues
      Section 12.1.  Securing MySQL
      Section 12.2.  User Account Management
      Section 12.3.  Client Access Control
      Section 12.4.  Exercises
      Chapter 13.  Optimizing for Query Speed
      Section 13.1.  Index Optimization and Index Usage
      Section 13.2.  Using EXPLAIN to Analyze Queries
      Section 13.3.  General Query Enhancement
      Section 13.4.  Optimizing the Logical Database Structure
      Section 13.5.  Exercises
      Chapter 14.  MyISAM Tables
      Section 14.1.  Special MyISAM Features
      Section 14.2.  MyISAM-Specific Optimizations
      Section 14.3.  MyISAM Locking Strategies
      Section 14.4.  MyISAM Backup and Recovery
      Section 14.5.  Checking and Repairing MyISAM Tables
      Section 14.6.  MyISAM Table Maintenance
      Section 14.7.  Exercises
      Chapter 15.  InnoDB Tables
      Section 15.1.  The InnoDB Tablespace and Logs
      Section 15.2.  InnoDB Transaction Support
      Section 15.3.  How InnoDB Uses Locks
      Section 15.4.  InnoDB-Specific Optimizations
      Section 15.5.  InnoDB Backup and Recovery
      Section 15.6.  Checking and Repairing InnoDB Tables
      Section 15.7.  InnoDB Maintenance
      Section 15.8.  Exercises
      Chapter 16.  Advanced Server Features
      Section 16.1.  Interpreting mysqld Server Information
      Section 16.2.  Tuning Memory Parameters
      Section 16.3.  Using the Query Cache
      Section 16.4.  Using Multiple Servers
      Section 16.5.  Replication
      Section 16.6.  Exercises
      Appendix A.  Quick Reference
      Section A.1.  SQL Statements
      Section A.2.  SQL Functions
      Section A.3.  Column Types
      Section A.4.  Server System Variables
      Appendix B.  MySQL Certification Candidate Guide
      Section B.1.  What Is a MySQL Certification?
      Section B.2.  Other Sources of Information
      Section B.3.  The MySQL Certification Program
      Section B.4.  Registering for Exams
      Section B.5.  Preparing for the Exams
      Section B.6.  How the Exams Proceed
      Section B.7.  After the Exam
      Section B.8.  Staying Updated
      Section B.9.  How Long Are the Certifications Valid?
      Section B.10.  MySQL 4 Core Certification
      Section B.11.  Certified MySQL 4 Professional
      Section B.12.  Pearson VUE Contact Information
      Section B.13.  MySQL AB Certification NDA and LUA
Previous Section  < Day Day Up >  Next Section