To address the given task, a comprehensive database was developed, comprising 8 tables, each containing unique information about universities. These tables cover various aspects of educational institutions, providing detailed information for analysis and queries.

The goal of this project is to develop a database consisting of at least three tables, providing the opportunity to practice writing SQL queries of varying complexity levels. Creating a database structure with diverse tables enables efficient querying and analysis of data related to higher education.

1. Using transaction when Filling db
2. Using 'select' and sorting
3. Using 'join', 'left join' for joining tables and 'limit', 'offset' for limiting entries
4. Using normal condition
5. Using a reverse sort
6. Joining tables with sorting
7. Joining with condition
8. Joining multiple tables
9. Using CTE (Common Table Expressions)
10. Joining multiple tables with sort and limit
11. Using aggregate functions: 'count', 'max', 'min' and CTE
12. Using a window function 'LAG', 'CONCAT', 'ROUND' and CTE

• dbdiagram: Visual tool for designing database schemas. Allows creating and editing diagrams for a more visual representation of data structure.

• DBeaver: Universal platform for database administration. Provides a wide range of functionalities for working with various types of databases and executing SQL queries.

Universities Database Diagram

• Implementation of a parser to gather large amount of information about universities and increase the number of entries in the table.
• Creation of a website with a user-friendly interface for prospective students, aiding in the selection of suitable universities.
• Integration of the database with the website.