Ex 3.11 Reading Tables from a Relational Database:

Objective: Read tables from a relational database and use fundamental SQL operations including SELECT, FROM, WHERE, and ORDER BY to query and manipulate data.

  1. Download the Ex3.11_ReadingTablesFromADatabase.ipynb file.
  2. Using the product_data.sqlite file, work through each of the steps in the Jupyter Notebook which should include both your code and the corresponding output that match the screengrabs of the completed steps 2, 4, and 5 provided below.

Expected output: pandas DataFrame from SQLite database showing product_data table loaded with SELECT query

 

Expected output: SQL query result using WHERE clause to filter product_data from SQLite database

 

Expected output: SQL query result using ORDER BY clause to sort product_data from SQLite database