Closed mdewey closed 6 years ago
Every application uses data in some way. This will help you set up your development environment as well as get used to querying databases.
Use homebrew to install Postgres
brew install postgres
[x] Install Postgres
[x] Create a database called CompanyDatabase
CompanyDatabase
[x] Create a table Called Employees
Employees
[x] Add the following columns to the table, Use your best judgement for data types
[ ] Create queries that can do the following:
ParkingSpotNumber
[x] Turn in the above queries as a gist
https://www.postgresql.org/docs/10/static/index.html
For more practice, Hackerrank has a SQL Track
https://gist.github.com/Alexiskjg16/e8b4fcb51122ac0a0ae971142d61b188
Every application uses data in some way. This will help you set up your development environment as well as get used to querying databases.
Objectives
Requirements
For Mac:
Use homebrew to install Postgres
Windows:
Explorer Mode
[x] Install Postgres
[x] Create a database called
CompanyDatabase
[x] Create a table Called
Employees
[x] Add the following columns to the table, Use your best judgement for data types
[ ] Create queries that can do the following:
ParkingSpotNumber
as a string that up to 10 characters long[x] Turn in the above queries as a gist
Adventure Mode
Epic Mode
Additional Resources
https://www.postgresql.org/docs/10/static/index.html
Recommended Practice:
For more practice, Hackerrank has a SQL Track