This repository contains my homework assignments and practice exercises for the course Advanced SQL at FIT CTU. The course builds upon the knowledge gained in BI-DBS and covers advanced relational and post-relational features of SQL, focusing on optimization and practical implementations.
- Advanced SQL features: stored procedures, triggers, recursive queries, OLAP support, object-relational constructs.
- Practical query optimization: specialized structures like indexes, clusters, index-organized tables, and materialized views.
- Query execution plans and optimization techniques.
- SQL standard with a focus on Oracle ORDBMS and later transitioning to PostgreSQL ORDBMS.
- Clone the repository:
git clone https://github.com/davidkopelent/BI-SQL.git
- Navigate to the folder:
cd BI-SQL - Open and modify files as needed
- Databases: Oracle, PostgreSQL
- Query Language: SQL, PL/SQL
- Version Control: Git
- This repository is intended for educational purposes.
- Solutions may be updated and improved over time.