Oracle RDS Essential Training on Amazon Web Services (AWS)

Name: Oracle RDS Essential Training on Amazon Web Services (AWS)
Rating: 4.2 (32 reviews)

Oracle RDS Database Administration

Created byEmar Morrison

Last updated 12/2024

English

English [Auto],

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 for recovery
Strategies to migrate from on-premises to Oracle RDS
How to manage user roles and privileges
How monitor databases with AWS Cloud Watch

Course content

9 sections • 38 lectures • 1h 56m total length

Introduction1:09
What is RDS1:51
Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It offers a selection of database engines to choose from, including MySQL, Oracle, PostgreSQL, Microsoft SQL Server, and Amazon Aurora.
DB instance classes2:18
Amazon Web Services (AWS) offers a variety of database instance classes for Amazon Relational Database Service (Amazon RDS), which is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. The available DB instance classes are grouped into families, each optimized for different workloads.
RDS DB instance storage classes1:53
Explore Amazon RDS storage options and EBS-backed DB instances for MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server, including GP2/GP3 general purpose, Io1, and magnetic storage up to 64 TB.
Regions, Availability Zones, and Local Zones1:34
In the context of cloud computing, a region is a specific geographic location where cloud services are available. Regions typically consist of multiple availability zones, which are essentially data centers that are isolated from each other within the same region. These availability zones are connected by low-latency networks, and are designed to be highly resilient and fault-tolerant, so that if one availability zone goes down, the others can continue to operate.
Configuring AWS Command Line Interface (AWS CLI)4:40
Install and configure AWS command line interface (CLI) to manage AWS services, using aws configure to set credentials (or CSV import), region, and output format, then verify with aws --version.
Amazon Simple Storage Configuration2:24

Setting up Amazon Oracle RDS5:10
Set up an Oracle RDS instance on AWS, choosing standard edition, configuring credentials, storage, networking, security groups, and public access, then connect via the endpoint and port 1521.
Working with option groups4:24
Learn how to enable and configure features with RDS option groups, manage persistent and permanent options, and assign groups to Oracle RDS instances, including S3 integration and mail options.
Working with parameter groups3:44

Creating Users6:08
learn to create a user in Oracle RDS on AWS using create user or GUI, set password, tablespace, quota, and profile, with examples John and Mary.
Understanding Oracle Roles2:45
Granting and Revoking Roles1:29
Grant and revoke roles in Oracle RDS by assigning connect and create session privileges, testing connections, and editing users via GUI; next, learn about granting individual privileges.
Oracle System and Object Privileges2:37
Granting and Revoking Privileges5:00
Demonstrates granting and revoking object and system privileges in Oracle RDS, using grant and revoke for select on a demo table in the admin schema and for select any table.
Managing User Profiles3:32
Explore creating, editing, and assigning Oracle profiles in SQL Developer, configuring resource and password parameters. Learn to apply changes with alter profile, alter user, and drop profile with cascade.
Terminating & Disconnecting Sessions2:45

Understanding Tablespaces1:18
Oracle Default Tablespaces2:00
Explains the default Oracle tablespaces created at database initialization. Covers the system auxiliary (Sis OCS), system, temp, undo, and user tablespaces and their purposes.
Creating and sizing tablespaces4:52
Setting the default tablespace2:21
Dropping tablespace3:58
Adding datafile to a tablespace2:22
Learn to create a small file tablespace, add data files with alter table space, and verify with the dbs_data_files view and GUI, ensuring up to 32 gb per file.

Working with backups4:27
Learn how automated backups create full-instance storage snapshots during the backup window, support point-in-time recovery within the retention period, and perform incremental subsequent snapshots with optional cross-region copy.
Configuring Oracle Automated Backups3:01
Configure automated backups for an Oracle RDS instance, including retention period, backup window timing, maintenance window conflicts, replication options, and applying changes to the DB instance.
Performing Point-in-Time Restores2:27
Creating a DB Instance Snapshot0:34
Learn to create a manual snapshot of an AWS RDS Oracle database by selecting snapshots, taking a named snapshot, and monitoring until it becomes available.
Restoring from a DB snapshot1:03

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 instance
Managing and maintaining databases within Oracle RDS
Performing backups and disaster recovery
Integrating Oracle RDS AWS S#
Connecting to Oracle RDS instance using SQL developer
Best practices for Oracle Data Pump
Scaling up and down the compute and storage of an Oracle RDS instance
Importing and exporting data to and from Oracle RDS
Managing and monitoring the health of Oracle RDS instances
Configuring and managing automated backups
Implementing and managing database security
How to create and manage tablespaces
How to export Oracle RDS Schema to AWS S3 bucket

Who this course is for:

Database Administrators
Oracle DBAs
Junior Database Administrators
Senior Database Administrators
College graduates

Oracle RDS Essential Training on Amazon Web Services (AWS)

What you'll learn

Explore related topics

Course content

Getting Started With RDS7 lectures • 16min

Configuring an Instance3 lectures • 13min

Managing Oracle RDS instance3 lectures • 6min

Managing Users and Permissions7 lectures • 24min

Managing Tablespaces6 lectures • 17min

Backing up and restoring an Oracle RDS DB instance5 lectures • 12min

Importing data into Amazon Oracle RDS4 lectures • 20min

Monitoring & Performance2 lectures • 7min

Last Words1 lecture • 1min

Requirements

Description

Who this course is for: