Skip to content

Commit f068704

Browse files
authored
Update README.md
1 parent 3c7a2bf commit f068704

1 file changed

Lines changed: 17 additions & 2 deletions

File tree

README.md

Lines changed: 17 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -11,9 +11,24 @@ Working with SQL
1111

1212
# Instructions
1313

14-
Surf to [SQL Try Editor at W3Schools.com](https://www.w3schools.com/Sql/tryit.asp?filename=trysql_select_top)
14+
ReImport the Northwind database into PostgreSQL using pgAdmin. This is the same data we used during the guided project.
1515

16-
### **Clicking the `Restore Database` button in the page will repopulate the database with the original data and discard all changes you have made**.
16+
clone https://github.com/pthom/northwind_psql.git
17+
18+
## pgAdmin
19+
20+
* Right Click Databases
21+
* Create
22+
* type in northwind2
23+
24+
* Tools -> Query Tool
25+
* Open file northwind.sql (from cloned repo)
26+
* Execute
27+
28+
* Look under
29+
* northwind2 -> Schemas -> public -> tables
30+
31+
* Clear query windows
1732

1833
Answer the following data queries. Keep track of the SQL you write by pasting it into this document under its appropriate header below. You will be submitting that through the regular fork, change, pull process.
1934

0 commit comments

Comments
 (0)