MySQL for Developers

CCyD - Centro de Capacitación y Desarrollo
En Buenos Aires

Precio a consultar
¿Preferís llamar ya al centro?
11527... Ver más
Compará este curso con otros similares
Ver más cursos similares

Información importante

  • Capacitación
  • Buenos aires
  • 40 horas de clase
Descripción


Dirigido a: Developers who want to learn MySQL 5.0

Información importante
Sedes

Dónde se enseña y en qué fechas

inicio Ubicación
Consultar
Buenos Aires
Buenos Aires, Argentina
Ver mapa

Preguntas Frecuentes

· Requisitos

Having attended the MySQL 5.0 for Beginners course or some experience with Relational Databases and SQL.

Temario

Describe the MySQL client/server architecture
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

Compará este curso con otros similares
Ver más cursos similares