Administración de bases de datos y data governance

INICIO:

MATRICULA CERRADA. Solicita información sobre nuevas convocatorias, Gracias.

TEMARIO Administración de bases de datos y data governance

Módulo 01:

INTRODUCCIÓN A DB2 Y SQL
DB2 Family Fundamentals
– Understanding a Table
– Data Modeling and Database Design
– How does a User use DB2?
– How does a Programmer use DB2?
– What does an Administrator do in DB2?
– Information Management with DB2

DB2 SQL Workshop
– Introduction
– Simple SQL Queries
– Retrieving Data from Multiple Tables
– Scalar Functions and Arithmetic
– Column Functions and Grouping
– UNION and UNION ALL
– Using Subqueries
– Maintaining data

DB2 SQL Workshop for Experienced Users
– Introduction
– Create Objects
– Join
– CASE, CAST, Summary Tables, and Materialized Query Tables
– Using Subqueries
– Scalar Functions
– Table Expressions and Recursive SQL
– UDTs/UDFs and Performance

Módulo 02:

DB2 LUW, ADMINISTRACIÓN Y RENDIMIENTO
DB2 10.5 Administration Workshop for Linux
– Overview of DB2 10 on Linux, UNIX and Windows
– DB2 Command Line Processor (CLP) and GUI tools
– The DB2 database manager instance
– Creating Databases and Data Placement
– Creating Database Objects
– Moving Data
– Backup and Recovery
– Database Maintenance, Monitoring and Problem Determination
– Locking and concurrency
– Security

DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration
– Advanced Monitoring
– Advanced Table Space Management
– DB2 10.5 BLU Acceleration Concepts
– DB2 10.5 BLU Acceleration Implementation and Use
– DB2 10.5 BLU Acceleration Implementing Shadow Tables and User Maintained MQTs
– Using Optimizer Profiles to control Access Plans
– Table Partitioning
– Advanced Data Movement
– Advanced Table Reorganization 9
– Multiple Dimension Clustering
– DB2 Database Auditing

DB2 for LUW Performance Tuning and Monitoring Workshop
– Database Monitoring – Database I/O Management
– Table space and Table Design for Performance
– DB2 Memory Management
– Automated Memory Management
– Application Performance Considerations
– Using Explain Tools
– The DB2 Optimizer
– Using Indexes for Performance
– Complex SQL Performance
– Tools and Utilities for Performance
– Event Monitor

Módulo 03:

INFOSPHERE INFORMATION SERVER

Módulo 04:

INFOSPHERE DATASTAGE

Módulo complementario:

Formación en competencias personales para el empleo

Cuando tengas tu titulación oficial podrás ocupar puestos como:

• Administración de bases de datos y data governance.

¡Impulsa tu carrera profesional!