文件列表:

Datawarehouse/
GIS/
Indexing/
Neo4J_GraphDatabases/
DataWarehouse.md
GIS.md
Indexing.md
Neo4J_GraphDatabases.md
SQL_Language.md

# Databases Portfolio 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**. ## Projects ### Project 1: [Indexing](https://github.com/xkyleann/Databases_SQL_Portfolio/tree/main/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](https://github.com/xkyleann/Databases_SQL_Portfolio/tree/main/GIS) Description: To get accustomed to spatial extensions to relational databases, using PostgreSQL and PostGIS. ### Project 3: [Datawarehouse](https://github.com/xkyleann/Databases_SQL_Portfolio/tree/main/Datawarehouse) Description: PostgreSQL-based OLAP system with star model, ETL, and SQL query for analysis and reporting. ### Project 4: [Neo4J | Graph Databases](https://github.com/xkyleann/Databases_SQL_Portfolio/tree/main/Neo4J_GraphDatabases) 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. ### AGH Notes Documentation

Note 0: SQL Language

Documentation 0

Note 1: Indexing

Documentation 1

Note 2: GIS

Documentation 2

Note 3: Datawarehouse

Documentation 3

Note 4: Neo4J | Graph Databases

Documentation 4

Note 5: CouchDB

Documentation 5

Note 6: NoSQL, ACID, BASIC, CAP

Documentation 6

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：