ADMINISTRACIÓN DE BASES DE DATOS Y DATA GOVERNANCE

Módulo 1 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 2 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