Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
assets
code/starter-code
readme.md

readme.md

title type duration creator
SQL Lab
lab
1:25
name city
Francesco Mosconi
SF

SQL Lab

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

Introduction

Use your new SQL skills to query the Northwind database and extract some interesting information.

Exercise

Requirements

  • 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)

Bonus:

  • Explore other tables in the database (employees, suppliers, etc.)

Starter code

Starter code

Solution code

Additional Resources