Projetos desenvolvidos para a matéria "Aplicações com Banco de Dados" da Fatec Rubens Lara.

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

SQL Bootcamp

DBS - Assignment 4 and 5 - Data Modeling and Implementation of processes on database layer

Scripts for DBMS PostgreSQL.

Prática de recursos avançados do PostgreSQL, incluindo PL/pgSQL, triggers, procedures e técnicas de consulta.

School's SQL bootcamp (12 projects, 2 of them in a group)

En este archivo se crean los objetos de la base de datos (tablas y valores insertados)

Mapped out the database as part of a group, set up and connected to ElephantSQL, DDL file to build out database and connections, DML file to manually insert data

advanced postgresql

Lightweight and extensible PostgreSQL DML audit solution - Automatic trigger management, per-schema control, structured JSONB logs for tracking INSERT, UPDATE, and DELETE operations.

It includes basic and advanced database operations that I learned with PostgreSQL during my internship.

Airline online tickets reservations database scheme for commercial flights

SQL-запросы к PostgreSQL (в примерах и задачах)