Closed Sgreid7 closed 4 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.
[x] Install Postgres
[x] Create a database: company_database
company_database
[x] Create a table: employees
employees
[x] Add the following columns to the table, Use your best judgement for data types
[x] Create queries that can do the following:
parking_spot_number
[x] Turn in the above queries as a gist
Since we are starting our second lanaguage, be sure to keep your C# skills sharp.
entity framework core
https://gist.github.com/Sgreid7/9ce6f01c3ac75c62314b759eb0bc5388
INSERT INTO Student (knowledge) VALUES ('SQL')
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
Explorer Mode
[x] Install Postgres
[x] Create a database:
company_database
[x] Create a table:
employees
[x] Add the following columns to the table, Use your best judgement for data types
[x] Create queries that can do the following:
parking_spot_number
as a string that up to 10 characters long[x] Turn in the above queries as a gist
Adventure Mode
Since we are starting our second lanaguage, be sure to keep your C# skills sharp.
Epic Mode
entity framework core
Additional Resources
Recommended Practice: