MySQL 5.0认证指南：企业级采用的基石

需积分: 10 94 浏览量更新于2024-07-18 收藏 16.65MB PDF 举报

《MySQL® 5.0认证学习指南》是一本专门针对MySQL 5.0数据库管理系统认证考试而编写的教材，由Paul DuBois、Stefan Hinz和Carsten Pedersen三位作者共同创作。MySQL作为开源数据库系统，自发布以来在全球范围内得到了广泛的应用，尤其在企业领域，随着MySQL 5.0版本的推出，其采用率预计将迅速提升。本书旨在帮助读者理解和准备MySQL 5.0的相关认证考试，包括MySQL开发者考试。该书的内容涵盖了多个关键主题，包括客户端/服务器概念、mysql客户端程序的使用、MySQL Query Browser功能、以及MySQL Connectors（连接器）的介绍。以下是一些详细知识点： 1. **MySQL Developer Exams**：书中重点介绍了MySQL Developer I Exam，这是认证的一部分，测试考生对MySQL 5.0基础知识和技能的掌握，如SQL语句、数据类型、索引、事务处理等。 2. **Chapter 1 - Client/Server Concepts**：这部分深入解析了MySQL的通用架构，包括客户端与服务器之间的交互方式。还讲解了SQL模式（Server SQL Modes），它们影响数据库的行为，如严格模式和宽容模式的选择。 3. **Chapter 2 - mysql Client Program**：详细介绍了mysql命令行工具的使用方法，如交互式使用、命令终止符、编辑键的运用、脚本文件的支持、输出格式设置以及server-side help的利用。还提到了--safe-updates选项，用于防止意外的数据修改。 4. **Chapter 3 - MySQL Query Browser**：这一章节介绍了MySQL Query Browser，一个图形化界面工具，可以帮助用户执行查询、查看数据库结构、管理连接，并提供了查询窗口和表编辑器等功能。 5. **Chapter 4 - MySQL Connectors**：探讨了MySQL的各种客户端接口，如ODBC、JDBC、PHP、Python等，让读者了解如何通过不同的编程语言和环境与MySQL服务器进行集成。通过这本书，读者不仅可以提升技术能力，还能了解到MySQL 5.0在企业级应用中的最新趋势和发展。对于想要获得MySQL认证的专业人士和数据库管理员来说，这是一本不可或缺的参考书。随着MySQL用户的持续增长，这本书的重要性也将随之增强，因为它提供了一条清晰的学习路径和实践经验，以适应不断变化的技术需求。

Introduction

Manuals

n Before going to any of the exams, make sure you have familiarized yourself with the

MySQL Reference Manual. Familiarizing yourself with the manual is not the same as

knowing every word in it, but you should at least skim through it and look more closely

at those parts that pertain to the particular exam which you are going to attend.

n Before taking either of the Developer exams, you should read the MySQL Query

Browser Manual.

n Before taking either of the DBA exams, you should read the MySQL Administrator

Manual.

Each of the manuals just listed is available on the MySQL developer Web site,

http://dev.mysql.com. You will also find many good technical articles on that Web site.

These articles do not make up part of the exam curriculum per se, but they explain many of

the concepts presented in this book in a different way and may enable you to get a better

perspective on some details.

Sample Data

Almost all examples and exercises in this study guide use the world database as the sample

data set. The accompanying CD-ROM contains the data for this database and instructions

that describe how to create and populate the database for use with your own MySQL

installation.

Study Guide Errata

Although this book was thoroughly checked for correctness prior to publication, errors

might remain. Any errors found after publication are noted at

http://www.mysql.com/

certification/studyguides

Certification Information at www.mysql.com

The Certification pages at http://www.mysql.com/certification contain the overview of the

current state of all things you need to know about the MySQL certification program. It is

recommended that you read through this information as you start planning your certifica-

tion, as well as when you plan to go to exams to ensure that you are aware of any last-

minute updates.

The Certification area of the MySQL Web site provides comprehensive information on the

certifications offered, upcoming certifications and betas, training offers, and so forth. After

you’ve taken a certification exam, the Web site is also where you will be able to check the

status of your certification.

MySQL® 5.0 Certification Study Guide Page 10 Return to Table of Contents

MySQL® 5.0 Certification Study Guide

MySQL® 5.0 Certification Study Guide By Paul DuBois, Stefan Hinz, Carsten Pedersen

ISBN: 0672328127 Publisher: MySQL Press

Prepared for Francisco Leon Nieto, Safari ID: Francisco.Leon@Sun.COM

Licensed by Francisco Leon Nieto

Print Publication Date: 2005/08/24 User number: 1276591

Licensed by

Francisco Leon Nieto

Introduction

The MySQL Certification Candidate Guide

Of particular interest on the MySQL certification Web pages is the MySQL Certification

Candidate Guide. It contains the overall description of the MySQL Certification program, as

well as all the practical information you will need in order to write an exam. The latest ver-

sion of the Candidate Guide can be found at

http://www.mysql.com/certification/

candguide

The Candidate Guide contains a list of items providing practical advice to you as the candi-

date, an overview of the entire certification program, prices, policies, practical details

regarding going to the exam, and so forth.

The Candidate Guide includes the MySQL Certification Non-Disclosure and Logo Usage

Agreement (NDA/LUA). You’ll be asked to agree to the agreement when you go to take the

exam. At that point, legal agreements will probably be the last thing on your mind, so read-

ing the agreement before you go will save you some distraction and also some exam time.

The Certification Mailing List

Anyone considering pursuing MySQL certification should subscribe to the MySQL

Certification mailing list. This is a low-volume list (messages go out once every two months

or so), to which MySQL AB posts news related to the certification program. The subscrip-

tion address for the mailing list is

certification-subscribe@lists.mysql.com. To subscribe,

send an empty message to that address.

Conventions Used in This Book

This section explains the conventions used in this study guide.

Text in this style is used for program and shell script names, SQL keywords, and com-

mand output.

Text in this style represents input that you would type while entering a command or state-

ment.

Text in this style represents variable input for which you’re expected to enter a value of

your own choosing. Some examples show commands or statements that aren’t meant to be

entered exactly as shown. Thus, in an example such as the following, you would substitute

the name of some particular table for

table_name:

SELECT * FROM table_name;

In syntax descriptions, square brackets indicate optional information. For example, the fol-

lowing syntax for the

DROP TABLE statement indicates that you can invoke the statement with

or without an

IF EXISTS clause:

DROP TABLE [IF EXISTS] table_name;

MySQL® 5.0 Certification Study Guide Page 11 Return to Table of Contents

MySQL® 5.0 Certification Study Guide

MySQL® 5.0 Certification Study Guide By Paul DuBois, Stefan Hinz, Carsten Pedersen

ISBN: 0672328127 Publisher: MySQL Press

Prepared for Francisco Leon Nieto, Safari ID: Francisco.Leon@Sun.COM

Licensed by Francisco Leon Nieto

Print Publication Date: 2005/08/24 User number: 1276591

Introduction

Lists of items are shown with items separated by vertical bars. If choosing an item is option-

al, the list is enclosed within square brackets. If choosing an item is mandatory, the list is

enclosed within curly braces:

[ item1 | item2 | item3 ]

{ item1 | item2 | item3 }

In most cases, SQL statements are shown with a trailing semicolon character (‘;’). The

semicolon indicates where the statement ends and is useful particularly in reading multiple-

statement examples. However, the semicolon is not part of the statement itself.

If a statement is shown together with the output that it produces, it’s shown preceded by a

mysql> prompt. An example shown in this manner is meant to illustrate the output you

would see were you to issue the statement using the

mysql client program. For example, a

section that discusses the use of the

VERSION() function might contain an example like this:

mysql> SELECT VERSION();

+-----------------+

| VERSION() |

+-----------------+

| 5.0.10-beta-log |

+-----------------+

Some commands are intended to be invoked from the command line, such as from a

Windows console window prompt or from a Unix shell prompt. In this guide, these com-

mands are shown preceded by a

shell> prompt. Some Windows-specific examples use a

prompt that begins with

C:. The prompt you will actually see on your own system depends

on your command interpreter and the prompt settings you use. (The prompt is likely to be

C:\> for a Windows console and % or $ for a Unix shell.)

SQL keywords such as

SELECT or ORDER BY aren’t case sensitive in MySQL and may be speci-

fied in any lettercase when you issue queries. However, for this guide, keywords are written

in uppercase letters to help make it clear when they’re being used as keywords and not in a

merely descriptive sense. For example, “

UPDATE statement” refers to a particular kind of SQL

statement (one that begins with the keyword

UPDATE), whereas “update statement” is a

descriptive term that refers more generally to any kind of statement that updates or modifies

data. The latter term includes

UPDATE statements, but also other statements such as INSERT,

REPLACE, and DELETE.

Sample commands generally omit options for specifying connection parameters, such as

--host or --user to specify the server host or your MySQL username. It’s assumed that

you’ll supply such options as necessary. Chapter 1, “Client/Server Concepts,” discusses con-

nection parameter options.

In answers to exercises that involve invocation of client programs, you might also have to

provide options for connection parameters. Those options generally are not shown in the

answers.

MySQL® 5.0 Certification Study Guide Page 12 Return to Table of Contents

MySQL® 5.0 Certification Study Guide

MySQL® 5.0 Certification Study Guide By Paul DuBois, Stefan Hinz, Carsten Pedersen

ISBN: 0672328127 Publisher: MySQL Press

Prepared for Francisco Leon Nieto, Safari ID: Francisco.Leon@Sun.COM

Licensed by Francisco Leon Nieto

Print Publication Date: 2005/08/24 User number: 1276591

Introduction

Running MySQL on Microsoft Windows

Windows-specific material in this Guide (and the certification exams) assumes a version of

Windows that is based on Windows NT. This includes Windows NT, 2000, XP, and 2003.

It does not include Windows 95, 98, or Me.

About the Exams

To take a MySQL certification exam, you must go to a Pearson VUE testing center.

MySQL AB creates the exams and defines the content, the passing score, and so forth.

Pearson VUE is responsible for delivering the exams to candidates worldwide.

Registering for an Exam

There are three ways to register for an exam:

n You can use the Pearson VUE Web site, http://www.vue.com/mysql. Note that you

must pre-register on the Web site to set up an account with VUE. VUE processes your

application and notifies you when your account is ready. This process usually takes

about 24 hours. After your account has been set up, you can register for the exam you

want to take.

n You can call one of the VUE call centers. The telephone numbers are listed in on the

Pearson VUE Web site:

http://www.vue.com/contact/mysql.

n You can register directly at your local VUE test center on the day of the exam. A com-

plete list of the test centers can be found on the Web at

http://www.vue.com/mysql.

Click on the Test Centers link about halfway down the page to find a testing center

near you. Note that many test centers have limited hours of operation, so it’s always a

good idea to call ahead to ensure that you can be accommodated at the time you want

to take the exam.

MySQL AB recommends that you use the VUE Web site for exam registration and pay-

ment, but you’re welcome to use any method you choose.

If you register through the Web or a call center, a receipt will be sent to you as soon as the

registration process is completed. If you register directly at the test center, please ask for

your receipt when you submit payment.

Going to the Exam

On the day of your exam, you should ensure that you arrive at the test center well ahead of

the appointed time (at least 15 minutes early is recommended). When you arrive at the test-

ing center, you will be asked by the test administrator to:

MySQL® 5.0 Certification Study Guide Page 13 Return to Table of Contents

MySQL® 5.0 Certification Study Guide

MySQL® 5.0 Certification Study Guide By Paul DuBois, Stefan Hinz, Carsten Pedersen

ISBN: 0672328127 Publisher: MySQL Press

Prepared for Francisco Leon Nieto, Safari ID: Francisco.Leon@Sun.COM

Licensed by Francisco Leon Nieto

Print Publication Date: 2005/08/24 User number: 1276591

剩余574页未读，继续阅读

rendezvoush

粉丝: 1
资源: 2

MySQL 5.0认证指南：企业级采用的基石

MySQL_5.0_Certification_Study_Guide

MySQL® 5 Certification Study Guide

mysql server 5.0安装教程

mysql5.0和5.0以上的区别

mysql server5.0的安装及配置

介绍MySQL和MySQL5.0

linux安装mysql5.0

mysql数据库5.0版本

mysql5.0前后版本差异

服务器上面的mysql5.7删掉.安装mysql5.0进去

最新资源