MySQL Certification Study Guide
暫譯: MySQL 認證學習指南

Paul DuBois, Stefan Hinz, Carsten Pedersen

MySQL Certification Study Guide
  • 出版商: SAMS
  • 出版日期: 2004-04-15
  • 售價: $2,050
  • 貴賓價: 9.5 折 $1,948
  • 語言: 英文
  • 頁數: 648
  • 裝訂: Paperback
  • ISBN: 0672326329
  • ISBN-13: 9780672326325
  • 相關分類: MySQL、SQL

    • 已過版

買這商品的人也買了...

相關主題

商品描述

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.

Index

商品描述(中文翻譯)

《MySQL 認證學習指南》是準備 MySQL 核心認證和 MySQL 專業認證考試的權威學習指南。

MySQL 認證計畫是一個精心設計的高品質認證過程，可以幫助您證明自己在使用、維護和管理 MySQL 數據庫伺服器及其他 MySQL AB 技術方面的技能。

《MySQL 認證學習指南》涵蓋了基本的 MySQL 核心認證考試和進階的 MySQL 專業認證考試，是您準備這兩個考試時的權威參考書。這本書教您所有需要了解的概念、原則和技術，以便通過核心和專業認證考試，並包含各種學習輔助工具、練習題和實際範例，幫助您為考試日做好準備。

獲得認證的計算機專業人士通常會發現，擁有經過證明的、被認可的資格可以使他們在各自的領域更進一步，提升職業生涯，並使他們成為公司或組織中更好、更具生產力的員工。無論您成為 MySQL 認證的原因是什麼，《MySQL 認證學習指南》都提供了您需要的信息，幫助您更好地理解 MySQL 技術，並為考試做好準備和通過考試。

特別優惠 - 購買本書可享 MySQL 考試 25% 折扣！

購買《MySQL 認證學習指南》的一本副本，您將有資格獲得 MySQL 核心認證考試報名費用的 25% 折扣。詳情請參見書籍的封底。

目錄：

1. MySQL 和 MySQL AB
MySQL 和 MySQL AB 之間的差異。MySQL AB 的運作方式。MySQL 的核心價值。MySQL 雙重授權。MySQL 參考手冊的組織和結構。MySQL 郵件列表。練習題。

2. MySQL 軟體
MySQL 中使用的主要程式組件。MySQL 支援的主要作業系統系列。主要 MySQL 發行版之間的差異。可用的 MySQL 客戶端介面。練習題。

3. 使用 MySQL 客戶端程式
調用命令行客戶端程式。mysql 客戶端程式。使用 mysqlimport。使用 mysqldump。使用 mysqlcheck 和 myisamchk 檢查表。使用 MySQLCC。MySQL 連接驅動程式。練習題。

4. 數據定義語言
一般數據庫和表屬性。儲存引擎和表類型。數據庫組件的數量和大小限制。標識符語法。CREATE DATABASE 和 DROP DATABASE。CREATE TABLE。DROP TABLE。ALTER TABLE。創建和刪除索引。列類型。使用 SHOW 和 DESCRIBE 來檢查表結構。練習題。

5. SELECT 語句
確定要顯示的值。使用 WHERE 限制選擇。使用 ORDER BY 對查詢結果進行排序。使用 LIMIT 限制選擇。聚合函數、GROUP BY 和 HAVING。使用 DISTINCT 消除重複。使用 UNION 連接 SELECT 結果。練習題。

6. 基本 SQL
使用 SQL 表達式和函數。使用 LIKE 進行模式匹配。使用 IN() 測試值列表中的成員資格。標識符和保留字的大小寫敏感性。將保留字用作標識符。NULL 值。SQL 語句中的註釋。練習題。

7. 更新語句
INSERT 和 REPLACE 語句。UPDATE 語句。DELETE 和 TRUNCATE TABLE 語句。練習題。

8. 連接
編寫內部連接。編寫外部連接。將子查詢轉換為連接。使用限定符和別名解決名稱衝突。多表 UPDATE 和 DELETE 語句。練習題。

9. 數據的導入和導出
LOAD DATA INFILE 語句。SELECT INTO OUTFILE 語句。數據文件格式說明符。導入和導出 NULL 值。練習題。

10. MySQL 架構
客戶端/伺服器概述。選擇合適的客戶端。將客戶端連接到伺服器。MySQL 如何使用磁碟空間。MySQL 如何使用記憶體。日誌和狀態文件。MySQL 儲存引擎。練習題。

11. MySQL 安裝和配置
在 Windows 上運行 MySQL。在 Unix 上運行 MySQL。運行時 MySQL 配置。從源代碼發行版編譯 MySQL。升級 MySQL。為 MySQL 使用優化作業系統。為 MySQL 使用配置磁碟。為 MySQL 使用選擇硬體。練習題。

12. 安全問題
保護 MySQL。用戶帳戶管理。客戶端訪問控制。練習題。

13. 查詢速度優化
索引優化和索引使用。使用 EXPLAIN 分析查詢。一般查詢增強。優化邏輯數據庫結構。練習題。

14. MyISAM 表
特殊的 MyISAM 功能。MyISAM 特定的優化。MyISAM 鎖定策略。MyISAM 備份和恢復。檢查和修復 MyISAM 表。MyISAM 表維護。練習題。

15. InnoDB 表
InnoDB 表空間和日誌。InnoDB 事務支持。InnoDB 如何使用鎖。InnoDB 特定的優化。InnoDB 備份和恢復。檢查和修復 InnoDB 表。InnoDB 維護。練習題。

16. 進階伺服器功能
解讀 mysqld 伺服器信息。調整記憶體參數。使用查詢快取。使用多個伺服器。複製。練習題。

附錄 A. 快速參考
SQL 語句。SQL 函數。列類型。伺服器系統變數。

附錄 B. MySQL 認證候選人指南
MySQL 認證是什麼？其他信息來源。MySQL 認證計畫。報名考試。準備考試。考試進行方式。考試後。保持更新。認證有效期多久？MySQL 4 核心認證。認證 MySQL 4 專業。Pearson VUE 聯絡信息。MySQL AB 認證 NDA 和 LUA。

索引

類似商品