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.

Portfolio of data 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.

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

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

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.

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 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.

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

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.

Analysis using SQL on Music Store Data.

🚀 A dynamic GraphQL Apollo Server in Node.js & TypeScript for querying and managing mock TV shows data. Explore, query, and interact with TV show information through a playful GraphQL interface. 📺