MySQL 5

Certification Study Guide

Paul DuBois, Stefan Hinz, Carsten Pedersen

650 pages, parution le 22/11/2005

Ajouter à une liste

Indisponible

Résumé

The MySQL certification program is a carefully developed, high-quality certification process that can help you prove your skills in developing, maintaining, and administering MySQL databases and applications.

Covering the MySQL 5.0 Certified Developer and the MySQL 5.0 Certified DBA exams, the MySQL 5.0 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 exams, and it includes a CD-ROM full 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 your reason for becoming MySQL certified, MySQL 5.0 Certification Study Guide gives you the information you need to help you better understand MySQL technologies and prepare for and pass the exams.

L'auteur - Paul DuBois

Paul DuBois is a writer, database administrator, and leader in the Open Source and MySQL communities. He contributed to the online documentation for MySQL and is the author MySQL and Perl for the Web (New Riders Publishing), and MySQL Cookbook, Using csh and tcsh, and Software Portability with imake (O'Reilly and Associates).

L'auteur - Stefan Hinz

Stefan Hinz is a member of the MySQL AB documentation team, a MySQL trainer and consultant, and the German translator of the MySQL Reference Manual.

L'auteur - Carsten Pedersen

Carsten Pedersen is the MySQL AB certification manager, and has led the development of the MySQL certification program. He has also taught several MySQL courses in a number of countries.

Sommaire

Client/Server Concepts
The mysql Client Program
MySQL Query Browser
MySQL Connectors
Data Types
Identifiers
Databases
Tables and Indexes
Querying for Data
SQL Expressions
Updating Data
MySQL Developer II Exam
Joins
Subqueries
Views
Importing and Exporting Data
User Variables
Prepared Statements
Stored Procedures and Functions
Triggers
Obtaining Database Metadata
Debugging MySQL Applications
Basic Optimizations
MySQL DBA Exams
MySQL DBA I Exam
MySQL Architecture
Starting, Stopping, and Configuring MySQL
Client Programs for DBA Work
MySQL Administrator
Character Set Support
Locking
Storage Engines
Table Maintenance
The Information_Schema Database
Data Backup and Recovery Methods
Using Stored Routines and Triggers for Administration
MySQL DBA II EXAM
User Management
Securing the MySQL Installation
Upgrade-Related Security Issues
Optimizing Queries
Optimizing Databases
Optimizing the Server
Interpreting Diagnostic Messages
Optimizing the Environment
Scaling MySQL
Appendixes

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	MySQL Press
Auteur(s)	Paul DuBois, Stefan Hinz, Carsten Pedersen
Parution	22/11/2005
Nb. de pages	650
Format	19 x 22,5
Couverture	Broché
Poids	1060g
Intérieur	Noir et Blanc
EAN13	9780672328121
ISBN13	978-0-672-32812-1