Best Oracle Cloud DBA Training - 100% Lab Access | AKSWAVE

Course Overview

What will you learn?

  • Tune a database deployment by using DBaaS Monitor utility
  • Use the Oracle Cloud services consoles
  • Create and manage a database deployment
  • Grant privileges and roles to users at all levels, Oracle Cloud Service, compute node and database
  • Manage encryption of data at rest and in transit
  • Manage database deployment security access at the compute node and the database
  • Describe various migration methods
  • Monitor the database deployment by using the DBaaS Monitor utility
  • Perform on-demand backups and recovery of the database deployment
  • Scale the database deployment to get more CPU and RAM resources
  • Audit operations performed on the database deployment
  • Access Enterprise Manager Database Express
  • Add storage for the database deployment
  • Configure network security rules

Who should go for this training?
The following professionals can go for this course:

Suggested Prerequisite

Oracle Database 12c R2: Managing Multitenant Architecture Ed 2

Required Prerequisite

  • Oracle Database 12c R2: Administration Workshop Ed 3
  • Experience in Oracle Database 11g and / or 12c Administration

Who can attend

  • Administrator
  • Cloud Administrator
  • Database Administrator
  • End User


What are the pre-requisites for this Course?

Oracle DBA

Course Content


  • Course goals
  • Course schedule
  • The history of Linux
  • Linux distributions
  • Oracle Linux
  • UEK
  • What is virtualization 
  • Virtualization concepts
  • Benefits of virtualization
  • What is IaaS 
  • IaaS concepts
  • IaaS benefits
  • How is IaaS used 
  • Oracle IaaS services
  • Overview of Oracle Compute Cloud Service
  • Oracle Compute Cloud Service features
  • How is Oracle Compute Cloud Service used 
  • What is storage 
  • Types of storage - local storage and cloud storage
  • Types of cloud storage - public, personal, hybrid
  • Types of storage - block storage, object storage, ephemeral storage
  • Overview of object storage on the cloud
  • How does object storage work 
  • Benefits of object storage
  • About Oracle Storage Cloud Service
  • Accessing Oracle Storage Cloud Service
  • Installing Cygwin and cURL
  • What is a VM 
  • What can I do with a VM 
  • How do I use Oracle Compute Cloud Service (introduction to the web console)
  • What do I need to do to create a VM 
  • What is an SSH Key 
  • How do I use an SSH Key 
  • How do I generate an SSH key pair 
  • Saving the private key and public key on your local host
  • Workflow for using a block storage volume
  • Creating a block storage volume
  • Adding a block storage volume to your existing VM
  • Identifying the new storage volume
  • About file systems
  • Creating a file system on your storage volume
  • About Mount Points
  • Mounting the storage volume on your VM
  • What is a bootable storage volume 
  • What is a machine image 
  • Creating a bootable block storage volume
  • Creating a VM with a bootable storage volume (using the web console)
  • Logging in to the VM to access the storage volume

  • Networking concepts
  • How do network settings work 
  • About security lists
  • About security rules
  • How does SSH access work 
  • Reserving a public IP address
  • Associating a public IP address with an existing VM
  • Creating a security list
  • What is an orchestration 
  • Why should I use orchestrations
  • Structure of an orchestration
  • What objects can I create using an orchestration 
  • What is JSON 
  • JSON syntax
  • JSON editing and syntax checker tools
  • How do I create an instance using an orchestration – steps
  • What is HTTP
  • How does HTTP work 
  • HTTP headers
  • HTTP methods
  • What is a URL 
  • What is REST 
  • About JSON
  • About accessing Oracle Storage Cloud Service
  • Understanding authentication tokens and time limits
  • Constructing the authentication URL
  • Finding your account information
  • Storing an object using an authentication token
  • Using access control lists
  • About containers
  • Creating containers
  • Setting container metadata
  • List containers
  • Deleting containers
  • About objects
  • Listing objects in a container
  • Cloud Services
  • Oracle Database Cloud Offerings
  • Subscribe to an Oracle Cloud Service
  • Comparing a Database Deployment and a Database Instance
  • Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning
  • Comparison: Database Deployment and an On-Premises Database
  • Using the Wizard to Create a Database Deployment
  • How SSH Key Pairs are Used & Creating an SSH Key Pair
  • Storage Used for Database Files & File System Layout
  • Using the Oracle Cloud My Services Dashboard
  • Viewing the Service Details & Using the Database Cloud Service Console
  • Configuring Connections to the Compute Node
  • Oracle Cloud User Roles and Privileges & Administering Users, Roles, and Privileges
  • Managing Compute Node Users
  • Managing Database Users and Privileges
  • Scaling a Database Deployment
  • Patching & Upgrading a Database Deployment
  • Backing Up and Recovering Database Deployments
  • Using Utilities to Back Up and Recover the Database Deployment
  • Choosing a Backup Destination & Default Backup Configuration
  • Creating an On-Demand Backup
  • Changing the Backup Destination
  • Customizing the Backup Configuration
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility

          Use Case: Create a Database Deployment by Using a Production Database Backup 

  • Cloud Security Guidelines
  • Enforcing Security in a Database Deployment
  • Physical and Operating System Security of the Compute Node
  • User Authentication: Services and Compute Node Access
  • User Authentication: Database Access
  • Describing Network Access to the Compute Node and Database
  • Creating Security Lists & Configuring Connections to the Compute Node
  • Implementing Fine-Grained Control of Network Traffic
  • Controlling Network Traffic & Network Security
  • Defining Security Rules
  • Accessing the Database Using Various Tools
  • Managing the Database
  • Monitoring the Database
  • Managing and Monitoring the Listener
  • Monitoring the Operating System
  • Secure Access to Configuration Files on the Compute Node
  • Backing Up Operating System and Database Configuration Files
  • Restricting Access to the Database
  • Protecting Data in the Database Deployment
  • Tablespace Encryption by Default
  • Transparent Data Encryption (TDE): Overview
  • Auditing: Compute Node Connections and Actions
  • Auditing: Database

         Use Case: Configure Network Isolation

  • Choosing a Migration Method: Considerations
  • Choosing a Migration Method: Information Gathering
  • Choosing a Method: Oracle Data Pump Considerations
  • Choosing a Method: Unplug/Plug and Remote Cloning Considerations
  • Choosing a Method: RMAN, SQL*Loader, and GoldenGate Considerations
  • Applicable Migration Methods
  • Overview of Using SQL Developer
  • Using SQL Developer and INSERT Statements to Migrate Selected Objects
  • Using SQL Developer and SQL*Loader to Migrate Selected Objects

         Use Case: Automated Patching of Database Cloud Service

  • Performance Management in the Database Cloud Environment
  • Performance Monitoring and Tuning
  • Tuning Methodology
  • Effective Tuning Goals
  • General Tuning Session
  • What Can be Tuned in a DBCS Environment
  • Tools for Performance Management
  • DBaaS Monitor: Database Information & Operating System Information
  • Identifying Performance Issues by Using the DBaaS Monitor
  • Using the Enterprise Manager Database Express Performance Hub
  • Identifying Performance Issues by Using Enterprise Manager Database Express
  • Identifying Performance Issues by Using SQL Developer
  • Using ADDM to Diagnose Performance Issues
  • Using the SQL Tuning Advisor
  • Database Deployment Scaling: Overview
  • Database Resource Manager
  • Using Resource Manager to Control PDB Resource Usage
  • Controlling Resource Usage by Consumer Groups
  • Determining When to Scale Up the Database Deployment
  • Scaling Up CPU and Memory
  • What is Oracle REST Data Services (ORDS) 
  • Key Principles of Representational State Transfer (REST)
  • What Does ORDS Do 
  • ORDS and Database Cloud Service
  • Using REST APIs in Oracle Cloud
  • Using REST APIs with Database Cloud Service
  • Using cURL and REST APIs
  • Reference: REST API HTTP Status Codes
  • What Happens When You Delete a Database Deployment 
  • How Can You Delete a Database Deployment 
  • Use Case: Creating a Cloned Database Deployment from a Snapshot

Modes of Training

Classroom Training

Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timing.

Program Benefits

MULTIPLE BENEFITS C
CLASSROOM
O
ONLINE
R
RECORDINGS

Live Sessions by expert trainer

45 hrs session recorded videos

Study and Practice course material

Lab practice environment (dedicated machine)

Help for preparing lab setup in students laptop
Guidance for oracle certification exams
100% learning satisfaction guaranteed

Upcoming Batches

Classroom Sessions

01-Oct 
9:00am - 10:30am
Mon - Sat
06-Oct 
9:00am - 10:30am
Mon - Sat
10-Oct 
9:00am - 10:30am
Mon - Sat

Duration: 30 sessions

12,000/-
14,000/- save 14%

Online Sessions

01-Oct 
6:30am - 8:00am
Mon - Fri
06-Oct 
6:30am - 8:00am
Mon - Fri
10-Oct 
6:30am - 8:00am
Mon - Fri

Duration: 30 sessions

20,000/- $265
24,000/- save 17%

Recorded Sessions

Recorded Videos : 45 hrs video
Material : Study and Lab Material
Lifetime
16,000/-
18,000/- save 11%

Our Trainers

Demo Video

No Records Found

Interview Questions

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Certification Guidence

No Records Found

Faq

Our trainer is an OCP & OCM certified consultant and has significant amount of experience in working with the technology, having 18+yrs of experience.

Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that 

particular session.

For practical execution, our trainer/technical team will provide server access details to the student.


Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.


Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to [email protected] with your queries.


The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant & special discount for 2 or more participants.


* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If request made after 2 days, then Refund is made after deduction of administration fee.

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Related Courses

No Related Courses Founded

Testimonials

Recently I took Oracle Golden gate and Exadata-X6 classroom training from AKSWAVE ORACLE TRAINIGS by Mr.Akal Singh good teaching and good Lab Environment.One of the Best Institute in Hyderabad.

-Venkatesh

Oracle DBA

This institute is a very good platform to build your career. Mr Akal Singh is one of the best teacher for Oracle DBA. in this institute lab facilities is very good.it is the best institute for 12c DBA and RAC.

-Sandeep Singh

DBA

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8

Course Enquiry

The Secret of getting ahead is getting started.

Classroom Sessions Online Sessions Recorded Sessions