Oracle Database 10g: Implement and Administer a Data Warehouse

Tipo de curso	Curso
Método	Presencial / Madrid ver instalaciones...
Duración	32 Horas
Precio/Facilidades	1480 €
Centro	Oracle University
Prerrequisitos	Knowledge of Database Administration. Oracle Database 10g: Administration Workshop I. Oracle Database 10g: Administration Workshop II
Para qué te prepara	This course is intended for database administrators, system administrators, and database application developers who design, maintain, and use data warehouses. Before attending this course, you should be familiar with relational database concepts, basic data warehouse theory
Dirigido a	Data Warehouse Administrator. Database Administrators. Database Designers

Temario	Información adicional y temario

Oracle University

Cursos de la misma temática (Atención al cliente garantizada | Titulación oficial | Prácticas)

Certificación Oca 10g. Oracle Partnernetwork

Curso - MADRID - Gratuito (Subvención)

Atención garantizada

Master Certificado Experto® Oracle 10g con Proyecto y Prácticas **sábados**

Curso - Madrid (Beca)

Atención garantizada

Prácticas

Experto en Oracle 10g

Master - Madrid (Regalo)

Atención garantizada

Oracle Database 10g: Administration I (Oca)

Curso - madrid (Descuento)

Atención garantizada

Master de Administración Oracle V. 10g

Curso - Madrid (Regalo)

Atención garantizada

Prácticas

+ Cursos de Oracle en Madrid

+ Cursos de Oracle

Contactar sin compromiso con el centro Oracle University

A través de emagister.com puedes ponerte en contacto con este centro de formación.

Debes de rellenar correctamente todos los datos de este formulario para que podamos enviarlo al centro de formación. Hemos marcado en rojo aquellos datos incompletos y/o erroneos.

* Datos obligatorios

*Nombre: *Apellidos:

*e-mail: *Teléfono:

*¿En qué País resides?: *Provincia:

*Comentarios:

¿Deseas recibir información gratuita sobre cursos similares a este en tu email? Sí, quiero darme de alta en Emagister.com

Al presionar "Enviar solicitud/ Ver Teléfono" estás aceptando las reglas de uso, y política de protección de datos, del mismo modo, autorizas expresamente que el centro de formación que imparte el curso que has solicitado nos remita la confirmación o no de tu matriculación al curso mismo.

Instalaciones del centro: Oracle University

Calle José Echegaray, 6 Parque Empresarial Las Rozas Madrid 28230 Madrid (España)

Avda. Diagonal, 615, 9º A Barcelona 08028 Barcelona (España)

Isaac Newton, S/N 2ª planta. Pabellón de Italia. Isla de la cartuja Sevilla 41092 Sevilla (España)

José María Escuza, 1-3. Piso 1º Bilbao 4801 Guipúzcoa (España)

Avda. Cortes Valencianas, 39. Edificio Géminis, Pl. 4, B1 Valencia 46015 Valencia (España)

Camelia 17 (Urb. las Torres) Las Palmas de Gran Canaria 35010 Las Palmas (España)

Consultar con el centro Zaragoza 00000 Zaragoza (España)

	Temario del curso
Understand and describe the features inherent in an Oracle 10g Data Warehouse. Demonstrate how to implement parallel operations. Demonstrate extraction, transformation, and loading processes. Describe and demonstrate effective usage of Materialized Views in a data warehouse. Describe star, snowflake and 3NF schemas. Implement an effective partitioning schema for your data warehouse tables. Develop an effective backup and recovery strategy. Describe security challenges in a data warehouse Data Warehouse Design Logical Versus Physical Design in Data Warehouses Data Warehousing Schemas Data Warehousing Objects Physical Design in Data Warehouses Hardware and I/O Considerations Data Warehousing Schemas Star Schema Model Snowflake Schema Model Tuning Star Queries Star Transformation Hints Star Transformation Hints Static Partition Pruning And Star Query Dynamic Partition Pruning And Star Query Dynamic Partition Pruning Determination Partitioning Basics Supported partition types Rolling window operations Partition pruning Partitioning Using a Template Extraction, Transportation, and Loading (Extraction and Transportation) ETL Tools Extraction Methods Logical Extraction Methods Physical Extraction Methods Change Data Capture Transportation Using Transportable Tablespaces Loading Mechanisms ETL-Loading Load a formatted flat file into an existing table with SQLLoader Performing basic transformations while loading with SQLLoader External tables using oracle_loader driver External tables using oracle_datapump driver Loading data with OCI and Direct-path APIs ETL-Transformation Transformation Using SQL Transformation Using PL/SQL Transformation Using Table Functions Error Logging and Handling Mechanisms Parallelism Concepts Parallel Operations Degree Of Parallelism Parallel Execution Plan Operations That Can Be Parallelized The PARALLEL Clause Parallel Query Parallel DDL Performance Benefits of Parallel DML Parallel Operations in Data Warehouses Automated Parallel Query Tuning Data Distribution And V$PQ_TQSTAT Object Statistics And V$PQ_TQSTAT Materialized Views Materialized Views Overview Types Of Materialized Views Nested Materialized Views Partitioned Materialized Views Refresh Methods and Modes Altering/Dropping Materialized Views Dimensions and Hierarchies Dimensions and the Data Dictionary Dimensions Creating dimensions Validate dimensions data View dimension definition information Distinguish between dimensions and constraints Materialized Views Refresh Refresh Methods and Modes Identifying Dependent MVs Conditions For Complete/Fast Refreshes Materialized View Logs Parallel Refreshes Query Rewrite What Can Be Rewritten? Enabling Query Rewrite Join Compatibility Checks Common Joins PCT and Query Rewrite Query Rewrite using Multiple MVs Index Materialized Views SQL Access Advisor DBMS_OLAP Advisory Procedures Workload Management and Sources Recommendations Workload Filters and Attribute Types Tuning of Manually Created Materialized Views Fast-Refreshable Materialized Views RECOMMEND_MVIEW_STRATEGY procedure Data Warehousing System Management Statistics Collection Resumable Sessions Backup and Recovery Table Compression Security