AWS RDS for DBAs

Understand cloud computing basics, on-demand resource delivery via Amazon, and the three service models—IaaS, PaaS, SaaS—along with cost savings and scalable, global deployment.

Explore cloud computing essentials: compute, storage, databases, and networking across IaaS, PaaS, and SaaS. Examine Amazon Web Services offerings like Elastic Beanstalk, EC2, and security tools.

Explore software as a service, platform as a service, and infrastructure as a service in the Oracle public cloud. Learn how data management, databases, and industry solutions drive cloud offerings.

Sign up for a free Oracle cloud account, claim $300 in credits, and explore prerequisites, infrastructure options, and security basics for creating a database in the cloud.

Discover prerequisites for creating an Oracle Cloud database: generate and upload a public/private SSH key pair, log in with a temporary password, and choose cloud infrastructure options.

Create and configure an Oracle cloud database using generation 2 infrastructure, selecting edition, region, and instance options, while managing access with admin credentials and public key authentication.

Demonstrates creating an Oracle cloud database, navigating the customized dashboard, and connecting via public IP and private key. Learn patching, snapshots, and basic connectivity for a DB deployment.

Explore Amazon RDS for DBAs to deploy, manage, and scale relational databases in the cloud with automated backups, multi-availability-zone deployment, and VPC security, plus CloudWatch monitoring.

Launch an Oracle RDS instance in AWS, using the bring-your-own-license model, choose Oracle Enterprise Edition, configure instance class, VPC and security settings, backups, and monitoring.

Modify an Oracle RDS instance in AWS by performing snapshots, restores, and parameter changes, and configure security groups and public access for SQL Developer connections.

Explore backing up and restoring Amazon RDS instances with automated backups, on-demand snapshots, and point-in-time restores to ensure consistent recovery.

Explore common DBA system tasks in AWS RDS for DBAs, including disconnecting sessions, managing restricted logons, flushing caches, granting privileges via demos, and understanding RDS privileges limitations.

Explore common DBA tasks in an Amazon RDS instance, including creating and resizing tablespaces, setting the default tablespace, and validating databases and data files, with external tables and migration considerations.

Learners validate database instance files in on-premises RDS, using armon utilities to detect block and logical corruption, read trace and log files, and prepare system state dumps for Oracle support.

Discover how to manage redo logs and archive logs in RDS, including enabling supplemental logging, resizing and switching log files, and performing checkpoints for reliable recovery.

Explore managing database parameters with AWS parameter groups, create and edit groups in the AWS management console, and apply changes that may require a reboot.

Discover how to configure AWS RDS option groups to enable Enterprise Manager Express and attach options like Application Express, security features, locator, multimedia, spatial, and optimizer and diagnostics tools.

Discover security group best practices for RDS, including app and database separation, least-privilege IAM management, and restricting database port access within a VPC shown in a hands-on demo.

Learn how to apply resource-level permissions for AWS RDS by categorizing and tagging resources, enforcing least privilege, and attaching IAM policies to users to control access.

Demonstrates implementing resource-level permissions for RDS by tagging instances, creating IAM users, and applying explicit deny policies to restrict production access.

Showcases enforcing RDS resource-level permissions with a production-tag policy, applying explicitdenies on tagging and instance actions, and validating access in the console.