Practice on PostgreSQL Database

Contents

1. Selection
   • Lecture https://kolosovpetro.github.io/cs/data_bases/SQL01.pdf
   • Exercises https://kolosovpetro.github.io/cs/data_bases/exercises/SQLExercise_01_Select.pdf
2. Joins
   • Lecture https://kolosovpetro.github.io/cs/data_bases/SQL02.pdf
   • Exercises https://kolosovpetro.github.io/cs/data_bases/exercises/SQLExercise_02_Joins.pdf
3. Sets and Aggregate Functions
   • Lecture https://kolosovpetro.github.io/cs/data_bases/SQL03.pdf
   • Exercises https://kolosovpetro.github.io/cs/data_bases/exercises/SQLExercise_03_SetsAggregate.pdf
4. Subqueries
   • Lecture https://kolosovpetro.github.io/cs/data_bases/SQL04.pdf
   • Exercises https://kolosovpetro.github.io/cs/data_bases/exercises/SQLExercise_04_Subqueries.pdf
5. DML (Data Manipulation Language) - Insert, Delete, Update
   • Lecture https://kolosovpetro.github.io/cs/data_bases/SQL05.pdf
   • Exercises https://kolosovpetro.github.io/cs/data_bases/exercises/SQLExercise_05_DML.pdf
6. DDL (Data Definition Language) - Creating tables
   • Lecture https://kolosovpetro.github.io/cs/data_bases/SQL06.pdf
   • Exercises https://kolosovpetro.github.io/cs/data_bases/exercises/SQLExercise_06_DDL.pdf
7. Stored Procedures
   • Guide: https://www.postgresqltutorial.com/postgresql-stored-procedures/