咨询热线:    40000-53353(全国)    0571-28976118(浙江)    
 

MySQL数据库开发 预约试听

 

课程长度:5天/30小时

课程描述:

The MySQL for Developers course is the foundation course fordevelopers planning on designing and implementing applications that make use ofMySQL 5.0. This course covers essential SQL statements for data design,querying, and programming. In addition, it will prepare students for the MySQLDeveloper certification.Students who can benefit from thiscourse:

·Developers who want tocreate applications using MySQL

·Students wishing to preparefor the MySQL 5.0 Developer Certification Exams


学员基础:

Having attended the MySQL for Beginners course orsome experience with Relational Databases and SQL  


课程目标:

·Understand the stepsnecessary to invoke MySQL client programs

·Utilize the general-purposemysql client program and the MySQL Query Browser graphical user interface (GUI)to run queries and retrieve results

·Select the best data typefor representing information in MySQL

·Manage the structuralcharacteristics of your databases and the tables within your databases

·Utilize the SELECT statementto retrieve information from database tables

·Utilize expressions in SQLstatements to retrieve more detailed information

·Utilize SQL statements tomodify the contents of database tables

·Write join expressions inyour SQL statements to obtain information from multiple tables

·Utilize subqueries in yourSQL statements

·Create views utilizingSELECT statements to produce virtual tables of specific data

·Perform bulk data import andexport operations

·Create user definedvariables, prepared statements and stored routines

·Create and manage triggers

·Use the INFORMATION_SCHEMAdatabase to access metadata

·Debug MySQL applications

·Configure and Optimize MySQL


课程内容:

1.  Introduction

  • MySQL Overview, Products,     Services

  • MySQL Enterprise Services    

  • Supported Operating     Services

  • MySQL Certification     Program

  • Training Curriculum Paths    

  • MySQL Website

  • Installing MySQL

  • Installing the 'world'     Database

2.  Introduction

  • MySQL Overview, Products     and Services

  • MySQL Enterprise Services    

  • Supported Operating     Services

  • MySQL Certification     Program

  • Training Curriculum Paths    

  • MySQL Website

  • Installing MySQL and the     World Database

3.  MySQL Client/Server Concepts

  • MySQL General Architecture    

  • How MySQL Uses Disk Space    

  • How MySQL Uses Memory

4.  MySQL Clients

  • Invoking Client Programs

  • Using Option Files

  • The MySQL Client

  • MySQL Query Browser

  • MySQL Connectors

  • Third-Party APIs

5.  Querying for Table Data

  • The SELECT Statement

  • Aggregating Query Results    

  • Using UNION    

6.  Handling Errors and Warnings

  • SQL Modes

  • Handling Missing or     Invalid Data Values

  • Interpreting Error     Messages

7.  SQL Expressions

  • SQL Comparisons

  • Functions in SQL     Expressions

  • Comments in SQL     Statements

8.  Data Types

  • Data Type Overview

  • Numeric Data Types

  • Character String Data     Types

  • Binary String Data Types

  • Temporal Data Types

  • NULLs

9.  Obtaining Metadata

  • Metadata Access Methods

  • The INFORMATION_SCHEMA     Database/Schema

  • Using SHOW and DESCRIBE

  • The mysqlshow Command

10.Databases

  • Database Properties

  • Good Design Practices

  • Identifiers

  • Creating Databases

  • Altering Databases

  • Dropping Databases

11.Tables

  • Creating Tables

  • Table Properties

  • Column Options

  • Creating Tables Based on     Existing Tables

  • Altering Tables

  • Dropping Tables

  • Foreign Keys

12.Manipulating Table Data

  • The INSERT Statement

  • The DELETE Statement

  • The UPDATE Statement

  • The REPLACE Statement

  • INSERT with ON DUPLICATE     KEY UPDATE

  • The TRUNCATE TABLE     Statement

13.Transactions

  • What is a Transaction?

  • Transaction Commands

  • Isolation Levels

  • Locking

14.Joins

  • What is a Join?

  • Joining Tables in SQL

  • Basic Join Syntax

  • Inner Joins

  • Outer Joins

  • Other Types of Joins

  • Joins in UPDATE and     DELETE statements

15.Subqueries

  • Types of Subqueries

  • Table Subquery Operators

  • Correlated and     Non-Correlated Subqueries

  • Converting Subqueries to     Joins

16.Views

  • What Are Views?

  • Creating Views

  • Updatable Views

  • Managing Views

  • Obtaining View Metadata

17.Prepared Statements

  • Why Use Prepared     Statements?

  • Using Prepared Statements     from the mysql Client

  • Preparing a Statement

  • Executing a Prepared     Statement

  • Deallocating a Prepared     Statement

18.Exporting and Importing Data

  • Exporting and Importing     Data

  • Exporting and Importing     Data Using SQL

  • Exporting and Importing     Data Using MySQL Client Programs

  • Import Data with the SOURCE     Command

19.Stored Routines

  • What is a Stored Routine?    

  • Creating, Executing and     Deleting Stored Routines

  • Compound Statements

  • Assign Variables

  • Parameter Declarations

  • Flow Control Statements

  • Declare and Use Handlers

  • Cursors

20.Triggers

  • What are Triggers?

  • Delete Triggers

  • Restrictions on Triggers

21.Storage Engines

  • SQL Parser and Storage     Engine Tiers

  • Storage Engines and MySQL    

  • The MyISAM Storage Engine    

  • The InnoDB Storage Engine    

  • The MEMORY Storage Engine    

  • Other Storage Engines

22.Optimization

  • Overview of Optimization     Principles

  • Using Indexes for     Optimization

  • Using EXPLAIN to Analyze     Queries

  • Query Rewriting     Techniques

  • Optimizing Queries by     Limiting Output

  • Using Summary Tables

  • Optimizing Updates

  • Choosing Appropriate     Storage Engines TOPIC22 Conclusion