Trainer

22 yrs exp

Duration

35 Days

Recordings

53 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

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 Overview

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

Lives 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 timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 22 Yrs exp and delivered more than 350 batches
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
Key Benefits

Upcoming Batches

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 35 Virtual online sessions
  • Access for 53 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicated online AksWave server access
  • 65 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

17 % OFF 24,000/- $242 20,000/-

SELF-PACED LEARNING

This Course Includes:
  • Access for 53 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicate online AksWave server access
  • 65 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

16,000/-

Our Instructor

Demo Video

No Video Found

No Demo Video

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

Testimonials

Manoj Kumar

2 years ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna

2 years ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain

3 years ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8