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)
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- 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
postgresuser using thepsqlcommand.Once connected as the
postgresuser, you can create a database user namedcloud_user. Be sure to grant the user access to thecontractsdatabase.With the user created, you are ready to create the
get_database_connectionfunction in the connect_db.py file. This function will return a connection object that can be used to access the database.
- Create and Populate Table (create_table.py)
With the connection created, create a table and populate it with the
create_tablefunction.- Read Data (read_data.py)
Now you can read the data from the table with the
read_data_from_dbfunction. The skeleton also has code to compare the read data to a known good copy and print it to the screen.- Update and Delete (update_data.py)
With the data successfully loaded, you are now ready to make some updates via the
update_datafunction.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 incorrectby deleting the extra rows.
