Create Table and run SQL Queries on Amazon DynamoDb NoSQL Database and AWS RDS Relational Database
What you will learn
You would be able to create and provision various cloud databases on AWS
You could set up and customize Amazon DynamoDB- NoSQL document based database
You could run SQL queries on DynamoDB and perform various operations such as Scan, filter and insert
You would be able to create and manage Amazon RDS Relational Database
You could provision various types of Database engines such as MySQL, Oracle, Amazon Aurora and others
Description
In this course, you will learn about Cloud databases on AWS (Amazon Web Services)- Amazon DynamoDB and Amazon RDS.
Here you will be learning various concepts with hands-on examples in AWS DynamoDB-
-
Creating a table in Dynamodb
-
Add rows and columns using form and Json in Dynamodb
-
Scan and Query with Filter table
-
Running SQL Queries in Dynamodb using PartiQL editor
-
Create Backup and export to S3 bucket
-
Delete Table and restore table from backup
-
Create a DAX Cluster and attach VPC
-
Configure Security and IAM for DAX cluster
Here you will be learning various concepts with hands-on examples in Amazon RDS-
-
Create or Restore RDS database from S3 using IAM
-
Create an RDS database with Aurora and other Engine types
-
Monitor database utilization and Performance indicators
-
Database Actions, query editor and monitoring
What is AWS DynamoDB?
Amazon Dynamodb is a NoSQL and document based database where data fields are stored in JSON documents. However, you may perform various kinds of Operations such as Scan, run SQL queries, add and remove records from table and much more.
What is AWS RDS?
AWS RDS or Amazon Relational Database Service could be used to create and manage relational databases on the Amazon Cloud. You can choose from various database engine types for Amazon Aurora, MySQL, Oracle Database, Microsoft SQL Server, and PostgreSQL.
Content