RDS PostgreSQL & DynamoDB CRUD with Python and Boto3

RDS PostgreSQL and DynamoDB CRUD_ AWS with Python and Boto3

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

Created by : Rated :4.8 47919 views

Last Updated: 2024-11-20 07:11:36 English Course Type: Self Learning

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 and configure Relational Database
Instances (RDS) on AWS using Python and Boto3!
You'll learn how to connect to RDS PostgreSQL instances on AWS using Python and psycopg2!
You'll learn how to implement Create, Read, Update and Delete (CRUD) operations on RDS PostgreSQL using Python and psycopg2 library!
You'll learn how to create and configure NoSQL DynamoDB Tables on AWS using Python and Boto3
You'll learn how to implement Create, Read, Update and Delete (CRUD) operations on DynamoDB using Python and Boto3!

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!

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 connect to our RDS database instance using Python and psycopg2 library. After that, I’ll teach you how to execute your queries against RDS PostgreSQL using psycopg2 library and we’ll implement SELECT, INSERT, DELETE, UPDATE so basically all the CRUD opreations against our own-launched RDS PostgreSQL instance on AWS!

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.

And I’ll share the great news for you that there is a Local version of DynamoDB that you can simply run on your computer to play around with! I will show you how you can get and run the Local version of DynamoDB on your computer and we’ll setup our environment and boto3 client configuration accordingly.

Then we’ll start making our way to putting new items, updating, deleting and reading them. Once we learn the basic CRUD operations with DynamoDB, we’ll move on to rather advanced operations like scanning and querying.

We’ll also implement a script to insert our sample data set of “movies” into our DynamoDB Movies table! Once we insert the data, we’ll start exploring how we can search it using DynamoDB query operation and we’ll also learn how we can use conditions. And finally, we’ll take a look at the scan operation which basically scans your whole data and retriveves the results you need. So to filter out the results from scan operation, we’ll apply filter expressions to our scan operation and see how things work with DynamoDB.

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!

Beginner level of Python
Any Python interpreter is fine but I recommend PyCharm IDE
AWS Account - Free-Tier available!
General understanding of AWS Model would be nice

Beginners on AWS who wants to put their theory into practice
AWS Certification preppers who wants to practice their knowledge with real projects
Who wants to learn and implement Infrastructure-as-a-Code or IaaS on AWS
Who wants to learn how to develop infrastructure on AWS using Python
Who wants to learn AWS Python API or namely Boto3

Section 1 : Introduction 2 Lectures 00:04:44
Lecture 1 :
Welcome Preview
Lecture 2 :
What We Will Build in This Course
Section 2 : Preparing The Environment for Development 5 Lectures 00:37:47
Lecture 1 :
Section Overview
Lecture 2 :
About Tools and Environment
Lecture 3 :
Create an AWS Account If You Don't Already Have It!
Lecture 4 :
Logging in to AWS Console and A Walkthrough
Lecture 5 :
Let's Create Our AWS Credentials!
Section 3 : Windows Environment Setup 5 Lectures 00:13:49
Lecture 1 :
Installing Python 3 and Pip
Lecture 2 :
Installing AWS SDK (CLI)
Lecture 3 :
Preparing CLI with AWS Credentials
Lecture 4 :
Installing Boto3
Lecture 5 :
Verifying The Setup
Section 4 : MacOS Environment Setup 5 Lectures 00:11:28
Lecture 1 :
Installing Python 3 and Pip
Lecture 2 :
Installing AWS SDK (CLI)
Lecture 3 :
Preparing CLI with AWS Credentials
Lecture 4 :
Installing Boto3
Lecture 5 :
Verifying The Setup
Section 5 : Relational Database Service (RDS) with Boto3: psycopg2 14 Lectures 01:15:11
Lecture 1 :
Section Overview
Lecture 2 :
Setting Up Our Project with PyCharm IDE
Lecture 3 :
Security Group and DB Subnet for RDS
Lecture 4 :
Launching RDS Instance
Lecture 5 :
AWS Console Checkpoint- RDS Instance
Lecture 6 :
Verifying Connection with Postico
Lecture 7 :
Building Configuration File For RDS Instance Credentials
Lecture 8 :
Connecting to RDS Instance with psycopg2
Lecture 9 :
Creating Tables
Lecture 10 :
Inserting Data
Lecture 11 :
Reading Data
Lecture 12 :
Updating Data
Lecture 13 :
Deleting Data
Lecture 14 :
Section Summary
Section 6 : DynamoDB with Boto3 15 Lectures 01:24:58
Lecture 1 :
Section Overview
Lecture 2 :
Setting Up Our Project with PyCharm IDE
Lecture 3 :
Good News - Downloadable Version of DynamoDB!
Lecture 4 :
Preparing DynamoDB in Local Environment
Lecture 5 :
Creating Table
Lecture 6 :
Writing Data: Putting Items
Lecture 7 :
Writing Data- Updating Items
Lecture 8 :
Writing Data- Conditionally Updating Items
Lecture 9 :
Reading Data- Getting Items
Lecture 10 :
Writing Data- Conditionally and Unconditionally Deleting Items
Lecture 11 :
Reading Data- Preparing Our Sample Data
Lecture 12 :
Reading Data- Querying Items
Lecture 13 :
Reading Data- Conditionally Querying Items
Lecture 14 :
Reading Data- Scanning Items
Lecture 15 :
Section Summary
Section 7 : Wrapping Up 2 Lectures 00:06:08
Lecture 1 :
What Have You Learned
Lecture 2 :
What Comes Next

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Niyazi Erdogan,

536797 Course Views

9 Courses

Hi, I'm Niyazi ErdoÄŸan. I'm a software engineer and AWS Certified Solutions Architect with over ten years of experience in various fields. I'm living in one of the most beautiful cities in the world, Istanbul. I'm a self-taught programmer and I've been programming since I was in middle-school. My experience ranges from embedded development to server-side and client-side development technologies.