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

Curso de Capacitación: Certificacion MySQL for Database Administrators

Certificacion MySQL for Database Administrators

Centro de Capacitación

Logo Oferente

Descripción

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 Teóricas: 20 | Horas Prácticas: 20
Modalidad: Presencial
Valor referencial por persona: $ 600000

Otros Comentarios




Cotice este curso

Palabras Claves




Eventos


Interpretación y Análisis de la Norma ISO 9001:2015: Sistema de Gestión de Calidad
Ver más

Visualizacion Geografica QGIS- Nivel Basico
Ver más

Fundamentos y Aportes de la Neurociencia a los Desafíos Organizacionales - Recuperación de lo Humano en los Espacios Laborales
Ver más

Interacciones que promueven el pensamiento
Ver más

Visualizacion Geografica QGIS- Nivel Intermedio
Ver más






Curso experto excel por 60 USD
Curso actualización ISO 9001:2015
publicidad curso excel
Arriendo de salas
cursos con descuento

CURSOS CON DESCUENTO

Ver más cursos con descuento


Cotice este curso


Cotizador Universal

Cotice este curso

Cotizador Universal
  • Logo Instituto De Capacitación Social Y Empresarial Spa.
  • Logo Horizonte Capacitación Y Desarrollo
  • Logo Atecra
  • Logo It Wall S.a.
  • Logo New Horizons
  • Logo  Formación Ti Spa
  • Logo Tecno-gestión Limitada
  • Logo Otec Suma Paqarita
  • Logo Vertice Capacitación Spa
  • Logo Docentes Al Dia Otec Spa
  • Logo Instituto De Capacitacion  Agcap  Spa
  • Logo Instituto De Capacitación De Chile
  • Logo Ennovate Business Trends
  • Logo Centro De Capacitación Los Lagos
  • Logo Universidad Autonoma
  • Logo Organismo Técnico De Capacitación Omega Spa.
  • Logo Deloitte Servicios De Capacitación Limitada
  • Logo A&m Capacitacion Ltda
  • Logo Suma Capacitaciones Spa
  • Logo Centro Cai Usach
  • Logo Tempus Capacitaciones
  • Logo Instituto Conosur
  • Logo Asp Chile
  • Logo Safety & Security Capacitaciones Eirl
  • Logo Valero Servicios Educacionales Limitada
  • Logo Deluxe Frances Capacitacion
  • Logo Sociedad Educacional Planacap Limitada
  • Logo Cyc Capacitaciones
  • Logo Redes De Capacitaciones Integrales Limitada
  • Logo Capacitaciones San Fernando
  • Logo Ksl Chile Capacitaciones
  • Logo Otec Carpe Diem E.i.r.l.
  • Logo Eseka
  • Logo Centro De Capacitaciòn Minera. Cencomin
  • Logo Seminaria Otec Spa
  • Logo Transversal Capacitaciones Ltda.
  • Logo Macor Consulting Ltda.
  • Logo T&s Capacitacion Chile Ltda.-
  • Logo Circular Pro
  • Logo Sociedad De Capacitación Ibarra Y Salazar Spa
  • Logo Capacitación Coaching Live Spa
  • Logo Otec Chelenko Limitada
  • Logo Instituto De Capacitación Virtual Spa
  • Logo Instituto De Capacitacion Profesional Limitada
  • Logo Validar Train
  • Logo Delphinus E.i.r.l
  • Logo Innova Cea Capacitaciones Ltda
  • Logo Capacitaciones Potenza Spa
  • Logo Efr Chile
  • Logo Martínez Capacitación Ltda
  • Logo Servicio De Capacitaciones Sur Ltda
  • Logo Instituto Infodes Ltda.
  • Logo Capacitaciones Campbell Spa
  • Logo Eslabón Capacitación
  • Logo Energytime
  • Logo Dl Gestión De Talentos
  • Logo Ki Capacitacion
  • Logo Valeria Villarroel
  • Logo Tecnotraining
  • Logo Otc Consultores
  • Logo Avanza Capacitaciones Limitada
  • Logo Capacita
  • Logo Instituto Idomek
  • Logo Qualify Chile
  • Logo Centro De Capacitacion Laboral Capacitar & Crecer Limitada
  • Logo Puma Alfa Ltda
  • Logo Fs Team Capacitaciones
  • Logo Ey Servicios De Capacitación Spa
  • Logo Cege Learning S.a,
  • Logo Sociedad De Capacitacion Ceballos & Chijani
  • Logo Impact Learning Group
  • Logo Ivy Capacitación Spa
  • Logo Octopus  Capacitacion
  • Logo Ideas En Movimiento
  • Logo Celade S.a.
  • Logo Capacitación Parque Del Recuerdo Ltda.
  • Logo Ceincap Ltda.
  • Logo Otec Pcm Prod
  • Logo Ergocap Spa
  • Logo Integra Capacitaciones Ltda.
  • Logo Edubiblio
  • Logo Ultraccion
  • Logo Ingerad Capacitaciones Spa.
  • Logo Educatechile Spa.
  • Logo Lester Fibla Saavedra
  • Logo Sociedad De Capacitación Mvc Limitada.
  • Logo Vgroup
  • Logo Capacitación Campo Grupal Chile Sap
  • Logo Sociedad De Capacitacion Desarrollo Nacional Spa
  • Logo Capacitaciones Carrasco
  • Logo Netsolutions
  • Logo Servicios De Capacitacion Felix Herrera Ruz Eirl
  • Logo Cahp Spa
  • Logo English Partners
  • Logo Rbu Capacitaciones Spa
  • Logo Teadmiro Capacitaciones E.i.r.l
  • Logo Enasys
  • Logo Ejrc Capacitaciones
  • Logo Comunikrte Capacita Spa
  • Logo Capacitaciones Training Work
  • Logo Sgs Academy
  • Logo Imperio De Leones
  • Logo Go Cap
  • Logo Dmadison Capacitacion S.a.
  • Logo Red Global
  • Logo Biocap
  • Logo Qualitymas Capacitacion
  • Logo Manuel Leonardo Cáceres Lizana, Actividades De Asesoramiento Empresarial Y En Materia De Gestión, E.i.r.l.
  • Logo Enac Conductores
  • Logo 3ag Capacitacion Ltda
  • Logo Capacitación A Y M Limitada
  • Logo Silyes Capacitaciones
  • Logo Creadero Capacitación Ltda
  • Logo Capacitación Prasoc Ltda.
  • Logo Idesem
  • Logo Keep Learning
  • Logo Dgv Capacitaciones
  • Logo Servicios De Capacitacion Empresarial Spa.
  • Logo Musalem Capacitaciones
  • Logo Instituto Cultural Ecos Limitada
  • Logo Cencomín
  • Logo Icm Chile
  • Logo Global Trainers Ltda.
  • Logo Cecace
  • Logo Otec Concepcion Capacita Figueroa & Godoy Limitada
  • Logo Chiletc
  • Logo Talk English
  • Logo Sin Fronteras Capacitación
  • Logo B Y S Capacitacion Limitada
  • Logo Agrochilecapacita Escuela De Agronegocios
  • Logo Latitud Zero Spa
  • Logo Travesía Organismo Técnico De Capacitación
  • Logo Gestcap Chile Ltda.
  • Logo Innova Capacitación Ltda
  • Logo Instituto De Capacitación Amunátegui Limitada
  • Logo Corporacion Crisol
  • Logo Sociedad De Capacitación Alquimistas Ltda.
  • Logo Educación Y Capacitación Semilla Eirl
  • Logo Vanguardia Capacitación E.i.r.l.
  • Logo Sociedad De Capacitación Se3 Spa
  • Logo Pretorian Capacitaciones
  • Logo Incanort
  • Logo Instituto Nacional De Certificacion
  • Logo Cd Capacitacion
  • Logo Evs
  • Logo Más Ambiente Ltda.
  • Logo Atención Y Capacitación Para El Desarrollo Humano Psicología Y Bienestar Ltda.
  • Logo Welearn Cap
  • Logo Servicio De Capacitación Pamela Maturana Courdurier E. I. R. L.
  • Logo Fesanco Capacitaciones
  • Logo G-nesys
  • Logo 21g Coach Y  Capacitación Spa
  • Logo Socadeh
  • Logo Empleando Capacitación Ltda.
  • Logo Fundación Otec Nodo
  • Logo Proyecto  Educacional Y Capacitación Ltda
  • Logo Thomson Reuters
  • Logo Cm Pro Educa Spa
  • Logo Link Capacitación Y Recursos Humanos
  • Logo Gyc Capacitación Spa
  • Logo Empresa Demo
  • Logo Instituto De Capacitación Edycal
  • Logo Dimac Capacitacion Y Desarrollo
  • Logo Eprime Formación Ltda
  • Logo Atlántida Capacitaciones
  • Logo Centro Nacional De Capacitacion New Talents Spa
  • Logo Otec Regional Ltda.
  • Logo Calificación Activa Otec
  • Logo Capacitaciones Sb
  • Logo Capacitaciones Emza Spa
  • Logo Inacim
  • Logo Cerm Vertisub Chile Capacitacion
  • Logo Perspectivas Capacitacion Eirl
  • Logo Loa Seguridad E.i.r.l.
  • Logo Sociedad De Capacitación Inténtalo Spa
  • Logo Capacitacion Gastro Tur
  • Logo Capac Training S.a.
  • Logo Novaotec Capacitacion Empresarial Ltda.
  • Logo Savia Capacita Spa
  • Logo Somital
  • Logo Capacitaciones Experimenta Tu Entorno
  • Logo Cobrexchile Capacitacion Spa
  • Logo Deachile Capacitacion Spa
  • Logo Victor Silva
  • Logo Areté Capacitaciones
  • Logo Ipocrade
  • Logo Otec Sosercap Ltda.
  • Logo Insigne Capacitación Spa
  • Logo C.y.e Capacitaciones Ltda
  • Logo Geresam Capacitaciones Spa
  • Logo Instituto De Capacitación Cgm
  • Logo Autoescuela De Conductores Arauco Ltda
  • Logo Otec Santa Lucía Spa
  • Logo Mincap
  • Logo Aprendeser
  • Logo Instituto Tecnológico Iq
  • Logo Capin Limitada
  • Logo Sociedad De Capacitación Cbp Limitada
  • Logo Santo Tomás Educación Continua
  • Logo Aysen Consultores Ltda
  • Logo Upgrade Capacitacion Spa
  • Logo Sociedad De Capacitacion Nahuelbuta Spa
  • Logo Centro De Estudios Mas Capital Humano
  • Logo Iconas Educación Spa
  • Logo Captop Capacitacion
  • Logo Kibernum It Academy
  • Logo Gestion Y Soluciones En Capacitaciones Spa
  • Logo Sociedad De Capacitación Y Asesoría García Y García Limitada
  • Logo Organismo Técnico De Capacitación San Marti Limitada
  • Logo Concrevi Centro De Capacitación
  • Logo Humanagement Capacitacion
  • Logo Wecken Capacitaciones
  • Logo Dingen Capacitaciones Spa
  • Logo Centro Yeah Capacitaciones Inteligentes Spa
  • Logo Sociedad Nacional De Capacitacion Ltda
  • Logo Fundacion Asiva
  • Logo Altazor Capacitaciones
  • Logo Otec Ethos Limitada
  • Logo Perfectus Capacitaciones
  • Logo Instituto De Capacitación Advance S.p.a.
  • Logo Ccpe Limitada
  • Logo Qualia Capacitaciones
  • Logo Training Class Organismo Tecnico De Capacitacion Spa
  • Logo Ser-cap Spa
  • Logo Cetecap Spa
  • Logo Otec Forincom Spa
  • Logo Smart Capacitaciones Limitada
  • Logo Instituto Minero De Capacitacion Limitada
  • Logo Espacio Otec
  • Logo Lsqa Academy
  • Logo Andinacap Ltda.
  • Logo Crea
  • Logo Global Capacitaciones Ltda
  • Logo Synapsis Capacitaciones
  • Logo Innovocap
  • Logo Otec Hercap Ltda
Flecha Izquierda Flecha Derecha