Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Google Cloud Platform icon

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]( - [SQL Deep Dive](

Google Cloud Platform icon

Path Info

Clock icon Beginner
Clock icon 45m
Clock icon Jun 04, 2021

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. Challenge

    Create DB Connection (

    1. 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 the psql command.

    2. Once connected as the postgres user, you can create a database user named cloud_user. Be sure to grant the user access to the contracts database.

    3. With the user created, you are ready to create the get_database_connection function in the file. This function will return a connection object that can be used to access the database.

  2. Challenge

    Create and Populate Table (

    With the connection created, create a table and populate it with the create_table function.

  3. Challenge

    Read Data (

    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.

  4. Challenge

    Update and Delete (

    With the data successfully loaded, you are now ready to make some updates via the update_data function.

    1. First, you need to update the due date for the author “Smith, Jackson”.

    2. Lastly, you'll need to resolve the failed assertation the number of Smith Jackson rows is incorrect by deleting the extra rows.

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Start learning by doing today

View Plans