Skip to content

Commit f65b80c

Browse files
authored
added postgresql
1 parent 2d00ec2 commit f65b80c

1 file changed

Lines changed: 8 additions & 2 deletions

File tree

README.md

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,10 @@
1+
# java-sql
2+
3+
A student that completes this project shows that they can:
4+
* Query data from a single table
5+
* Query data from multiple tables
6+
* Create a new datadaase using PostgreSQL
7+
18
# Introduction
29

310
Working with SQL
@@ -57,7 +64,7 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
5764

5865
### Keep track of the code you write and paste at the end of this document
5966

60-
- use [`SQLite Studio`](https://sqlitestudio.pl/index.rvt) to create a database, name it `budget.sqlite3`.
67+
- use pgAdmin to create a database, naming it `budget`.
6168
- add an `accounts` table with the following _schema_:
6269

6370
- `id`, numeric value with no decimal places that should autoincrement.
@@ -68,4 +75,3 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
6875
- the `id` should be the primary key for the table.
6976
- account `name` should be unique.
7077
- account `budget` is required.
71-
> This can be done with the CREATE TABLE clause

0 commit comments

Comments
 (0)