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.

tabeltalk is a declarative language for seamless interaction with your database, enabling you to define data access configurations in a YAML file and query their data lakes using natural language

A declarative data querying library inspired by graphql.

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

FiQueLa is a lightweight PHP library for querying structured files (JSON, XML, CSV, YAML, NEON) using SQL-like syntax with support for stream processing and advanced data functions.

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

Portfolio of data analysis using SQL

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

This project analyzes Netflix’s movies and TV shows dataset using SQL to derive insights and answer key business questions.

University of Roehampton, London

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.

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.

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

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.

This repository showcases my Power BI skills, which I acquired through an online course on Udemy. You can view my certificate at the link below. For a quick review, see ‘Final report- Preview.pdf’. For the INTERACTIVE report, download ‘Final report.pbix’. No need to download raw data as it’s imported directly into the report from this repository.

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.