Skip to content

Latest commit

 

History

History
35 lines (30 loc) · 2.29 KB

README.md

File metadata and controls

35 lines (30 loc) · 2.29 KB
Raw

SQL - PSQL Database - Design, Setup, and Querying

Background

In this exericse, you take on the role of a data engineer at Pewlett Hackard, exploring and analyzing employee data from the 1980s and 1990s. You are using the tool PgAdmin4 to build, and manage a database as well as manually import CSV files and run queries to retrieve the following information: requested-information.md

Workflow

  • [0] Fix errors as they arise and use version control
  • [1] Find data (e.g. - CSV files)
  • [2] Create project directory folders
  • [3] Gain access to necessary tools, remoately installed locally (VSCode, PgAdmin4, PSQL, QuickDBD, GitHub)
  • [4] Use QuickDBD to generate database design
  • [5] Build database in PgAdmin4 according to database design
    • [i] Launch PgAdmin4
    • [ii] Set ip Master Password
    • [iii] Add New Server (Right click on Servers > Register > Server...)
    • [iv] In the "General" tab, enter a name for the server
    • [v] In the "Connection" tab, enter Host: "localhost", Port: "5432", username: "postgres", pswd: your psql password
    • [vi] Save and Connect
    • [vii] Click > "Servers" v "Databases" -> Right-click > "Create" > "Database..."
    • [viii] Enter database name and other optional details and click "Save"
    • [ix] Click your database > Schemas > public > Tables > Right-click Tables > Create > Table > Name table and other optional details > click "Save"
  • [6] Import data to database
  • [7] Execute queries to return desired information from database
  • [8] Write project contextual information and workflow in README.md
  • [9] Write answeres to exeucted queries in answered-question.md

Database Design

Tools