AirBNB is a rental and hospitality website that is used all over the world in more than 191 countries for short-term lodging such as vacations. The company that was founded in 2008 has a lot of customers who rent the houses of the hosts who put up their houses on rent. The purpose of this project is to design and develop the database of AirBNB t…
Develop a SQL script to create a database with tables, views, roles, and functions. Form personalized offers to increase average check, frequency of visits, and cross-selling.
🗄️ 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.
Advanced PostgreSQL - PL/pgSQL triggers, stored functions, CTEs, materialised views, functional indexes, and query optimisation - Relational Database Systems at UQ
A PostgreSQL library system with automated stock management, reporting views, and audit logging. Designed to enforce data integrity, handle multi-author books, and support real-world loan workflows efficiently.
A SQL-only ETL data infrastructure
End-to-end Snowflake Data Engineering project demonstrating real-time ingestion, CDC with Streams, automated Tasks, data quality pipelines, and Gold layer analytics for enterprise-scale retail analytics.
Advanced PostgreSQL database project demonstrating stored procedures, triggers, views, indexing, recursive CTEs, and concurrency control.
Relational database project for managing sports competitions and teams, designed with conceptual and logical modeling, SQL queries, views, and triggers.
Relational database project for a banking information system, developed using SQL and PostgreSQL.
A database design project simulating a national coffee shop chain's data infrastructure. Demonstrates schema normalization, ER modeling, SQL scripting, and cross-database integration using PostgreSQL and MySQL.
Enterprise-grade SQL analytics platform using PostgreSQL
PostgreSQL job and career platform database with relational schema, PL/pgSQL procedures, triggers, views, and validation scripts.
End-to-end Data Engineering projects built with Snowflake, featuring the Ingestion–Transformation–Delivery (ITD) framework, Dynamic Tables, Streamlit dashboards, SQL transformations, UDFs, and declarative data pipelines. Based on Snowflake Northstar hands-on labs.
SQL and PostgreSQL study project: DDL/DML, joins, subqueries, indexes, transactions and triggers, with a Node.js example.
Relational library database built in PostgreSQL with schema design, triggers, views, indexes, and reporting queries.
Comprehensive 50+ SQL query problems. Explores relational query optimization, multi-level subqueries, Common Table Expressions, and materialization strategies for real-world data analysis.
Database Management and Database Design ( SQL )
Mini datamart hospitalar em PostgreSQL com schema raw/analytics, views semânticas e KPIs (taxa de ocupação, LOS, reinternações 30d). Foco em modelagem e raciocínio analítico.
To associate your repository with the views topic, visit your repo's landing page and select "manage topics."