Week 07 - Day 1 - INSERT INTO Student (knowledge) VALUES ('SQL')

gstark commented 5 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.

Objectives

[ ] Create a database:
- C#: called CompanyDatabase
- Ruby: called company_database
[ ] Create a table:
- C#: named Employees
- Ruby: named 'employees'
[ ] Add the following columns to the table, Use your best judgement for data types
- C#
  - Id (Primary Key)
  - FullName
  - Salary
  - Position
  - PhoneExtension
  - IsPartTime
- Ruby
  - id (Primary Key)
  - full_name
  - salary
  - position
  - phone_extension
  - part_time
[ ] Create queries that can do the following:
- [ ] Select all columns for all employees
- [ ] Select only the Full Name and Phone Extension for only Full Time employees
- [ ] Insert a new part time employee, as a software developer, part time, with a salary of 450
- [ ] Update all employees that are the cooks to have a salary of 500
- [ ] Delete all employees that have the full name of "Lazy Lynn"
- [ ] Update all employees to be full time
- [ ] Add a column to the table
  - C#: called ParkingSpotNumber as a string that up to 10 characters long
  - Ruby: called parking_spot_number as a string that up to 10 characters long
[ ] Turn in the above queries as a gist