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

Work with RDS and DynamoDB: AWS with Python and Boto3 Series

Video Description

Learn how to implement RDS and DynamoDB on AWS using Python API - Boto3! Implement your infrastructure with code!

About This Video

  • Learn to implement RDS and DynamoDB on AWS using Python API - Boto3
  • Learn to launch Relational Database Instances (RDS) on AWS using Python and Boto3

In Detail

In this course, we’ll start by looking at the tools and the environment that is needed to work with AWS resources. We’ll be using Python, 3 and as per the IDE, we recommend you to use PyCharm from Jetbrains. It has a free community edition.

After setting 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, we’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. Nothing will be done manually.

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 take a snapshot or namely backup our complete database instance. Later, I’ll teach you how to restore that snapshot that you have created earlier so that you can recover your database from failures!

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 throughout to your tables.

The codes and caption files for this course are available at: https://github.com/PacktPublishing/Work-with-RDS-and-DynamoDB-AWS-with-Python-and-Boto3-Series

Downloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Table of Contents

  1. Chapter 1 : Introduction
    1. Welcome 00:01:00
    2. About This Course 00:02:14
    3. What We Will Build in This Course 00:03:00
    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
    1. Section Overview 00:01:04
    2. Scenario: AWS Console Perspective of What We'll Build 00:02:16
    3. Setting Up Our Project with PyCharm IDE 00:07:11
    4. Let's Check Out Boto3 API Docs! 00:03:19
    5. [Tip] Auto-Complete Magic with Pyboto on PyCharm IDE! 00:04:28
    6. Creating an RDS PostgreSQL DB Instance - Part 1 00:23:33
    7. Creating an RDS MySQL PostgreSQL DB Instance - Part 2 00:10:43
    8. AWS Console Checkpoint: RDS Instanc 00:01:58
    9. Connecting to PostgreSQL RDS Instance with Postico 00:03:32
    10. Describing RDS Instance 00:04:26
    11. Modifying RDS Instance 00:04:02
    12. Backing Up RDS Instance 00:05:32
    13. Restoring RDS Instance 00:05:05
    14. Deleting RDS Instance 00:03:04
    15. Section Summary 00:02:18
  6. Chapter 6 : DynamoDB with Boto3
    1. Section Overview 00:00:36
    2. Scenario: AWS Console Perspective of What We'll Build 00:01:09
    3. Setting Up Our Project with PyCharm IDE 00:03:57
    4. Let's Check Out Boto3 API Docs! 00:01:35
    5. Creating Table 00:14:12
    6. AWS Console Checkpoint: DynamoDB Table 00:01:02
    7. Describing Table 00:03:41
    8. Updating Table 00:05:06
    9. Deleting Table 00:02:54
    10. Section Summary 00:01:44
  7. Chapter 7 : Wrapping Up
    1. What Have We Learned? 00:02:59
    2. Thank You! 00:01:06