Repository contains a collection of Databases projects and code samples showcasing my skills and experience in SQL,PostgreSQL development. It serves as a portfolio to demonstrate my proficiency in various aspects of Database programming. Includes tasks related to SQL, PostgreSQL and GIS.
Project 1: Indexing
Description: The goal of this project is to get accustomed to advanced indexing in relational databases. Both the provided example datasets and the exercises use PostgreSQL 9.x or later.
Project 2: GIS
Description: To get accustomed to spatial extensions to relational databases, using PostgreSQL and PostGIS.
Project 3: Datawarehouse
Description: PostgreSQL-based OLAP system with star model, ETL, and SQL query for analysis and reporting.
Project 4: Neo4J | Graph Databases
Description: This project demonstrates graph Databases by setting up Java 11, installing and configuring Neo4J, creating a graph representing AGH Campus features, running analytics queries, using REST/API for data manipulation, and generating a Cypher dump for reporting.
Project 5: SQLite
Description: Simple programs managing a large amount of data: using native data structures typical for the programming language and SQLite database.