RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3

Learn AWS RDS and DynamoDB with Python! This comprehensive course guides you through launching and managing relational databases and NoSQL databases on Amazon Web Services (AWS).

What you'll master:

• AWS Environment Setup: Get started with the necessary tools and environment, using Python 3 and PyCharm (Community Edition recommended). We'll cover setup on both MacOS and Windows.
• AWS Credentials: Securely configure your AWS Access Key and AWS Secret Access Key for programmatic access using the AWS CLI.
• PyBoto3 Auto-Complete: Boost your productivity with auto-completion in PyCharm using PyBoto3.
• Amazon RDS (Relational Database Service):
  • Launch Amazon RDS Instances using Python code.
  • Connect to your RDS database using Python and the psycopg2 library.
  • Execute CRUD operations (Create, Read, Update, Delete) on your RDS PostgreSQL database. Learn to perform SELECT, INSERT, DELETE, and UPDATE queries.
• Amazon DynamoDB:
  • Create DynamoDB Tables on AWS with Python.
  • Define key schemas, attribute definitions, and apply throughput.
  • Utilize the DynamoDB Local version for local development and testing.
  • Configure your environment and boto3 client.
  • Implement CRUD operations (Create, Read, Update, Delete) on DynamoDB tables.
  • Advanced operations: scanning and querying data.
  • Insert sample data using Python scripts.
  • Search data using DynamoDB query operations with conditions.
  • Understand and apply filter expressions to optimize scan operations.

This hands-on course provides practical experience with AWS and Python, empowering you to build scalable and efficient applications. Sharpen your skills with Boto3, the AWS SDK for Python! No manual processes – everything is handled with Python code.