e-Portfolio showcasing my personal projects.

The project aims to enforce an “always fresh” data policy in a database view of pivoted survey answers, from both inside the database with T-SQL and outside with programmatic access using Python.

Design of database for sports web portal and data manipulation script (SQL + Python)

A comprehensive project for generating, integrating, and visualizing volleyball championship data. It includes dummy data generation, database creation, ETL processes, and Power BI reports for insightful visualizations.

Springboard Open Ended Capstone

Scripts to auto-deploy SQL from SQL Server and to dump database objects to disk

Proof of Concepts, Exploits

Email(gmail) with attachment from python script.

Visualisation of tweets sent by main polish parties and presidential candidates during polish president elections 2020.

A very basic POC MSSQL unit testing framework using Python and T-SQL. Directory/file driven unit tests using SQL and JSON.

Database Lab - Spring 2023

This is a database developed in SQLite simulating a social media like LinkedIn! This database has 17 tables (5 main+12 others)

CRUD com python e SQL server(T-SQL)

Solutions to LeetCode questions using Python (algorithms, concurrency), T-SQL (database) and awk (shell) by https://leetcode.com/user6659P/

code to support the NEXT-D study

Using Python Pandas dataframe to read and insert data to Microsoft SQL Server

dbt adapter for SQL Server and Azure SQL