- Chinook Database Schema
- Create a database named
507_Section_11 - Run this command
- Mac Users:
psql 507_Section_11 -f Chinook_PostgreSql_utf8.sql - Windows Users:
psql 507_Section_11 postgres -f Chinook_PostgreSql_utf8.sql
- Mac Users:
- Edit a step in
chinook_database.py, run the file, and repeat- Some questions to consider:
- What table(s) do you need to get data from?
- What fields in each table do you need to get data from?
- Some questions to consider:
- SELECT: https://www.postgresql.org/docs/10/static/sql-select.html
- Aggregate Functions: https://www.postgresql.org/docs/current/static/functions-aggregate.html
- String Functions: https://www.postgresql.org/docs/current/static/functions-string.html
- Pattern Matching: https://www.postgresql.org/docs/8.0/static/functions-matching.html
- Chinook_PostgreSQl.sql from Chinook Database
- Chinook Database Schema from Chinook Database Documentation
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent