*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Oracle Autonomous Database Administrator


Be the first to rate Oracle DBA 19c
Or log in to access your purchased courses
by fatima
Price:  120,000
2 Months/20 Hours
0 Lessons

Oracle Autonomous Database Administrator

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



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


Related Courses

Oracle Database Administration – OCP/OCA

Oracle Database 12c: Installation and Administration

Oracle Database SQL 19c

Oracle Database 19c Administration (DBA Complete Course)

Oracle Database Admin – I

Oracle Database 11g SQL Fundamentals

Oracle BI 11g : OBIEE – Build Repository 

Oracle Database Admin – II


KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Print Friendly, PDF & Email

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
Select your currency
PKR Pakistani rupee
WhatsApp Us