week 07 - day 04 - part 1 - Welcome to SQL -

[jessicaevans17]

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

• Install Postgres
• Create a database for Employees
• Write some queries to use the database

Requirements

• Set up postgres by following these directions.

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

  • full_name
  • salary
  • job_position
  • phone_extension
  • part_time

• [x] 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 a full time
  • [x] Add a column to the table: parking_spot_number as a string that up to 10 characters long

• [x] Turn in the above queries as a gist

Epic Mode

• [ ] Investigate working with C# and Postgres, HINT: entity framework core
• LINQ Notes
• EF Core notes

Additional Resources

• PostgreSQL Documentation
• SQL Notes
• Join Notes

Recommended Practice:

• For more practice, Hackerrank has a SQL Track

[jessicaevans17]

https://gist.github.com/jessicaevans17/23e21be586ce89b58ba5d788df565b5c https://gist.github.com/jessicaevans17/79b8a4ae25bc52283771738b7ecc5fe7 https://gist.github.com/jessicaevans17/985052996b9a0b15914ddb68126367e9 https://gist.github.com/jessicaevans17/c703fb0cbb51080b2a15d78c9ab3f34c https://gist.github.com/jessicaevans17/47999032c1f1c8d580b5f55da955a787 https://gist.github.com/jessicaevans17/8b46ba7cfb2d2a63bb4ff1531cdf7091 https://gist.github.com/jessicaevans17/fa990ddcf6b3307ef076979d50f332e8