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.

A SQL-only ETL data infrastructure

Projects Completed in the Data Engineering Nanodegree By Udacity

🗄️ 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

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

Design and implement a normalized relational database for a coffee shop chain using PostgreSQL and MySQL. Explore data modeling and SQL scripting. 🐙

Data Modelling and Databases II

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

PostgreSQL database for managing accounts, customers, transactions and loan payments with Docker deployment

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.

Library Management System built using PostgreSQL in pgAdmin 4. The system manages book issuing, returns, and tracking with detailed records of books, members, employees, branches, and transactions. It supports CRUD operations on books and members, and helps streamline library workflows efficiently.