MySQL开发应用课程

通过本课程可以学到：

•Describe the MySQL client/server architecture

•Invoke MySQL client programs

•Decribe the MySQL connectors that provide connectivity for client programs

•Select the best data type for table data

•Manage the structure of your databases

•Use the SELECT statement to retrieve information from database tables

•Use expressions in SQL statements to retrieve more detailed information

•Utilize SQL statements to modify the contents of database tables

•Write multiple table queries

•Use nested queries in your SQL statements

•Transactions

•Create "virtual tables" of specific data

•Perform bulk data import and export operations

•Create user defined variables, prepared statements and stored routines

•Create and manage triggers

•Acquiring metadata

•Debug MySQL applications

•Use of available storage engines

•Optimizing Queries