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

Name: Work with RDS and DynamoDB: AWS with Python and Boto3 Series
Rating: 4.1 (110 reviews)

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

Created byNiyazi Erdogan

Last updated 9/2018

English

What you'll learn

You'll be able to implement any sort of infrastructure on AWS with Python using RDS and DynamoDB!
You'll learn how to code against AWS API using Python and Boto3!
You'll learn how to launch Relational Database Instances (RDS) on AWS using Python and Boto3!
You'll learn how to launch NoSQL DynamoDB Tables on AWS using Python and Boto3!
You'll be confident to work with AWS APIs using Python for any kind of AWS Resource on RDS and DynamoDB!

Course content

7 sections • 47 lectures • 3h 15m total length

Welcome1:00
Explore aws RDS and DynamoDB with Python and boto3, learning how to manipulate relational and NoSQL databases hands-on, and discover the practical benefits.
About This Course2:14
Learn hands-on aws rds and dynamodb with python and boto3, building and automating database setup and security. Explore backup snapshots and global secondary indexes as you develop the aws solution.
What We Will Build in This Course3:00
This course guides you through configuring AWS credentials and the AWS CLI, provisioning RDS PostgreSQL with subnet and security groups, creating DynamoDB tables with key schema and throughput, and backups.
What Do You Need For This Course2:19
Understand the prerequisites for this course, including an AWS account, basic Python knowledge, and familiarity with DynamoDB and RDS. Prepare your development environment with a Python IDE and related tools.

Section Overview3:43
Install Python, boto3, and your IDE, and configure AWS access keys, secret keys, and region on your machine. Create an AWS account, access the console, and generate credentials for boto3.
About Tools and Environment4:29
Explore the tools and environment for AWS development with Python and boto3, configure credentials with access key, secret key, and region, and set up on Mac OS, Windows, or Linux.
Create an AWS Account If You Don't Already Have It!9:04
Create an AWS account, complete the sign-up flow, and explore the 12-month free tier for services like S3, DynamoDB, and Lambda, including credit card and phone verification steps.
Logging in to AWS Console and A Walkthrough9:13
Sign in to the AWS console, switch regions, and navigate account details while exploring recent services, pinning favorites, using the cost explorer, and reviewing organization, budgets, and billing options.
Let's Create Our AWS Credentials!11:13

Installing Python 3 and Pip2:57
Install Python 3 on Windows, download from python.org, include pip and documentation, add Python to path, and verify installation via the command prompt.
Installing AWS SDK (CLI)4:20
Install the AWS CLI on Windows 10 64-bit, download from Amazon, run the installer, set PATH, and verify the CLI at the command prompt.
Preparing CLI with AWS Credentials2:56
Configure the AWS CLI with your access key, secret key, and region to enable Python and boto3 to access AWS resources without embedding credentials in code, using json output.
Installing Boto31:16
Install boto3 with pip to enable Python to work with AWS resources, with dependencies like core, S3 transfer, and utilities helping you manage RDS and DynamoDB tasks.
Verifying The Setup2:15
Verify credentials with aws configure, confirm access key, secret key, and region; verify python installation and that pip shows boto3 and the AWS SDK for Python installed.

Installing Python 3 and Pip3:24
Installing AWS SDK (CLI)3:01
Install the AWS CLI on macOS using Homebrew for a seamless setup of access keys and secret keys, then verify with aws --version to access AWS resources from any environment.
Preparing CLI with AWS Credentials2:00
Configure the AWS CLI with your access key, secret key, region, and output format using aws configure, then install the boto3 library to enable Python interactions with AWS services.
Installing Boto30:50
Install boto3 with pip to enable Python projects to access AWS services such as RDS and DynamoDB, using pip3.6 for Python 3.x.
Verifying The Setup2:08
Verify the python installation and the AWS CLI configuration. Confirm boto3 is installed and ready to use with AWS resources like VPC and AC.

Section Overview1:03
Explore relational database service on Amazon Web Services and manage databases by launching PostgreSQL, Amazon Aurora, and MySQL instances, then learn to back up and restore your databases.
Scenario: AWS Console Perspective of What We'll Build2:16
Explore launching RDS instances from the AWS console and via Python with boto3, and learn to take backups, create snapshots, and restore a database from a snapshot.
Setting Up Our Project with PyCharm IDE7:10
Set up a PyCharm project for AWS tasks by selecting an existing Python interpreter, creating a source package, and building a client factory and client locator to manage boto3 clients.
Let's Check Out Boto3 API Docs!3:18
Explore the boto3 API docs to learn how to describe RDS db instances with describe_db_instances, including pagination and optional filters when using Python.
[Tip] Auto-Complete Magic with Pyboto on PyCharm IDE!4:27
Learn to enable auto-complete for RDS and DynamoDB APIs in Python with boto3 in PyCharm, by installing boto3, importing it, and using type hints to access full method lists.
Creating an RDS PostgreSQL DB Instance - Part 123:32
Learn to create a PostgreSQL RDS DB instance with boto3, covering required parameters, security groups, a VPC, and a DB subnet group for secure access.
Creating an RDS MySQL PostgreSQL DB Instance - Part 210:42
Learn to configure and launch a PostgreSQL RDS instance with Python and boto3. Set database name, instance identifier, engine version, storage, and public access, plus security groups and subnet groups.
AWS Console Checkpoint: RDS Instance1:57
Verify the AWS console setup for an RDS instance: review inbound security group rules on port 5432, automated backups, and multi-AZ subnet distribution, then confirm the DB is available.
Connecting to PostgreSQL RDS Instance with Postico3:31
Connect to a PostgreSQL RDS instance with Postico on macOS using the DNS endpoint as host and port. Browse default schemas and run simple queries to verify the connection.
Describing RDS Instance4:26
Learn to describe and inspect RDS instances with boto3, using describe DB instances to fetch details like engine, storage, endpoint, and optional filters for specific instances.
Modifying RDS Instance4:02
Modify an RDS PostgreSQL instance master password via an API call, then verify access by reconnecting with the new password and confirming the old password authentication failure.
Backing Up RDS Instance5:32
Restoring RDS Instance5:05
Deleting RDS Instance3:04
Learn how to delete an rds db instance using boto3 by supplying the instance identifier, and choose between taking a final snapshot or skipping it before deletion.
Section Summary2:17

Section Overview0:36
Scenario: AWS Console Perspective of What We'll Build1:08
Explore the AWS console and DynamoDB dashboard, learn about the NoSQL database, and outline building and managing tables with Python and boto3.
Setting Up Our Project with PyCharm IDE3:56
Let's Check Out Boto3 API Docs!1:26
Explore the boto3 API docs for DynamoDB, focusing on methods to create, delete, and backup tables. Learn how parameters and return types guide your implementation for reliable DynamoDB workflows.
Creating Table14:11
AWS Console Checkpoint: DynamoDB Table1:02
Open the AWS console to review the DynamoDB table, refresh the page, and view its properties, capacity, and potential indexes, confirming successful creation.
Describing Table3:40
Describe an existing table using describe_table with a table name, and review properties such as key schema, attribute definitions, and provisioned throughput.
Updating Table5:05
Deleting Table2:54
discover how to delete a dynamo db table with a name parameter using python, via a delete_table method and dynamo db client, and verify removal in the console.
Section Summary1:44

What Have We Learned?2:58
Learn to set up AWS credentials and a Python environment, use boto3 autocomplete, and build, describe, snapshot and restore RDS, then create and manage DynamoDB resources with Python.
What Comes Next?2:06
Discover what's next in the AWS with Python and Boto3 series, with more courses on RDS and DynamoDB and hands-on steps to create, read, update, and delete data.
Thank You!1:05

Requirements

Beginner level of Python
Any Python Interpreter. Default is fine but I recommend PyCharm
An AWS Account - Free Tier Available!
General Knowledge on AWS Model would be nice
Theoretical Knowledge on RDS and DynamoDB Concepts would be nice but not necessary!

Description

Do you want to learn how to launch managed Relational Databases or RDS on AWS? Do you want to learn how to take snaphots, restore your DB instances and implement all of those with your Python code without even logging into AWS Console? Or Do you want to learn how to implement NoSQL DynamoDB Tables on AWS?

Then this is the course you need on RDS and DynamoDB on AWS!

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

After I teach you how you can set 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, I’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; not a single thing manually or by hand!

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. After that, I’ll teach you how to restore that snapshot you have created earlier so 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 throughput to your tables.

Lots of information, hands-on practice and experience is waiting for you in this course on AWS. So, don't miss any more time and join me in this course to sharpen your skills on AWS using Python and Boto3!

Who this course is for:

Beginners on AWS who wants to put their theory in practice
AWS Cloud Architect Associate Exam Preppers who wants to practice their theories with real projects
Who wants to learn how to implement Infrastructure-as-a-Code or IaaS on AWS
Who wants to learn how to develop infrastructures on AWS using Python
Who wants to learn AWS Python API or namely Boto3

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

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 9min

Preparing The Environment for Development5 lectures • 38min

Windows Environment Setup5 lectures • 14min

MacOS Environment Setup5 lectures • 11min

Relational Database Service (RDS) with Boto315 lectures • 1hr 22min

DynamoDB with Boto310 lectures • 36min

Wrapping Up3 lectures • 6min

Requirements

Description

Who this course is for: