Learn Amazon RDS 2024 – Best Amazon RDS Courses & Best Amazon RDS Books

Table of Contents

Best Amazon RDS Courses 2021

AWS RDS for DBAs

Learn More on Udemy.com

Oracle Database on AWS: Exploring EC2 & RDS from scratch

Learn More on Udemy.com

Work with RDS and DynamoDB: AWS with Python and Boto3 Series

Learn More on Udemy.com

Best Amazon RDS Tutorials 2021

AWS RDS for DBAs

Learn More on Udemy.com

Cloud computing is currently the buzzword in the IT industry, and many Oracle database administrators are curious about what cloud computing is and how it works. You will discover the types of cloud services: IaaS, PaaS, SaaS. How this applies to Amazon Web Services and Oracle Public Cloud. We will also take a look at Oracle Cloud for Databases, AWS RDS explaining how to sign up for an Oracle Cloud account, create your first database in the cloud.

You will learn:

Cloud Computing Basics, Oracle Database Cloud Basics, AWS RDS
Benefits of cloud computing
AWS RDS Administration

Oracle Database on AWS: Exploring EC2 & RDS from scratch

Learn More on Udemy.com

Dig deeper into the AWS infrastructure and demystify the whole dilemma around Oracle Database on AWS.

We will take a main architecture diagram as a basis, where we will create a custom VPC, which will have a public subnet and a private subnet. The public subnet will have internet access and we will have an Oracle 18c XE test database and an Apache web server.

The Oracle 12c RDS database will be created in a private subnet and can only be accessed from the web server. To achieve this, our approach would be as follows:

We will start with the basics such as: What is Cloud Computing, What is the meaning of important acronyms like IaaS / PaaS / SaaS, Top Cloud Vendors by Market Share.

A good understanding will be given on AWS Cloud, the registration process and understanding of the AWS Management Console.

We will approach our study from an architectural perspective by diving deep into the architecture of AWS and discussing: Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage,

A number of demos will be done on creating custom VPCs, security groups, EBS disk, S3 storage. A demonstration will be made showing the configuration of AWSCLI on Mac OS / Windows.

EC2: We will discuss the details of EC2 / What are AMI: Amazon Machine Images.

We will do a demo to create an EC2 instance in a custom VPC, install 18c XE on an EC2 instance, backups / recovery using RMAN backups on S3 storage.

RDS: What is RDS / RDS for Oracle Commands, Backup / Recovery, Monitoring, Oracle Vs RDS

A demonstration will be performed on the deployment of the Oracle 12c database in RDS, updating the existing version of Oracle.

A demo will show the creation of the EC2 instance which will act as Apache web server, then we will install Apache, PHP and show the whole process around PHP with OCI8 connectivity.

We will also discuss what the REST API is and how to use a Postman tool to call an RDS REST API.

Work with RDS and DynamoDB: AWS with Python and Boto3 Series

Learn More on Udemy.com

Do you want to know how to launch Managed Relational Databases or RDS on AWS? Do you want to learn how to take snapshots, restore your DB instances, and implement all of them with your Python code without even logging into the AWS Console? Or would you like to learn how to implement DynamoDB NoSQL tables on AWS?

Then this is the course you need on RDS and DynamoDB on AWS!

In this course, we’ll start by looking at the tools and environment we need to work with AWS resources. We will be using Python 3 and according to the IDE I recommend you to use PyCharm from Jetbrains. It even has a free community edition!

After teaching you how to set up your environment on both macOS and Windows, we will create our credentials for AWS as the AWS Access Key and AWS Secret Access Key for programmatic access to AWS resources. . You will learn how you can set your AWS credentials globally on your computers using the AWS CLI. Before we get into the implementation, for a final tip, I’ll show you how you can have autocomplete capabilities on your PyCharm IDE with PyBoto3!

Once we’re ready with our environment setup, we’ll start implementing our solution on AWS! And remember, we’ll do everything with Python code; not a single thing manually or by hand!

We’ll start with RDS or the Relational Database Service from AWS. I’ll teach you how to launch your own Amazon RDS instances just with your Python code! Next, we’ll learn how to take a snapshot or back up our entire DB instance. After that, I’ll teach you how to restore that snapshot you created earlier so that you can recover your database after failures!

The next step is DynamoDB! With this very popular NoSQL service from AWS, I’ll teach you how to create your own DynamoDB tables on AWS with Python! You will learn how to provide key schema, attribute definitions, and apply throughput to your tables.

A lot of information, hands-on practices, and experience await you in this course on AWS. So don’t miss any more time and join me in this course to hone your skills on AWS using Python and Boto3!

You will learn
You will be able to implement any type of infrastructure on AWS with Python using RDS and DynamoDB!
You will learn to code with the AWS API using Python and Boto3!
You will learn how to launch Relational Database Instances (RDS) on AWS using Python and Boto3!
You will learn how to launch DynamoDB NoSQL tables on AWS using Python and Boto3!
You will be confident working with AWS APIs using Python for any type of AWS resource on RDS and DynamoDB!