O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3

Video Description

Implement RDS PostgreSQL CRUD and DynamoDB on AWS using Python API - Boto3 and psycopg2! Build infrastructure with code!

About This Video

  • Implement any sort of infrastructure on AWS with Python using RDS and DynamoDB!
  • Learn how to code against AWS API using Python and Boto3!

In Detail

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!

This course covers the following topics:

  • We’ll set up your environment on both Mac OS and Windows.
  • Create your own credentials for AWS
  • RDS or Relational Database Service from AWS
  • Launch your own Amazon RDS Instances purely with your Python code
  • Connect to our RDS database instance using Python and psycopg2 library
  • Execute your queries against RDS PostgreSQL
  • CRUD operations against our own-launched RDS PostgreSQL instance on AWS
  • Create your own DynamoDB Tables on AWS with Python!
  • Provide a key schema, attribute definitions and apply throughput to your tables
  • Basic CRUD operations with DynamoDB
  • Explore DynamoDB query operation and use conditions
  • Scan operation which basically scans your whole data and retrieves the results.

People who are passionate and want to learn more about AWS using Python and Boto3 will benefit from this course.

All the code files are placed at https://github.com/PacktPublishing/RDS-PostgreSQL-and-DynamoDB-CRUD-AWS-with-Python-and-Boto3

Table of Contents

  1. Chapter 1 : Introduction
    1. Welcome 00:01:06
    2. What We Will Build in This Course 00:03:38
    3. About This Course 00:02:07
    4. What Do You Need For This Course 00:02:20
  2. Chapter 2 : Preparing the Environment for Development
    1. Section Overview 00:03:43
    2. About Tools and Environment 00:04:30
    3. Create an AWS Account If You Don't Already Have It! 00:09:05
    4. Logging in to AWS Console and a Walkthrough 00:09:13
    5. Let's Create Our AWS Credentials! 00:11:13
  3. Chapter 3 : Windows Environment Setup
    1. Installing Python 3 and Pip 00:02:57
    2. Installing AWS SDK (CLI) 00:04:20
    3. Preparing CLI with AWS Credentials 00:02:57
    4. Installing Boto3 00:01:16
    5. Verifying the Setup 00:02:15
  4. Chapter 4 : MacOS Environment Setup
    1. Installing Python 3 and Pip 00:03:24
    2. Installing AWS SDK (CLI) 00:03:01
    3. Preparing CLI with AWS Credentials 00:02:00
    4. Installing Boto3 00:00:51
    5. Verifying the Setup 00:02:09
  5. Chapter 5 : Relational Database Service (RDS) with Boto3: psycopg2
    1. Section Overview 00:00:57
    2. Setting Up Our Project and Preparing and Launching RDS Instance 00:02:00
    3. AWS Console Checkpoint: RDS Instance 00:01:09
    4. Security Group and DB Subnet for RDS 00:12:08
    5. Verifying Connection with Postico 00:01:56
    6. Building Configuration File For RDS Instance Credentials 00:02:39
    7. Connecting to RDS Instance with psycopg2 00:15:57
    8. Creating Table 00:07:54
    9. Inserting Data 00:06:27
    10. Reading Data 00:04:24
    11. Updating Data 00:06:01
    12. Deleting Data 00:05:03
    13. Section Summary 00:02:08
  6. Chapter 6 : DynamoDB with Boto3
    1. Section Overview 00:00:56
    2. Setting Up Our Project with PyCharm IDE 00:05:20
    3. Good News - Downloadable Version of DynamoDB! 00:01:51
    4. Preparing DynamoDB in Local Environment 00:03:46
    5. Creating Table 00:08:53
    6. Writing Data: Putting Items 00:06:50
    7. Writing Data: Updating Items 00:09:07
    8. Preparing DynamoDB in Local Environment 00:09:49
    9. Writing Data: Conditionally Updating Items 00:03:45
    10. Reading Data: Getting Items 00:08:44
    11. Writing Data: Conditionally and Unconditionally Deleting Items 00:06:01
    12. Reading Data: Preparing Our Sample Data 00:03:59
    13. Reading Data: Conditionally Querying Items 00:06:07
    14. Reading Data: Scanning Items 00:04:56
    15. Section Summary 00:03:40
  7. Chapter 7 : Wrapping Up
    1. What Have We Learned? 00:04:13
    2. What Comes Next? 00:01:54
    3. Thank You! 00:01:23