Oracle Database 11g: Data Warehousing Fundamentals

Course details

What you will learn:In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse.

• Students learn to improve performance or manageability in a data warehouse using various Oracle Database features. 
  
• Students also learn the basics about Oracle's Database partitioning architecture and identify the benefits of partitioning. 
  
• Students review the benefits of parallel operations to reduce response time for data-intensive operations. 
  
• Students learn about the extract, transform, and load of data phase (ETL) into an Oracle database warehouse. 
  
• Students learn the basics about the benefits of using Oracle's materialized views to improve the data warehouse performance. 
  
• Students also learn at a high level how query rewrite can improve a query's performance. 
  

Students review OLAP and Data Mining and identify some data warehouse implementations considerations. Students briefly use some of the available data warehousing tools such as Oracle Warehouse Builder, Analytic Workspace Manager, and Oracle Application Express. Learn To: 

• Define the terminology and explain basic concepts of data warehousing Identify the technology and some of the tools from Oracle to implement a successful data warehouse 
  
• Describe methods and tools for extracting, transforming, and loading data Identify some of the tools for accessing and analyzing warehouse data Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse 
  
• Explain the implementation and organizational issues surrounding a data warehouse project