- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud

Use PostgreSQL with Python
In this lab, you will learn how to perform Create Read Update and Delete (CRUD) processes on a PostgreSQL database. You will first create a table and then add data to it. You will practice reading data from the table and making corrections to the data. You will need basic Python programming and SQL skills for this lab: - [Certified Associate in Python Programming Certification](https://acloud.guru/overview/8169e8e7-91a7-4d92-b278-4dd08c787dc6) - [SQL Deep Dive](https://acloud.guru/overview/cb92a6bf-6e2b-44ea-80be-b925d76295da)

Lab Info
Table of Contents
-
Challenge
Create DB Connection (connect_db.py)
-
First, you will need to create a database user to use in your application. You can do this by connecting to the database as the
postgres
user using thepsql
command. -
Once connected as the
postgres
user, you can create a database user namedcloud_user
. Be sure to grant the user access to thecontracts
database. -
With the user created, you are ready to create the
get_database_connection
function in the connect_db.py file. This function will return a connection object that can be used to access the database.
-
-
Challenge
Create and Populate Table (create_table.py)
With the connection created, create a table and populate it with the
create_table
function. -
Challenge
Read Data (read_data.py)
Now you can read the data from the table with the
read_data_from_db
function. The skeleton also has code to compare the read data to a known good copy and print it to the screen. -
Challenge
Update and Delete (update_data.py)
With the data successfully loaded, you are now ready to make some updates via the
update_data
function.-
First, you need to update the due date for the author “Smith, Jackson”.
-
Lastly, you'll need to resolve the failed assertation
the number of Smith Jackson rows is incorrect
by deleting the extra rows.
-
About the author
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.