课程长度: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