The top 8 RD courses you need to take

1. AWS RDS for DBAs

3.8

(137)

Cloud computing is currently the buzzword in IT industry, and many Oracle DBAs are curious to know what cloud computing is and how it works. You will learn about Types of cloud services: IaaS, PaaS, SaaS. How this applies to Amazon Web Services and Oracle Public Cloud. We will also look at Oracle Cloud for Databases, AWS RDS covering how to signup for Oracle cloud account, create your first database in the cloud...

2. Hands-on with AWS RDS

3.8

(81)

This course Hands-on with AWS RDS covers all of the main concepts you need to know about the Amazon Relational Database Service. This course assumes you have no experience on AWS RDS but are eager to learn AWS solution on Relational Database. This course has many hands-on labs such as launching AWS RDS DB Instance, web application with RDS database or Aurora serverless in VPC, Multi-AZ deployments for failover, monitoring performance and encryption on RDS. You will learn AWS RDS essentials, Aurora serverless, RDS operations, and RDS maintenance. You will also get the basic knowledge of other associated AWS services (e. g. S3, IAM, VPC, CloudWatch, and Trusted Advisor)  through hands-on labs. Once you have completed this course, you should be able to deploy your relational database on AWS RDS, operate databases, maintain databases, and set up security on AWS RDS...

3. Working with MySQL DB instance using AWS RDS

In this 1-hour long project-based course, you will learn how to create, connect & delete a MySQL DB instance using AWS RDS. Amazon Relational Database Service (Amazon RDS) makes it easy 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 frees you to focus on your applications so you can give them the fast performance, high availability, security, and compatibility they need. By completing the steps in this guided project, you will successfully launch a MySQL DB instance using AWS RDS within the AWS Free Tier. You will also connect to the instance that you launch using MySQL workbench client and then terminate the instance...

4. Oracle Database on AWS: Exploring EC2 & RDS from scratch

4.6

(797)

I will be looking to delve deeper into the AWS Infrastructure and demystify the entire dilemma around Oracle Database on AWS. We will take a main architecture diagram as base , where we shall create a custom VPC, which will have a Public Subnet & a Private Subnet. The Public Subnet will have access to the internet and we will have a test Oracle 18c XE Database and an Apache Webserver in this. The Oracle 12c RDS Database will be created in Private Subnet and will have access only from Webserver. To achieve this our approach would be as follows: We will start with the very basics like: What is Cloud Computing ,  What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS, Top Cloud Vendors by Market Share. A good understanding will be given about AWS Cloud , Sign-Up Process and Understanding the AWS Management Console. We will be approaching our study from Architecture standpoint by doing a deep dive into the Architecture of AWS and discussing: Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage, A number of demos will be done on the creation of Custom VPC , Secury Groups , EBS Disk , S3 Storage. A demo will be done showing the configuration of AWSCLI on Mac OS / Windows. EC2: We will discuss the details on EC2 / What are AMI: Amazon Machine Images. We will do a demo to create an EC2 Instance in Custom VPC ,  Install 18c XE on EC2 Instance, Backups/Recovery using RMAN Backups to S3 Storage. RDS: What is RDS / RDS for Oracle ,  Backup/ Recovery , Monitoring , Oracle Vs RDS commandsA demo will be done on Deploying Oracle 12c Database in RDS , Patching the existing version of Oracle. A Demo will show the creation of EC2 instance which will act as Apache Webserver , then we shall install Apache, PHP and show the entire process around PHP with OCI8 Connectivity. We will also discuss what is REST API and using a tool Postman call an RDS REST API...

5. Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you migrate MySQL data from an Amazon RDS instance for MySQL to Cloud SQL for MySQL using a one-time Database Migration Service job and an IP allowlist for connectivity. After you create and run the migration job, you confirm that the data have been successfully migrated to your Cloud SQL for MySQL instance...

6. The Complete AWS SQL Server RDS Bootcamp: Beginner To Expert

4.3

(222)

If you are looking to find out vital information with SQL Server RDS  then this is the course for you. You will learnHow to create and delete SQL Server RDS instancesHow to create a SQL Server RDS instance from your computers operating systemHow to administrate an SQL Server RDS instanceHow to backup and restore a SQL Server RDS instance to S3Best practices when using Amazon RDSAfter this course, you will be able to administrate SQL Server RDS environments on AWS...

7. RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3

4.5

(198)

Do you want to learn how to launch managed Relational Databases or RDS on AWS? Do you want to learn how to connect to your RDS DB instances using Python and psycopg2 library and implement all Create, Read, Update and Delete (CRUD) operations? Or do you want to learn how to implement NoSQL DynamoDB Tables on AWS and work with data from scanning, querying to update, read and delete operations?Then this is the course you need on RDS and DynamoDB on AWS! In this course, we'll start by taking a look at the tools and the environment that we need to work with AWS resources. We'll be using Python 3 and as per the IDE I recommend you to use PyCharm from Jetbrains. It has a free community edition even! After I teach you how you can set up your environment on both MacOS and Windows, we'll create our credentials for AWS as being the AWS Access Key and AWS Secret Access Key for programmatic access to AWS resources. You'll learn how you can set your AWS credentials globally on your computers using AWS CLI. Before jumping into the implementation, for one last tip, I'll show you how you can have auto-complete 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 off with RDS or Relational Database Service from AWS. I'll teach you how to launch your own Amazon RDS Instances purely with your Python code! Then we'll learn how to connect to our RDS database instance using Python and psycopg2 library. After that, I'll teach you how to execute your queries against RDS PostgreSQL using psycopg2 library and we'll implement SELECT, INSERT, DELETE, UPDATE so basically all the CRUD opreations against our own-launched RDS PostgreSQL instance on AWS! Next up 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'll learn how to provide a key schema, attribute definitions and apply throughput to your tables. And I'll share the great news for you that there is a Local version of DynamoDB that you can simply run on your computer to play around with! I will show you how you can get and run the Local version of DynamoDB on your computer and we'll setup our environment and boto3 client configuration accordingly. Then we'll start making our way to putting new items, updating, deleting and reading them. Once we learn the basic CRUD operations with DynamoDB, we'll move on to rather advanced operations like scanning and querying. We'll also implement a script to insert our sample data set of "movies" into our DynamoDB Movies table! Once we insert the data, we'll start exploring how we can search it using DynamoDB query operation and we'll also learn how we can use conditions. And finally, we'll take a look at the scan operation which basically scans your whole data and retriveves the results you need. So to filter out the results from scan operation, we'll apply filter expressions to our scan operation and see how things work with DynamoDB. Lots of information, hands-on practice and experience is waiting for you in this course on AWS. So, don't miss any more time and join me in this course to sharpen your skills on AWS using Python and Boto3!...