Course details
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, well start by… + Read More
Course details
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, well start by taking a look at the tools and the environment that we need to work with AWS resources. Well 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, well create our credentials for AWS as being the AWS Access Key and AWS Secret Access Key for programmatic access to AWS resources. Youll learn how you can set your AWS credentials globally on your computers using AWS CLI. Before jumping into the implementation, for one last tip, Ill show you how you can have auto-complete capabilities on your PyCharm IDE with PyBoto3!
Once were ready with our environment setup, well start implementing our solution on AWS! And remember well do everything with Python code; not a single thing manually or by hand!
Well start off with RDS or Relational Database Service from AWS. Ill teach you how to launch your own Amazon RDS Instances purely with your Python code! Then well learn how to connect to our RDS database instance using Python and psycopg2 library. After that, Ill teach you how to execute your queries against RDS PostgreSQL using psycopg2 library and well 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, Ill teach you how to create your own DynamoDB Tables on AWS with Python! Youll learn how to provide a key schema, attribute definitions and apply throughput to your tables.
And Ill 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 well setup our environment and boto3 client configuration accordingly.
Then well start making our way to putting new items, updating, deleting and reading them. Once we learn the basic CRUD operations with DynamoDB, well move on to rather advanced operations like scanning and querying.
Well also implement a script to insert our sample data set of movies into our DynamoDB Movies table! Once we insert the data, well start exploring how we can search it using DynamoDB query operation and well also learn how we can use conditions. And finally, well 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, well 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!
Updated on 14 November, 2018 - Read Less
