Sample databases for postgres

DataForge helps data teams write functional transformation pipelines by leveraging software engineering principles

A project to design a fact and dimension star schema for optimizing queries on a flight booking database using PostgreSQL, a relational database management system. This schema is well-suited for a flight booking database, as it allows for efficient querying of data such as booking dates, flight routes, and passenger information.

The Bootcamp, Workshop for SQL challenges

This is a repository to hold the files and notebooks produced throughout my Udacity's Nanodegree Data Engineering program.

Star-schema data mart on PostgreSQL built from Goodbooks CSVs. Demonstrates advanced SQL (window functions, JSONB, GROUPING SETS), indexes (covering/partial/GIN/pg_trgm), materialized views, incremental MERGE loads, pgTAP tests, and GitHub Actions CI. Includes Docker quickstart and SSH-tunnel instructions

Projects Completed in the Data Engineering Nanodegree By Udacity

A SQL-only ETL data infrastructure

🗄️ SQL repository for the Databases course of the 1st year of the Web Development degree. It contains SQL scripts 📜 to create databases, queries 🗃️, entity-relationship diagrams 🧩, user and permission management queries 👥, and views 📊 of the databases.

This project delivers a modern data warehouse which focuses on building clean, organized data pipeline which covers important aspects such as ETL Pipeline Development, Data Cleaning, Data Modelling and Data Analytics

SQL Employee Database Queries

Data Modelling and Databases II

Complete PostgreSQL project with 16 progressive modules covering fundamentals through advanced topics. Features realistic urban datasets for practical experience with PostGIS, JSONB, performance optimization, security patterns, and production deployments. Includes Docker setup for immediate use.

🗄️ Learn PostgreSQL through real-world scenarios, hands-on exercises, and advanced patterns, guiding you from beginner to expert.

This repo is for holding the GIF325 at University of sherbrooke - Fall 2024 - S3

Billing Data Warehouse Staging Area with PostgreSQL

Персональная база данных для учета привычек, финансов, курсов и тд..

Build a modern data warehouse with postgresql/snowflake/duckDB, including ETL processes, data modelling, and analytics.

Data warehouse build in PostgreSQL

This project includes data modeling, engineering and analysis of employee data. Demonstrates use of SQL, creating schemas, queries, joins, aggregate functions, primary keys, and foreign keys.