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


CURSO DE BASEDET SANTIAGO- JUEVES 9 DE FEBRERO
Ver ms

Anlisis de causa y mejora continua AC Y AP
Ver ms

Creacin De Bases De Datos En Microsoft Access - Oportunidad 2x1
Ver ms

Seminario Gratuito: tica y reputacin empresarial
Ver ms

Manejo del Stress y Autocuidado
Ver ms






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