Work with RDS and DynamoDB: AWS with Python and Boto3 Series
Created by Niyazi Erdogan, Last Updated 24-Aug-2020, Language:English
Work with RDS and DynamoDB: AWS with Python and Boto3 Series
Learn how to implement RDS and DynamoDB on AWS using Python API - Boto3! Implement your infrastructure with code!
Created by Niyazi Erdogan, Last Updated 24-Aug-2020, Language:English
What Will I Get ?
- 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!
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!
Course Content
-
Introduction
5 Lectures 00:08:32-
Source Code
-
Introduction
Preview00:00:59 -
About This Course
Preview00:02:14 -
What We Will Build in This Course
00:03:00 -
What Do You Need For This Course
Preview00:02:19
-
-
Preparing The Environment for Development
5 Lectures 00:37:42-
Section Overview
Preview00:03:43 -
About Tools and Environment
00:04:29 -
Create an AWS Account If You Don't Already Have It!
00:09:04 -
Logging in to AWS Console and A Walkthrough
00:09:13 -
Let's Create Our AWS Credentials!
00:11:13
-
-
Windows Environment Setup
5 Lectures 00:13:44-
Installing Python 3 and Pip
00:02:57 -
Installing AWS SDK (CLI)
00:04:20 -
Preparing CLI with AWS Credentials
00:02:56 -
Installing Boto3
00:01:16 -
Verifying The Setup
00:02:15
-
-
MacOS Environment Setup
5 Lectures 00:11:23-
Installing Python 3 and Pip
00:03:24 -
Installing AWS SDK (CLI)
00:03:01 -
Preparing CLI with AWS Credentials
00:02:00 -
Installing Boto3
00:00:50 -
Verifying The Setup
00:02:08
-
-
Relational Database Service (RDS) with Boto3
15 Lectures 01:22:22-
Section Overview
Preview00:01:03 -
Scenario: AWS Console Perspective of What We'll Build
00:02:16 -
Setting Up Our Project with PyCharm IDE
00:07:10 -
Let's Check Out Boto3 API Docs!
00:03:18 -
[Tip] Auto-Complete Magic with Pyboto on PyCharm IDE!
00:04:27 -
Creating an RDS PostgreSQL DB Instance - Part 1
00:23:32 -
Creating an RDS MySQL PostgreSQL DB Instance - Part 2
00:10:42 -
AWS Console Checkpoint: RDS Instance
00:01:57 -
Connecting to PostgreSQL RDS Instance with Postico
00:03:31 -
Describing RDS Instance
00:04:26 -
Modifying RDS Instance
00:04:02 -
Backing Up RDS Instance
00:05:32 -
Restoring RDS Instance
00:05:05 -
Deleting RDS Instance
00:03:04 -
Section Summary
00:02:17
-
-
DynamoDB with Boto3
10 Lectures 00:35:50-
Section Overview
00:00:36 -
Scenario: AWS Console Perspective of What We'll Build
00:01:08 -
Setting Up Our Project with PyCharm IDE
00:03:56 -
Let's Check Out Boto3 API Docs!
00:01:34 -
Creating Table
00:14:11 -
AWS Console Checkpoint: DynamoDB Table
00:01:02 -
Describing Table
00:03:40 -
Updating Table
00:05:05 -
Deleting Table
00:02:54 -
Section Summary
00:01:44
-
-
Wrapping Up
3 Lectures 00:06:09-
What Have We Learned?
00:02:58 -
What Comes Next?
00:02:06 -
Thank You!
00:01:05
-