Oracle Analytical Cloud Service (OACS)

Course Overview

Topic

1. Autonomous Data warehouse

• An understanding of ADW is OAC.
• Configuring autonomous data warehouse instance.
• Creation of ADW Database and bucket.
• Creating a connection between SQL developer and ADW Database.
• loading data to Object data storage.

2. Configuring OAC DBaaS instance.
3. Configuring Analytics instance in OAC.
4. Oracle Analytical Cloud

• Loading data via flat files, relation DB using Data sync.
• Walkthrough to Oracle Apex.
• Creation of Data model.
• Deploying the Data model and executing the analysis.
• Creating the analysis using ADW Instance and using the Data Model Created.

5. Data visualization Desktop

• Installing DVD on local Machine.
• Creating connection TO ADW instance with Data visualiza􀆟on desktop.
• Creating data flow and publishing to create the subject area.
• Creation of reports and different visualization using DVDs.
• Publishing reports to the Dashboard using Data visualization.

6. Data Sync Utility

• Installing Data sync Utility.
• Walkthrough to Oracle Data Sync.
• Creating a connection to ADW instance.
• Loading data to ADW instance via Relational Database and flat files.
• seting uploading strategy on data sync.
• running jobs in oracle Bics.
• Monitoring error on Oracle Data sync and scheduling of jobs.

7. Creation of connection to OAC Instance with Autonomous Data warehouse.
8. Creation of DataModel in OAC using tables and views.
9. Creation of Reports and Dashboard in OAC.
10. Discussion on Uploading RPD On OAC.

11.Understanding and walkthrough to the Components on OAC.

12. Understanding the Administration section on OAC.

13.Creation of users and groups on OAC.

14. Assigning permission to Users, groups and Application Role on OAC.

• Skill Development: Certificates often require participants to acquire and demonstrate specific skills and knowledge. This can lead to improved competence and expertise in a particular area.
• Career Advancement: Many certificates are directly related to specific careers or industries. Earning a relevant certificate can enhance your qualifications and make you a more attractive candidate for job opportunities or promotions.
• Professional Recognition: Certain certificates are widely recognized and respected in specific fields. Earning such certificates can enhance your professional credibility and reputation.
• Specialization: Certificates allow individuals to specialize in a particular area or aspect of a field, enabling them to focus on their areas of interest or expertise.