Oracle Database 19c and SQL Server 2019 Data Warehousing

The Oracle 19c and Microsoft SQL Server 2019 Data Warehousing course combines the Oracle Data Warehousing Fundamentals and the SQL Server Data Warehousing Fundamentals courses. The course provides step-by-step instructions on how to perform a variety of Oracle and Microsoft Data Warehousing implementation activities including E-T-L (Extract, Transform and Load) and Self-Service Reporting tasks using Oracle Business Intelligence, Data Integrator and Microsoft SQL Server Integration and Reporting Services.

On successful Completion of this course you will be able to:

• Learn to Plan and Scope your Oracle and SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand Microsoft Analytics and Big Data Platform
• Understand the BI and Warehouse Development Process
• Learn to Manage Oracle and SQL Server Warehouse Projects
• Understand the Data Warehouse Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand Oracle and SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle DI and SQL Server Integration Service system