Courses & TutorialsProgrammingSecurity & Cloud

RDS PostgreSQL and DynamoDB CRUD AWS with Python and Boto3

Description

Do you want to learn how to start a managed relational database or RDS on AWS? Would you like to learn how to use Python and the psycopg2 library to connect to your RDS database instance and perform all create, read, update, and delete (CRUD) operations? Or do you want to learn how to implement NoSQL DynamoDB tables on AWS and process data from scans and queries to updates, reads, and deletes?

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

In this course, we will first understand the tools and environment required to use AWS resources. We will use Python 3. According to the IDE, I suggest you use Jetbrains’ PyCharm. It even has a free community edition!

After I teach you how to set up the environment on MacOS and Windows, we will create our credentials for AWS as AWS access keys and AWS secret access keys for programmatic access to AWS resources. You will learn how to use the AWS CLI to set up AWS credentials globally on your computer. Before starting the implementation, as a final tip, I will show you how to use PyBoto3 to implement auto-completion on the PyCharm IDE!

After preparing the environment setup, we will start to implement our solution on AWS! Remember, we will use Python code to do all the work; there is no manual or manual work!

We will start with AWS’s RDS or relational database service. I will teach you how to start your own Amazon RDS instance purely with your Python code! Then we will learn how to connect to our RDS database instance using Python and the psycopg2 library. After that, I will teach you how to use the psycopg2 library to perform queries on RDS PostgreSQL. We will implement SELECT, INSERT, DELETE, UPDATE, etc. basically all CRUD operations for the RDS PostgreSQL instance we launched on AWS!

Next is DynamoDB! With the help of this very popular NoSQL service from AWS, I will teach you how to create your own DynamoDB table on AWS using Python! You will learn how to provide key patterns, attribute definitions, and apply throughput to your tables.

I will share the good news with you that there is a local version of DynamoDB, and you can simply run it on your computer! I will show you how to get and run a local version of DynamoDB on your computer, and we will set up our environment and boto3 client configuration accordingly.

Then we will start placing new items, updating, deleting and reading them. Once we have learned the basic CRUD operations of DynamoDB, we will proceed with fairly advanced operations such as scanning and querying.

We will also implement a script to insert our “movie” sample data set into our DynamoDB movie table! After inserting the data, we will begin to explore how to search for it using DynamoDB query operations, and we will also learn how to use conditions. Finally, we will look at the scanning operation, which basically scans your entire data and retrieves the results you need. Therefore, in order to filter out the results of the scan operation, we apply the filter expression to our scan operation and see how DynamoDB works.

In this course on AWS, a lot of information, hands-on practice, and experience await you. So, don’t miss any more time to join me in this course to use Python and Boto3 to improve your skills on AWS!

This course is suitable for:

  • AWS beginners who want to put the theory into practice
  • AWS certification preparers who want to practice knowledge through practical projects
  • Who wants to learn and implement infrastructure as code or IaaS on AWS
  • Who wants to learn how to use Python to develop infrastructure on AWS
  • Who wants to learn AWS Python API or Boto3

What you will learn

  • You will be able to use RDS and DynamoDB to implement any type of infrastructure with Python on AWS!
  • You will learn how to code against the AWS API using Python and Boto3!
  • You will learn how to use Python and Boto3 to launch and configure a relational database instance (RDS) on AWS!
  • You will learn how to use Python and psycopg2 to connect to an RDS PostgreSQL instance on AWS!
  • You will learn how to use Python and the psycopg2 library to implement create, read, update, and delete (CRUD) operations on RDS PostgreSQL!
  • You will learn how to create and configure NoSQL DynamoDB tables on AWS using Python and Boto3
  • You will learn how to use Python and Boto3 to implement create, read, update, and delete (CRUD) operations on DynamoDB!
  • You will have the confidence to use Python to use AWS APIs for any type of AWS resources on RDS and DynamoDB!

Specifications

  • Course Length: 4.5 Hours
  • Course Size: 1.81 Go
  • Number of sections: 7

How to Get the Course

Write an email to fullcoursesondemand@gmail.com for more detail

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button