RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3 (Udemy.com)

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

( 8 Reviews )

Created by: Niyazi Erdogan

Produced in 2018

What you will 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 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!
You'll be confident to work with AWS APIs using Python for any kind of AWS resource on RDS and DynamoDB!

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Course Description

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!
Who this course is for:

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

Time: 4h

Instructor Details

Niyazi Erdogan

4.3 Rating
8 Reviews

Hi, I'm Niyazi Erdoan. 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.
I started my career while I was only a student as a Java Developer in healthcare industry as a private contractor. Then I moved in to the largest telecommunication company of Turkey which is Turkcell. After several years and various different positions at Turkcell, I moved in to Portugal and worked for another large telecommunication company for several years with Java technologies.
After the telecommunication industry experience and several different experiences, I joined one of the largest companies of its sectors which is Siemens. I currently works at Siemens working with various Java and Cloud technologies
Besides my day job, I really enjoy developing software with lots of different technologies.On the other hand, I do love to follow tech conferences and blogs about latest technologies and tools. I also like to read books within or without my field of expertise and love to watch series like Westworld and Game of Thrones. And I make sure that I stay healthy with daily walking, running and workout.

Learn to Develop for Cloud with Pivotal Cloud Foundry

Learn to Develop for Cloud with Pivotal Cloud Foundry (2018)
4.0 (254 Reviews)

- Provider: Udemy
- Time: 2.5h

$11.99

Learn Spring & Spring Boot 10x Productive Java Development

Learn Spring & Spring Boot 10x Productive Java Development (2019)
4.4 (61 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

All courses by Niyazi Erdogan

Reviews

4.3

8 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Anurag Trivedi

Overall really good course. I was able to set up PostgreSQL DB on AWS without much hassle. Just 1 improvement, videos 21-26 are not in order and 1 video is missing I think.

By Alain Ngono

Great course please keep going!

By Sarah Donehower

I'm just getting started with this course. While it seems it will be useful, there needs to be a note on prerequisites. The lesson material assumes you already know how to programmatically set up an EC2 instance and VPC with boto3 . I would recommend a clearer explanation of how the instructor thinks all his AWS courses are supposed to fit together.

By Stelios Ioannides

So far it looks very good.

By Ibra Cisse

I like the set up begining.

it is really easy to follow and understandable. I would say a very good beginning to how AWS is set up and work as well as how it works via installing RDS and Database management

By Elliott Arnold

A great code-along course

By Marc Lehner

videos out of order

By Pattabiraman Baskaran

Great course. It would have been nicer if you had shown the boto3 documentation a little bit, on navigating the resource object vs. client object, and choosing the appropriate resource actions and their attributes, for various operations.