Databases Design. Introduction to SQL LAB WORK 4 PostgreSQL

1. Databases Design. Introduction to SQL LAB WORK 4 PostgreSQL

IITU, ALMATY, 2020

2. Installation

• www.postgresql.org/download/

3. PostgreSQL + pgAdmin

Recommendation:
PostgreSQL 9.5 +
pgAdmin 3

4. Connection to server

5. Connection to server

Password
(for IITU
computers):
webuser

6. Creating a new database

7. Creating a new database

8. Creating a new database

9. Creating a new database

10. CREATE DATABASE

11. New query

12. New query

13.

14. Save as *.sql