Master SQL and NoSQL Database: AWS DynamoDB and Amazon RDS

Learn to create a DynamoDB table in the AWS console, including naming the table, choosing a partition key, and configuring read and write capacity with on-demand or provisioned options.

Learn to add an item to a DynamoDB table using form or JSON, defining attributes like serial number, product, category, and quantity, with primary key handling and data import options.

Learn to perform scan and query operations on DynamoDB tables using filter criteria, with operators like greater than, between, begins with, and exists, while considering partition key and cost.

Learn to run and write SQL-like queries in DynamoDB using the PartiQL editor, including select, insert, update, and delete with where clauses and JSON outputs.

Learn to create on-demand backups in DynamoDB, protect data with disaster recovery, and export tables to an S3 bucket with configurable formats, encryption, and region options.

Delete a table in DynamoDB and back up before deletion. Restore from backup by choosing entire table or without secondary indexes, in a chosen region.

Learn to create a DynamoDB DAX cluster, configure its size and type, attach a VPC and subnet group, and understand how in-memory caching enables on-demand scalable reads and writes.

Configure security perimeters and IAM for a dax cluster by creating IAM roles and policies for DynamoDB access, defining read/write permissions, and setting maintenance windows and sns notifications.

Learn how to create or restore an AWS RDS database from S3 using IAM, configure the engine (MySQL or Aurora), and set up authentication, VPC, and security groups.

Create an RDS database with Aurora and other engines by configuring engine types, provisioned or serverless capacity, compatibility (Postgres or MySQL), templates, master credentials, networking, and security settings.

Learn to monitor database utilization and performance indicators in Amazon RDS, including CPU, connections, memory, and read/write operations, using the monitoring tab and performance insights, and export snapshots to S3.

Manage Amazon RDS databases with start, stop, activity streams, region changes, and clones, then use the query editor to run and save sql queries while monitoring metrics.

Explore Amazon managed blockchain to create private Hyperledger Fabric networks or join public networks, invite members, configure voting policies and certificate authority, and deploy applications.