MySQL Certification Study Guide

Paul DuBois, Stefan Hinz, Carsten Pedersen

  • 出版商: SAMS
  • 出版日期: 2004-04-15
  • 售價: $1,630
  • 貴賓價: 9.5$1,549
  • 語言: 英文
  • 頁數: 648
  • 裝訂: Paperback
  • ISBN: 0672326329
  • ISBN-13: 9780672326325
  • 相關分類: MySQLSQL




The authoritative study guide to prepare for the MySQL Core Certification and MySQL Professional Certification exams.

The MySQL certification program is a carefully developed, high-quality certification process that can help you prove your skills in using, maintaining, and administering MySQL database servers and other technologies from MySQL AB.

Covering both the basic MySQL Core Certification exam and the advanced MySQL Professional Certification exam, MySQL Certification Study Guide is the one authority to look to when you¿re preparing for either test. The book teaches you all the concepts, principles, and techniques that you¿ll need to know for the Core and Professional certification exams, and it includes an array of learning aids, practice questions, and real-world examples to help you prepare for test day.

Certified computer professionals often find that having proven, recognized credentials can advance them farther in their fields, give their careers a boost, and make them better, more productive employees for their companies or organizations. Whatever reason for becoming MySQL certified, MySQL Certification Study Guide gives you the information you need to help you better understand MySQL technologies and prepare for and pass the exams.

Special Offer - Purchase this book and receive 25% off your MySQL exam!

Purchase of a copy of the MySQL Certification Study Guide entitles you to receive 25% off the cost of registration for the MySQL Core Certification exam. Details on the back cover of the boo

Table of Contents:

1. MySQL and MySQL AB.

The Difference Between MySQL and MySQL AB. How MySQL AB Operates. MySQL Core Values. MySQL Dual Licensing. Organization and Structure of the MySQL Reference Manual. The MySQL Mailing Lists. Exercises.

2. MySQL Software.

Major Program Components Used in MySQL. Major Operating System Families Supported by MySQL. Differences Between Major MySQL Distributions. Available MySQL Client Interfaces. Exercises.

3. Using MySQL Client Programs.

Invoking Command-Line Client Programs. The mysql Client Program. Using mysqlimport. Using mysqldump. Checking Tables with mysqlcheck and myisamchk. Using MySQLCC. MySQL Connectivity Drivers. Exercises.

4. Data Definition Language.

General Database and Table Properties. Storage Engines and Table Types. Limits on Number and Size of Database Components. Identifier Syntax. CREATE DATABASE and DROP DATABASE. CREATE TABLE. DROP TABLE. ALTER TABLE. Creating and Dropping Indexes. Column Types. Using SHOW and DESCRIBE to Review Table Structures. Exercises.

5. The SELECT Statement.

Identifying What Values to Display. Restricting a Selection Using WHERE. Using ORDER BY to Sort Query Results. Limiting a Selection Using LIMIT. Aggregate Functions, GROUP BY, and HAVING. Using DISTINCT to Eliminate Duplicates. Concatenating SELECT Results with UNION. Exercises.

6. Basic SQL.

Using SQL Expressions and Functions. Using LIKE for Pattern Matching. Using IN() to Test Membership in a List of Values. Case Sensitivity of Identifiers and Reserved Words. Using Reserved Words as Identifiers. NULL Values. Comments in SQL Statements. Exercises.

7. Update Statements.

The INSERT and REPLACE Statements. The UPDATE Statement. The DELETE and TRUNCATE TABLE Statements. Exercises.

8. Joins.

Writing Inner Joins. Writing Outer Joins. Converting Subqueries to Joins. Resolving Name Clashes Using Qualifiers and Aliases. Multiple-Table UPDATE and DELETE Statements. Exercises.

9. Importing and Exporting Data.

The LOAD DATA INFILE Statement. The SELECT INTO OUTFILE Statement. Datafile Format Specifiers. Importing and Exporting NULL Values. Exercises.

10. MySQL Architecture.

Client/Server Overview. Choosing the Right Client. Connecting the Client to the Server. How MySQL Uses Disk Space. How MySQL Uses Memory. Log and Status Files. MySQL Storage Engines. Exercises.

11. MySQL Installation and Configuration.

Running MySQL on Windows. Running MySQL on Unix. Runtime MySQL Configuration. Compiling MySQL from a Source Distribution. Upgrading MySQL. Optimizing the Operating System for MySQL Use. Configuring Disks for MySQL Use. Choosing Hardware for MySQL Use. Exercises.

12. Security Issues.

Securing MySQL. User Account Management. Client Access Control. Exercises.

13. Optimizing for Query Speed.

Index Optimization and Index Usage. Using EXPLAIN to Analyze Queries. General Query Enhancement. Optimizing the Logical Database Structure. Exercises.

14. MyISAM Tables.

Special MyISAM Features. MyISAM-Specific Optimizations. MyISAM Locking Strategies. MyISAM Backup and Recovery. Checking and Repairing MyISAM Tables. MyISAM Table Maintenance. Exercises.

15. InnoDB Tables.

The InnoDB Tablespace and Logs. InnoDB Transaction Support. How InnoDB Uses Locks. InnoDB-Specific Optimizations. InnoDB Backup and Recovery. Checking and Repairing InnoDB Tables. InnoDB Maintenance. Exercises.

16. Advanced Server Features.

Interpreting mysqld Server Information. Tuning Memory Parameters. Using the Query Cache. Using Multiple Servers. Replication. Exercises.

Appendix A. Quick Reference.

SQL Statements. SQL Functions. Column Types. Server System Variables.

Appendix B. MySQL Certification Candidate Guide.
What Is a MySQL Certification? Other Sources of Information. The MySQL Certification Program. Registering for Exams. Preparing for the Exams. How the Exams Proceed. After the Exam. Staying Updated. How Long Are the Certifications Valid? MySQL 4 Core Certification. Certified MySQL 4 Professional. Pearson VUE Contact Information. MySQL AB Certification NDA and LUA.