Welcome to the Database I Exercises repository! This repository contains a collection of SQL exercises designed for learning and practicing SQL with PostgreSQL, as part of a Database I course.
The exercises cover a range of topics essential for understanding and working with relational databases:
- Normalization: Techniques for organizing database schemas to reduce redundancy and improve data integrity.
- Relational Algebra: Fundamental operations for querying and manipulating relational data, including selection, projection, union, intersection, and difference.
- Algebraic Optimization: Methods for optimizing query performance by transforming queries into more efficient forms.
- SQL:
- CREATE: Creating tables, indexes, and other database objects.
- INSERT: Inserting data into tables.
- Set Operators: Using operators like UNION, INTERSECT, and EXCEPT to work with sets of results.
- EXISTS: Checking for the existence of rows in a subquery.
- Views: Creating and managing views to simplify complex queries and provide a custom perspective of the data.