REDCAPACITACION Chile, El Portal de la Capacitación
  Requerimientos de capacitación   Requerimientos de relatores   Requerimientos de servicios

Curso de Capacitacin: CERTIFICACION MYSQL DEVELOPER CMDEV

CERTIFICACION MYSQL DEVELOPER CMDEV

Centro de Capacitacin

Logo Oferente

Descripcin

Contenidos

Introduction

MySQL Product
MySQL Services and Support
MySQL Resources
Example Databases
MySQL Client/Server Concepts

MySQL General Architecture
Diskspace use
Memory use
MySQL Clients

Invoking Client Programs
Using Option Files
The MySQL Client
MySQL Workbench
MySQL Connectors
Third Party APIs
Querying for Table Data

The SELECT Statement
Aggregating Query Results
Using UNION
Import and Export Data
Handling Errors and Warnings

SQL Modes
Handling Missing or Invalid Data Values
Interpreting Error Messages
Conditions and Signals
Error Handling when using Connectors
Data Types

Data Type Overview
Numeric Data Types
Character String Data Types
Binary String Data Types
Temporal Data Types
Spatial Data Types
NULLs
SQL Expressions

SQL Comparisons
Functions in SQL Expressions
Comments in SQL Statements
Obtaining Metadata

Metadata Access Methods
The INFORMATION_SCHEMA Database/Schema
Using SHOW and DESCRIBE
The mysqlshow Command
Database

Database Properties
Good Design Practices
Identifiers
Creating Databases
Altering Databases
Dropping Databases
Tables

Creating Tables
Table Properties
Column Options
Creating Tables Based on Existing Tables
Altering Tables
Dropping Tables
Foreign Keys
Manipulating Table Data

The INSERT Statement
The DELETE Statement
The UPDATE Statement
The Replace Statement
INSERT with ON DUPLICATE KEY UPDATE
The TRUNCATE TABLE Statement
Transactions

What is a Transaction
Transaction Commands
Isolations Levels
Locking
Joins

What is a Join?
Joining Tables in SQL
Basic Join Syntax
Inner Joins
Outer Joins
Other Types of Joins
Joins in UPDATE and DELETE statements
Subqueries

Types of Subqueries
Table Subquery Operators
Correlated and Non-Correlated Subqueries
Converting Subqueries to Joins
Views

What are Views?
Creating Views
Updating Views
Managing Views
Obtaining View Metadata
Prepared Statements

Why use Prepared Statements
Using Prepared Statements for the mysql client
Executing a Prepared Statement
Deallocating a Prepared Statement
Programming with Prepared Statements
Stored Routines

What is a Stored Routine?
Creating Stored Routines
Compound Statements
Assign Variables
Parameter Declaration
Execute Stored Routines
Stored Routine Characteristics
Examine Stored Routines
Triggers

What are Triggers
When to Use Triggers
How to Delete Triggers
Restrictions on Triggers
Optimization and Monitoring

Overview of Optimization Principles
Using Indexes for Optimization
Using EXPLAIN to Analyze Queries
Using Performance Schema to Analyze Performance
Query rewriting techniques
Optimizing Queries by Limiting Output
Using Summary Tables
Optimizing Updates

Otros Datos

rea: MySQL
Dirigida a:
Relator:
Horas Tericas: 20 | Horas Prcticas: 20
Modalidad: Presencial
Valor referencial por persona: $ 500000

Otros Comentarios

Prerequisitos Requeridos:

Experience with having created tables and queries within relational Databases, and comfort with basic SQL statements and another programming language.

MySQL for Beginners NEW


Cotice este curso

Palabras Claves




Eventos


Herramientas De Primeros Auxilios
Ver ms

Curso de Legislacion laboral en la gestin del recurso humano
Ver ms

Tcnicas Y Operacin Segura De Gra Horquilla
Ver ms

Buenas prcticas en documentacin y trazabilidad de documentos
Ver ms

Formacin de entrenadores tcnicos. Capacitar y calificar personal en forma efectiva en la industria farmacutica
Ver ms






  • Logo Servicios De Capacitacin Herullot Limitada
  • Logo Instituto De Capacitacin Social Y Empresarial Spa.
  • Logo N&s Otec
  • Logo Fundacion Asiva
  • Logo Capacitas 23
  • Logo Omeg Capacitacin S.p.a.
  • Logo Ibuss Training Center Spa
  • Logo Reprex Capacitaciones
  • Logo Imcap
  • Logo Mas Futuro
  • Logo Centro De Capacitacion Y Desarrollo Minero Industrial Spa
  • Logo Global Trainers Ltda.
  • Logo Mjm Capacitaciones Spa
  • Logo Agrochilecapacita Escuela De Agronegocios
  • Logo Novel Capacitaciones Limitada
  • Logo Absa Capacitacin Spa
  • Logo Pixelate Spa
  • Logo Centro De Capacitacion Y Emprendimiento Laboral  Ceccel
  • Logo Valero Servicios Educacionales Limitada
  • Logo Capacitaciones Karen Fuentes Montecinos E.i.r.l.
  • Logo Cau Cau Capacitaciones Ltda.
  • Logo Avanza Capacitaciones E.i.r.l
  • Logo Aldeast Otec
  • Logo Espacio & Tiempo Ltda.
  • Logo Cd Capacitacion
  • Logo Keep Learning
  • Logo Capacitaciones Empresariales
  • Logo M.a.s. Limitada
  • Logo Entrenados Ltda
  • Logo Innova Capacitacin Ltda
  • Logo Socadeh
  • Logo Sociedad De Capacitacin Ergon Limitada.
  • Logo Main Capital
  • Logo Espaciocrea Capacitaciones
  • Logo Macor Consulting Ltda.
  • Logo Iht Capacitacin Ltda.
  • Logo Cidep Educa
  • Logo Red Sur
  • Logo Metaphora Consultora
  • Logo Capacitacin Globalzen Spa
  • Logo Simetria Otec
  • Logo Capacitaciones Juan Carlos Gregorina Prat  Eirl
  • Logo Ser-cap Spa
  • Logo Sercocap
  • Logo Intelecto Capacitaciones
  • Logo Sgs Academy
  • Logo Red Global
  • Logo Training Class Organismo Tecnico De Capacitacion Spa
  • Logo Eslabn Capacitacin
  • Logo Sercapal Ltda
  • Logo Geming Capacitacin Spa
  • Logo Kpmg Servicios De Capacitacion Ltda
  • Logo Instituto De Capacitacin Cgm
  • Logo Apsa Capacitacion
  • Logo Sociedad De Capacitaciones Innovat Limitada
  • Logo Capacitaciones El Loa Ltda.
  • Logo Professional Capacita
  • Logo Instituto Tecnico De Capacitacin Profesional Ltda.
  • Logo Red De Capacitaciones Integrales
  • Logo Otec Gloria Jury Jamis Eirl
  • Logo Capacitacin Cordillera
  • Logo Patagonia Capacitaciones Spa
  • Logo Jf Capacitaciones Limitada
  • Logo Centro De Capacitacion Integral Solange Andrea Retamal Herrera Eirl
  • Logo Cets-afiich
  • Logo Tempus Capacitaciones
  • Logo Capacitaciones Cresa Ltda
  • Logo Ceducal Ltda
  • Logo Otec Care
  • Logo Iconas Educacin Spa
  • Logo Andes Capacitacin Ltda
  • Logo Alfa
  • Logo Lihuenko Capacitaciones Spa
  • Logo Ms Ambiente Ltda.
  • Logo Otec Sosercap Ltda.
  • Logo Breakine Otec
  • Logo A&g Capacitaciones
  • Logo 3lobos Spa
  • Logo Alternativa
  • Logo Forlab
  • Logo Deluxe Frances Capacitacion
  • Logo Capac Training S.a.
  • Logo Promotora De La Salud Servicios De Capacitacion Spa
  • Logo Novaotec Capacitacion Empresarial Ltda.
  • Logo Fundacin Del Cuerpo De Bomberos De Via Del Mar Para La Capacitacin
  • Logo Aysen Consultores Ltda
  • Logo Hazop Capacitaciones
  • Logo Emprendimiento & Desarrollo Chilo Limitada
  • Logo C Y O Ltda
  • Logo Coala Group Centro De Capacitacion Limitada
  • Logo Chiletic
  • Logo Cahp Spa
  • Logo Kapacitate
  • Logo Lester Fibla Saavedra
  • Logo Ergocap Spa
  • Logo Capacitaciones Kaa
  • Logo Reddes Spa
  • Logo Capacitacion Gastro Tur
  • Logo Redotec
  • Logo Quinta Capacitacin
  • Logo Otec Crea Oportunidades
  • Logo Loa Seguridad E.i.r.l.
  • Logo Otec Capglobal
  • Logo Master Training
  • Logo Sociedad Mas Cap Ltda
  • Logo Creciendo Ms
  • Logo Servicios De Capacitacion Felix Herrera Ruz Eirl
  • Logo Mcm Otec
  • Logo Docentes Al Dia Otec Spa
  • Logo Destressa Capacitacin Spa
  • Logo Otec Capacitamas
  • Logo Capacitaciones Cristian Narria E.i.r.l.
  • Logo Training Chile Servicios De Capacitacion Spa
  • Logo Ccapacita
  • Logo Gesprod Sanchez Spa
  • Logo Martnez Capacitacin Ltda
  • Logo Inversiones Y Asesoras Ps Spa
  • Logo Dimac Capacitacion Y Desarrollo
  • Logo Tecnotraining
  • Logo Sociedad Reiros Capacitaciones Spa
  • Logo Otec Hercap Ltda
  • Logo Iibi
  • Logo Sermicap Ltda.
  • Logo Instituto De Capacitacin Y Desarrollo De Educacin Continua Nacional
  • Logo Deachile Capacitacion Spa
  • Logo Cyc Capacitaciones
  • Logo Socovvar Ltda
  • Logo Sin Fronteras Capacitacin
  • Logo Capacitaciones Monte Verde Spa
  • Logo Capacitaciones Frp
  • Logo Formar Chile Capacitacin Ltda.
  • Logo A&m Capacitacion Ltda
  • Logo Ipalmed
  • Logo Capreser  E.i.r.l
  • Logo Mutual De Seguridad Capacitacion S.a.
  • Logo Ejrc Capacitaciones
  • Logo Galyleo Capacitaciones
  • Logo Capacitaciones Madrid Ltda
  • Logo Enac Conductores
  • Logo  Formacin Ti Spa
  • Logo Otec A&g Capacitaciones
  • Logo Thomson Reuters
  • Logo Otec Madison
  • Logo Instituto Idomek
  • Logo New Horizons
  • Logo Capacitaciones Pro Partner Limitada
  • Logo Boletin Del Trabajo
  • Logo Incapital Capacitacion Spa
  • Logo Qualitymas Capacitacin
  • Logo Hseq Mining
  • Logo Instruccin Ltda.
  • Logo Cetecap Spa
  • Logo Georecal Ltda.
  • Logo Netsolutions
  • Logo Dial Capacita
  • Logo Soc. Invierte Capacitacin Spa
  • Logo Centro De Capacitacion Laboral Capacitar & Crecer Limitada
  • Logo Instituto De Capacitacion  Agcap  Spa
  • Logo Somital
  • Logo It Wall S.a.
  • Logo Inndesa Capacitaciones Ltda
  • Logo Ennovate Business Trends
  • Logo Capconsan Ltda
  • Logo Capacitaciones Experimenta Tu Entorno
  • Logo Punto Superior Ltda
  • Logo Icecap
  • Logo Integra Estratgica Limitada
  • Logo Aprendeser
  • Logo Ultraccion 4x4
  • Logo Contigo Capacitaciones
  • Logo Global Otec
  • Logo Ceincap Ltda.
  • Logo Eprime Formacin Ltda
  • Logo Sur Talent
  • Logo Educacion Mas
  • Logo Agrocap Ltda.
  • Logo Capacitacin Integral Global C.i.g Ltda
  • Logo Centro De Capacitacin Vagafe Ltda.
  • Logo Desarrollo Integral Otec
  • Logo Capacitaciones Carrasco
  • Logo Ceentec
  • Logo Gestcap Chile Ltda.
  • Logo Counselors Chile Limitada
  • Logo Capaseg
  • Logo Mahiros Capacita Ltda.
  • Logo Protecmin Trining Chile Spa
  • Logo Layner Centro De Capacitaciones E.i.r.l.
  • Logo Capacitaciones Valencia Limitada
  • Logo Creadero Capacitacin Ltda
  • Logo Fupac Capacitacion Limitada
  • Logo Otec Oficios Del Sur Ltda
  • Logo Insigne Capacitacin Spa
  • Logo Instituto Nacional De Certificacion
  • Logo Sociedad Educacional Planacap Limitada
  • Logo Generaccion Ltda.
  • Logo C.h.i. Capacitaciones
  • Logo Karukinka Capacitaciones Ltda
  • Logo Implementa Capacitacion
  • Logo J&g Capacitaciones  Ltda
  • Logo Icafop Ltda
  • Logo Tempus Capacitaciones
  • Logo North Quality Limitada
  • Logo Aporta Otec
  • Logo Fundacion Rosner
  • Logo Soluciona Capacitaciones Eirl
  • Logo Otec Blackboard Training Ltda
  • Logo Sociedad Nacional De Capacitacion Ltda
  • Logo Gicap Capacitacion
  • Logo Braniff International
  • Logo Empleando Capacitacin Ltda.
  • Logo C.y.e Capacitaciones Ltda
  • Logo Humanuss
  • Logo Grad Consultores
  • Logo Otec Samai E.i.r.l
  • Logo Vacap Ltda
  • Logo Transversal Capacitaciones Ltda.
  • Logo Welearn Cap
  • Logo Otec Ethos Limitada
  • Logo Efis S.a.
Flecha Izquierda Flecha Derecha