Open TristanDeAugustine opened 5 years ago
+-----------------+----------+--------------------+-------------------+-------------+ | full_name | salary | job_position | phone_extension | part_time | |-----------------+----------+--------------------+-------------------+-------------| | Stephen_Gacio | 5000 | CTO | -3749 | False | | Albert_Strange | 4600 | Model | -6082 | False | | Nick_Weber | 3200 | Plug | -8034 | False | | Chris_Something | 10000 | Soundcloud | -6904 | False | | Rick_Ortiz | 6800 | Stripper | -2527 | False | | Future_Drake | 450 | Software Developer | -8823 | False | | Chef | 500 | Cook | -6448 | False | +-----------------+----------+--------------------+-------------------+-------------+ SELECT 7
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
[ ] Create a table:
employees
[ ] Add the following columns to the table, Use your best judgement for data types
[ ] Create queries that can do the following:
parking_spot_number
as a string that up to 10 characters long[ ] Turn in the above queries as a gist
Epic Mode
entity framework core
Additional Resources
Recommended Practice: