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

[x] Create a database:
- C#: called CompanyDatabase
- Ruby: called company_database
[x] Create a table:
- C#: named Employees
- Ruby: named 'employees'
[x] 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:
- [x] Select all columns for all employees
- [x] Select only the Full Name and Phone Extension for only Full Time employees
- [x] Insert a new part time employee, as a software developer, part time, with a salary of 450
- [x] Update all employees that are the cooks to have a salary of 500
- [x] Delete all employees that have the full name of "Lazy Lynn"
- [x] Update all employees to be full time
- [x] 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
[x] Turn in the above queries as a gist