A collection of SQL exercises completed while studying databases at the University of Oulu.
This repository demonstrates practical use of relational databases and SQL, including:
SELECT,WHERE, andORDER BY- Filtering and
NULLhandling DISTINCTJOINoperations- Self joins
- Aggregate functions
GROUP BYandHAVING- Subqueries
- Correlated subqueries
UNION- SQLite date functions
INSERT,UPDATE, andDELETE
Basic data retrieval, filtering, sorting, and handling missing values.
Queries combining related tables using joins, including self joins.
Queries using nested queries to filter or compare data.
Aggregate functions such as COUNT, SUM, AVG, MIN, grouping, and HAVING.
Examples of inserting, updating, and deleting relational data.
More complex queries combining techniques such as UNION, date calculations, correlated subqueries, and multi-table relationships.
The exercises were completed as part of database studies at the University of Oulu.
Original course exercises are provided through the University of Oulu Lovelace learning environment.
The descriptions in this repository have been shortened or paraphrased rather than reproducing the original exercise material.
The SQL queries are my own solutions.
Course database files and Moodle-only course materials are not redistributed in this repository.