Základní info
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. tudents 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.tudents briefly use some of the available data warehousing tools such as Oracle Warehouse Builder, Analytic Workspace Manager, and Oracle Application Express.earn To:liDefine the terminology and explain basic concepts of data warehousingdentify the technology and some of the tools from Oracle to implement a successful data warehouseescribe methods and tools for extracting, transforming, and loading datadentify some of the tools for accessing and analyzing warehouse dataescribe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehousexplain the implementation and organizational issues surrounding a data warehouse project/ul
