PostgreSQL-Classes

Exercises made during "Databases" classes (III winter semester, 2018/19)

1. Introduction to PostgreSQL: psql, schemas
2. Simple queries, nulls,
   SELECT, ORDER BY, IN, BETWEEN, IS [NOT] NULL
3. Date functions, patterns, combining query results, calculations
   LIKE, SIMLAR TO, EXTRACT(), DATE_PART(), UNION, INTERSECT, EXCEPT, SUM, CASE WHEN
4. Multiple table queries
   NATURAL JOIN, LEFT/RIGHT/FULL [OUTER] JOIN, SELECT DISTINCT, WITH
5. Aggregate functions, subqueries
   GROUP BY, COUNT(), SUM(), AVG()
6. Data manipulation
   INSERT INTO, DELETE FROM, UPDATE
7. Database design, conceptual and logical model
8. Normalization
9. Database implementation, columns, data types, integrity, sequences
   BEGIN, COMMIT, CREATE SCHEMA, DROP TABLE, CREATE TABLE, CHECK(), REFERENCES, COPY, CURRVAL(), ALTER TABLE, ADD CONSTRAINT, SERIAL
10. Advanced subqueries
11. PL/pgSQL language