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.
|Schedule for Oracle Database 11g: Data Warehousing Fundamentals|
|Course Contents||Exam#||Exam||Regular Track (days)|
|Oracle Database 11g: Data Warehousing Fundamentals||1Z0-515||Oracle Data Warehousing 11g Certified Implementation Specialist||4|
|Balance Days for day of arrival,exam(s) and practice||2|