Oracle Autonomous Database Administrator
An autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. Unlike a conventional database, an autonomous database performs all these tasks and more without human intervention.
This course teaches you the fundamentals of Autonomous databases and take your DBA skills knowledge to the next level and learn to deploy and administer Autonomous databases and Explore planning, implementing, and deploying an Oracle Autonomous Database, the first and only autonomous database service in the cloud.
Benefits of an Autonomous Database
There are several benefits of an autonomous database.
- Maximum database uptime, performance, and security―including automatic patches and fixes
- Elimination of manual, error-prone management tasks through automation
- Reduced costs and improved productivity by automating routine tasks
Course Key learnings:
- Learn the technical architecture of Oracle Autonomous Database
- Learn the tasks involved in creating an Autonomous Database on shared and dedicated Exadata infrastructure
- Manage, maintain and monitor an Autonomous Database
- Learn about Oracle Machine Learning, APEX, and SQL Developer Web, which gets deployed with Autonomous Database
- Learn to use Autonomous JSON, Oracle Text, Spatial, and Graph
- Identify Migration Options and Considerations
Course Content:
Module 1: Getting Started with Autonomous Database
- Welcome: Getting Started with Autonomous Database
- Getting Started with Autonomous Database
- Autonomous Database Offerings Type
- Autonomous Database License Type
Module 2: Autonomous Database on Shared Infrastructure
- Welcome: Autonomous Database on Shared Infrastructure
- Start and Stop ADB
- Provisioning
- Scaling
- Auto Scaling
- Move ADB to another compartment
- Create an ADB clone
- Managing Users
- Create alarms and events
- Manage ADB backup and restores
- Autonomous Data Guard
Module 3: Autonomous Database on Dedicated Infrastructure
- Welcome: Autonomous Database on Dedicated Infrastructure
- Dedicated Infrastructure Overview
- Describe Workflows and Functionality
- Provision Dedicated Resources: Exadata, Container Database and VM Cluster
- Monitoring Dedicated Infrastructure
- Creating OCI Policies for Autonomous Dedicated
- Manage Maintenance Scheduling (Patching)
- Managing Encryption Keys
Module 4: Managing and Monitoring Autonomous Database
- Welcome: Managing and Monitoring Autonomous Database
- Monitor Autonomous Database Performance
- Setting Up ACLs and Private End Points
- Setup Service Notifications
- Monitor Auto Scaling
- Monitor Auto Indexing
- Compartment Quotas
- Using Data Safe
- Using REST APIs Manage ADB
- Manage ADB using OCI CLI
- Patching and upgrades
- Connecting to Autonomous Database – Part 1
- Connecting to Autonomous Database – Part 2
- Connect to ADB using SQL Developer
- ADB Connectivity
- Use Marketplace Developer Image to Connect to Autonomous Database
- Configure Disaster Recovery (Autonomous Data Guard)
Module 5: Autonomous Database Tools
- Welcome: Autonomous Database Tools
- Database Actions
- APEX
- Oracle Machine Learning
- Data Analysis
- Data Transforms
- Business Model
- Data Insights and Catalog
Module 6: Migration
- Welcome: Migration
- Migration Options and Considerations
- Migrating to Autonomous Database
Target Audience:
This course is intended for on-premise DBAs, Cloud data management professionals, and consultants.
International Student Fees:$500
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
🎥 Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Free Exam Practice Test
- How to Pass Oracle DataBase 11g: Administration-I
- How to Pass Oracle Database 12c Essentials
- How to Pass Oracle 1z0-908 MySQL 8.0 Database Administration
- How to Pass Oracle Data Integrator 12c Essentials
- Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-II
- Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-III
- Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-IV
- Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-V
- Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-V
- Oracle DataBase 11g: Administration I Oracle 1z0-051 Exam PART 1
- Oracle DataBase 11g: Administration I Oracle 1z0-051 Exam PART 2
- Oracle DataBase 11g: Administration I Oracle 1z0-051 Exam PART 3
Related Courses
Oracle Database Administration – OCP/OCA
Oracle Database 12c: Installation and Administration
Oracle Database 19c Administration (DBA Complete Course)
Oracle Database 11g SQL Fundamentals