MySQL for Developers
Capacitación
En Buenos Aires
Descripción
-
Tipología
Capacitación
-
Lugar
Buenos aires
-
Horas lectivas
40h
Dirigido a: Developers who want to learn MySQL 5.0
Sedes y fechas disponibles
Ubicación
inicio
inicio
Información relevante sobre el curso
Having attended the MySQL 5.0 for Beginners course or some experience with Relational Databases and SQL.
Opiniones
Plan de estudios
Understand the steps necessary to invoke MySQL client programs
Utilize the general-purpose mysql client program to run queries and retrieve results
Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
Explain the MySQL connectors that provide connectivity for client programs
Select the best data type for representing information in MySQL
Manage the structural characteristics of your databases
Manage the structural characteristics of the tables within your databases
Utilize the SELECT statement to retrieve information from database tables
Utilize expressions in SQL statements to retrieve more detailed information
Utilize SQL statements to modify the contents of database tables
Write join expressions in your SQL statements to obtain information from multiple tables
Utilize subqueries in your SQL statements
Create views utilizing SELECT statements to produce "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
Use the INFORMATION_SCHEMA database to access metadata
Debug MySQL applications
Configure and Optimize MySQL
Certification:
Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams
MySQL for Developers