Lekkinet Technologies

MySQL for Developers

Lekkinet Technologies
En Benito Juárez

$ 30,509
más IVA
*Precio Orientativo
Importe original en USD:
US$ 1,499
¿Quieres hablar con un Asesor sobre este curso?

Información importante

Tipología Capacitación laboral
Lugar Benito juárez
Horas lectivas 40h
  • Capacitación laboral
  • Benito juárez
  • 40h
Descripción

Objetivo del curso: This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification. Destinatarios del curso: This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification. Do you want to transfer your data from one server to another?. Then MySQL for Developers is for you! With an Authorized MySQL instruct

Instalaciones (1) y fechas
Dónde se imparte y en qué fechas
Inicio Ubicación
Consultar
Benito Juárez
San Lorenzo 1009, 03100, Ciudad de México (Distrito Federal), México
Ver mapa
Inicio Consultar
Ubicación
Benito Juárez
San Lorenzo 1009, 03100, Ciudad de México (Distrito Federal), México
Ver mapa

Preguntas Frecuentes

· Requisitos

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

Programa académico

At the completion of this course, you should be able to:
  • 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
Who should Attend
  • Developers who want to learn MySQL 5.0

Los usuarios que se interesaron por este curso también han mostrado interés por...
Ver más cursos similares