Aws Oracle Rds Database Administration

Oracle RDS Database Administration

What you'll learn

How successfully manage Oracle RDS in the cloud

How to integrate Oracle RDS with Amazon Simple Storage

How to performs snapshots.

Strategies to migrate from on-premises to Oracle RDS

How to manage user roles and privileges

Requirements

No experienced required

Knowlege of oracle will be helpful

Description

Oracle RDS (Relational Database Service) is a fully managed service that makes it easy to set up, operate, and scale a relational database in the cloud. This course will cover the key features and functionality of Oracle RDS, including how to create and manage databases, perform backups and disaster recovery and how to migrate your database to the could. Students will also learn how to use the service with other AWS services, such as how to integrate Oracle RDS with Amazon Simple Storage for imports and exports. By the end of the course, students will be able to confidently use Oracle RDS to manage and scale their own relational databases in the cloud.Below are some for what you will learn in this course:Setting up and configuring an Oracle RDS instanceManaging and maintaining databases within Oracle RDSPerforming backups and disaster recoveryIntegrating Oracle RDS AWS S#Connecting to Oracle RDS instance using SQL developerBest practices for Oracle Data PumpScaling up and down the compute and storage of an Oracle RDS instanceImporting and exporting data to and from Oracle RDSManaging and monitoring the health of Oracle RDS instancesConfiguring and managing automated backupsImplementing and managing database securityHow to create and manage tablespacesHow to export Oracle RDS Schema to AWS S3 bucket

Overview

Section 1: Getting Started With RDS

Lecture 1 What is RDS

Lecture 2 DB instance classes

Lecture 3 RDS DB instance storage classes

Lecture 4 Regions, Availability Zones, and Local Zones

Lecture 5 Configuring AWS Command Line Interface (AWS CLI)

Lecture 6 Amazon Simple Storage Configuration

Section 2: Configuring and Instance

Lecture 7 Setting up Amazon Oracle RDS

Lecture 8 Working with option groups

Lecture 9 Working with parameter groups

Section 3: Managing Oracle RDS instance

Lecture 10 Stop and Start an Instance

Lecture 11 Modifying an Oracle RDS DB instance

Lecture 12 Deleting an Oracle DB Instance

Section 4: Managing Users and Permissions

Lecture 13 Creating Users

Lecture 14 Understanding Oracle Roles

Lecture 15 Granting and Revoking Roles

Lecture 16 Oracle System and Object Privileges

Lecture 17 Granting and Revoking Privileges

Lecture 18 Managing User Profiles

Lecture 19 Terminating & Disconnecting Sessions

Section 5: Managing Tablespaces

Lecture 20 Understanding Tablespaces

Lecture 21 Oracle Default Tablespaces

Lecture 22 Creating and sizing tablespaces

Lecture 23 Setting the default tablespace

Lecture 24 Dropping tablespace

Lecture 25 Adding datafile to a tablespace

Section 6: Backing up and restoring an Oracle RDS DB instance

Lecture 26 Working with backups

Lecture 27 Configuring Oracle Automated Backups

Lecture 28 Performing Point-in-Time Restores

Lecture 29 Creating a DB Instance Snapshot

Lecture 30 Restoring from a DB snapshot

Section 7: Importing data into Oracle on Amazon RDS

Lecture 31 Introduction

Lecture 32 Amazon S3 Integration

Lecture 33 Migrating Databases using Oracle Data Pump

Lecture 34 Importing using Oracle SQL Developer

Database Administrators,Oracle DBAs