Course Overview
Topic
- 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.
- Configuring OAC DBaaS instance.
- Configuring Analytics instance in OAC.
- 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.
- 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.
- 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.
- Creation of connection to OAC Instance with Autonomous Data warehouse.
- Creation of DataModel in OAC using tables and views.
- Creation of Reports and Dashboard in OAC.
- Discussion on Uploading RPD On OAC.
11.Understanding and walkthrough to the Components on OAC.
- Understanding the Administration section on OAC.
13.Creation of users and groups on OAC.
- Assigning permission to Users, groups and Application Role on OAC.
Mode of Training
LIVE ONLINE TRAINING
Benefits of Certificate
- 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.