These projects demonstrate my proficiency in SQL and my capacity to analyze complex data. They exhibit my abilities in data investigation, visualization, and analysis.

Hands-on demo for querying Kafka streams using SQL with Trino and data integration with PostgreSQL.

Wireshark-like display filter for various data formats, including Python dictionaries, lists, objects, and SQL databases.

A data searching/query program which processes randomised data from a csv, with OOP/SOLID principle focused design.

Master Thesis' repository to test InfluxDB capabilities on mixed workload (12/2020)

A declarative data querying library inspired by graphql.

BigData knowledge system（大数据知识体系）.

This repository contains solutions to 50 SQL problems from Leetcode, categorized into various SQL concepts. It serves as a learning resource for SQL enthusiasts and a quick reference for solving common SQL queries.

This repository contains SQL-based projects where I analyze diverse datasets, including international debt statistics, American baby name trends, and the golden age of video games. Each project demonstrates my ability to manipulate and query data to extract insights, create meaningful reports, and perform trend analysis using SQL.

Portfolio of data analysis using SQL

Analysis on Employee Data using SQL on MySQL Workbench

This project highlights my SQL problem solving skills on advanced concepts like views, stored procedure, ACID transaction and Joins.

Master Thesis' repository to test PostgreSQL capabilities on data querying (12/2020)

Objective: Design and implement a comprehensive database for managing the lifecycle of athletes within the Apex Athlete Management Company.

Master Thesis' repository to test InfluxDB capabilities on data querying (12/2020)

Army database for effiient tracking of military and non-military operations

COVID-19 data till 2024. Data cleaning, preparation and querying with Python. The cleaned and aggregated data was used to prepare a dashboard in Tableau.

"IPL Match Bidding App - Pie-in-the-Sky" is a SQL tool decoding IPL match data. It analyzes bidder success, popular stadiums, and toss impact. Tailored for IPL decision-makers, it simplifies complex data for strategic insights in just a few clicks.

Databases with PostgreSQL - 2nd semester

A comprehensive IMDB dataset analysis using SQL. Includes database setup, advanced queries, and actionable insights. Organized with files for database creation, queries, and solutions. Features an Entity-Relationship Diagram (ERD), executive summary, and SQL scripts. Perfect for SQL workflows and business intelligence in the film industry.