Oracle Analytics and Data Warehousing Unlimited Subscription

The Oracle Analytics and Data Warehousing Unlimited Cloud Learning Subscription is a competency based training programme designed to bridge the gap between academia and industry and equips you with the technical skills and knowledge to perform critical Oracle analytics and data warehousing tasks.

With this programme, you’ll gain proficiency with Oracle Analytics and Data Warehousing concepts and technical training on Relational Database Modelling, SQL, ETL, Data Warehousing, Oracle R, Oracle Machine Learning for R (OML4R), Oracle Advanced Analytics, Machine Learning, Big Data, Oracle Cloud and more.

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

• Databases and the Relational Model
• Database Modelling
• Oracle SQL Developer
• Oracle R Enterprise
• 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 analysing 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
• Improve performance or manageability in a data warehouse using various Oracle Database features
• Understand the Oracle Business and Analytics Technology Stack
• Understand the Oracle Analytics Reference Architecture
• Build queries in Oracle BI Answers
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Build Oracle BI Publisher reports based on Answers requests and BI metadata
• Understand and Manage Presentation Layer Security
• Understand Repositories and the Presentation Layer Meta Data
• Understand BI Publisher – BI Presentation Services Integration
• Employ recommended design principles and best practices