ADMINISTRACIÓN DE BASES DE DATOS Y DATA GOVERNANCE

TEMARIO

MÓDULO 1:
INSTRODUCCIÓN A DB2 Y SQL

DB2 Family Fundamentals
-Understanding a Table
-Data Modeling and Database Design
-How does a User 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 Functions and Grouping
-UNION and UNION ALL
-Using Subqueries
-Maintaining data

DB2 SQL Workshop for Experienced User
-Introduction
-Creat 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 2:
DB2 LUW, ADMINISTRACIÓN Y RENDIMIENTO

DB2 10.5 Administration Workshop for Linux
-Overview od DB2 10 on Linux, UNIX and Windows
-DB2 Command Line Processor (CLP) and GUI tools
-The DB2 database manager instance
-Creating Database 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 Monitorinf - 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 3:
INFOSPHERE INFORMATION SERVER

MÓDULO 4:
INFOSPHERE DATASTAGE

MÓDULO COMPLEMENTARIO:
Formación en competencias personales para el empleo