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

Curso de Capacitacin: Certificacion MySQL for Database Administrators

Certificacion MySQL for Database Administrators

Centro de Capacitacin

Logo Oferente

Descripcin

The MySQL for Database Administrators course is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases

Contenidos

Introduction



MySQL Product

MySQL Services and Support

MySQL Resources

Example Databases

MySQL Server and Client



The client/server model overview

Communication protocols

Connectors and MySQL

The LAMP Stack

Installation of the MySQL server

MySQL Server and Client Startup

Database Basics



Basics of Relational Databases

SQL Language and MySQL

Database Design



Database Modeling

Keys

Normalization

Table Data Types



Data Types

Numeric Data Types

Temporal Data Types

Character String Data Types

The Meaning of Null

Database and Table Creation



Database Structure Creation

Database Creation

Table Creation

Basic Queries



The SELECT Statement

MySQL Workbench for SQL Development

Troubleshooting

Database and Table Maintenance



Deleting an Entire Database

Maintaining Tables

Maintaining Columns

Indexes and Constraints

Table Data Manipulation



Delete/Modify Table Row Data

The INSERT Statement

The REPLACE Statement

The UPDATE Statement

The DELETE Statement

Functions



Simple Functions

Grouping with Functions

Joining Tables



Combining Multiple Tables

Inner Joins

Outer Joins

Table Queries



What is a Subquery

Categories of Subqueries

Subquery Types

Placing Subqueries

Other Subquery Uses

Converting Subqueries to Joins

Exporting and Importing Data



Exporting Data

Importing Data

MySQL GUIs



MySQL Enterprise Monitor

MySQL Workbench

Supplemental Information



Creating Views

Transaction

Storage Engines

Retrieving Metadata

Performance Schema

MySQL Enterprise Backup



Introduction



MySQL Overview, Products, Services

MySQL Services and Support

Supported Operating Services

MySQL Certification Program

Training Curriculum Paths

MySQL Documentation Resources

MySQL Architecture



Describe the client/server model

Understand communication protocols

Understand how the server supports storage engines

Explain the basics of how MySQL uses memory and disk space

System Administration



Choose between types of MySQL distributions

Install the MySQL Server

Describe the MySQL Server installation file structure

Start and stop the MySQL server

Upgrade MySQL

Run multiple MySQL servers on a single host

Server Configuration



Set up MySQL server configuration files

Explain the purpose of dynamic server variables

Review the server status variables available

Configure operational characteristics of the MySQL server

Describe the available log files

Explain binary logging

Clients and Tools



Describe the available clients for administrative tasks

Use MySQL administrative clients

Use the mysql command line clients

Use the mysqladmin for administrative tasks

Describe available MySQL tools

List the available APIs (drivers and connectors)

Data Types



Describe the major categories of data types

Explain the meaning of NULL

Describe column attributes

Explain character set usage with data types

Choose an appropriate data type

Obtaining Metadata



List the various metadata access methods available

Recognize the structure of the INFORMATION_SCHEMA database schema

Use the available commands to view metadata

Describe differences between SHOW statements and INFORMATION_SCHEMA tables

Use the mysqlshow client program

Use INFORMATION_SCHEMA to create shell commands and SQL statements

Transaction and Locking



Use transaction control statement to run multiple SQL statements concurrently

Explain the ACID properties

Describe the transaction isolation levels

Use locking to protect transactions

InnoDB Storage Engine



Describe the InnoDB storage engine

Set the storage engine to InnoDB

Illustrate the InnoDB tablespace storage system

Efficiently configure the tablespace

Use foreign keys to attain referential integrity

Explain InnoDB locking

Other Storage Engines



Explain the general purpose of storage engines in MySQL

List the storage engines available for MySQL

Describe the key features of the MyISAM storage engine

Describe the key features of the MEMORY storage engine

Give an overview of other storage engines: FEDERATED, ARCHIVE, BLACKHOLE, NDBCLUSTER

Choose an appropriate storage engine

Partitioning



Define partitioning and its particular use in MySQL

Determine server partitioning support

List the reasons for using partitioning

Explain the types of partitioning

Create partitioned tables

Describe subpartitioning

Obtain partitioning metadata

Use partitioning to improve performance

User Management



Depict the user connection and query process

List requirements for user authentication

Use SHOW PROCESSLIST to show which threads are running

Create, modify and drop user accounts

List requirements for user authorization

Describe the levels of access privileges for users

List the types of privileges

Grant, modify and revoke user privileges

Security



Recognize common security risks

Describe security risks specific to the MySQL installation

List security problems and counter-measures for network, operating system, filesystem and users

Protect your data

Use SSL for secure MySQL server connections

Explain how SSH enables a secure remote connection to the MySQL server

Find additional information for common security issues

Table Maintenance



Recognize types of table maintenance operations

Execute SQL statements for table maintenance

Client and utility programs for table maintenance

Maintain tables according to specific storage engines

Exporting and Importing Data



Exporting Data using SQL

Importing Data using SQL

Programming Inside MySQL



Creating and executing Stored Routines

Describing stored routine execution security

Creating and executing triggers

Creating, altering and dropping events

Explaining even execution scheduling

Views



Defining views

Reasons to use views

Altering, checking and removing a view

Setting privileges for views

MySQL Backup and Recovery



Describing backup basics

Types of backups

Backup tools and utilities

Making binary and text backups

Role of log and status files in backups

Data Recovery

Introduction to Replication



Describing MySQL Replication

Managing the MySQL Binary Log

Explaining MySQL replication threads and files

Setting up a MySQL Replication Environment

Monitoring MySQL Replication

Troubleshooting MySQL Replication

Introduction to Performance Tuning



Using EXPLAIN to Analyze Queries

General Table Optimizations

Monitoring status variables that affect performance

Setting and Interpreting MySQL server Variables

Otros Datos

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

Otros Comentarios




Cotice este curso

Palabras Claves




Eventos


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

Gestion De Responsabilidad Legal En La Empresa
Ver ms

Curso Operacion Renta 2017
Ver ms

Manejo del Stress y Autocuidado
Ver ms

Seminario Gratuito: tica y reputacin empresarial
Ver ms






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