In this lab we will learn how to execute SQL from the ipython notebook and practice some queries on the Northwind sample database that we used in Lesson 3.1.
We have imported this database into our PostgreSQL which you can access as follows:
psql -h dsi.c20gkj5cvu3l.us-east-1.rds.amazonaws.com -p 5432 -U dsi_student northwind password: gastudents
Use your new SQL skills to query the Northwind database and extract some interesting information.
- Inspect the database (what tables, what schemas)
- Inspect the products table (what columns, what data types)
- Inspect the orders table (what columns, what data types)
- Explore other tables in the database (employees, suppliers, etc.)