Aws Oracle Rds Database Administration

Published 1/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.43 GB | Duration: 1h 57m
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

Homepage

https://www.udemy.com/course/aws-oracle-rds-database-administration/