Genealogy is a free and open-source family tree PHP application to record family members and their relationships, build with Laravel 11.

Directed Acyclic Graphs with a variety of methods for both Nodes and Edges, and multiple exports (NetworkX, Pandas, etc). This project is the foundation for a commercial product, so expect regular improvements. PR's and other contributions are welcomed.

Common Table Expression builder that uses Doctrine DBAL

UI to visualize common table expressions in sql scripts

Examples of SQL queries created for Customer and Sales Data Analysis study project

Wise Owl SQL Server Exercises Solutions

Analyze product data for an online sports retail company to optimize revenue.

SQL Challenge

in.orbit-api é uma API Rest com o fim de realizar o gerenciamento de metas semanais, permitindo o cadastramento da meta, quantidade de dias que será realizada durante a semana, listagem, exibindo as metas da ultima semana baseando-se no dia atual com a contagem de dias que a meta foi realizada e permitindo a atualização de uma meta como concluída.

Unlock the power of SQL’s Common Table Expressions (CTEs) to transform data analysis capabilities! In this project, I demonstrate how to leverage CTEs to answer complex business questions with clarity and efficiency. Whether you’re dealing with hierarchical data, simplifying complex queries, or improving readability, CTEs are a game-changer.

Advanced SQL, covering Oracle PL/SQL and PostgreSQL PL/pgSQL with phases on using procedures, functions, triggers, query optimizations, packages, and Docker server setup 💡

TSQL-Project about the management of a plant store

This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.

Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.

Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.

A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.

Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.

RFM Analysis for customer segemntation, to categorize the customers based on resency, frequency and monetary. by using analytical SQL functions and common table expression(CTE).

my learnings and practice with SQL functions

Business questions were solved for Rockbuster Stealth LLC, a fictional movie rental company, through the use of SQL in this project. This project was completed as part of the CareerFoundry's curriculum.