博学国际教育—官网

咨询热线:
400-882-5311

博学国际教育课程中心>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

· 培训世界 博学国际教育体验课 免费预约