This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

Using complex SQL queries, including PostgreSQL window functions, to answer specific business questions. Notably using multiple named subqueries, views to extract data from a database to address specific problems.

MySQL-for data analytics

Danny Ma's #8WeekSQLChallenge case study solutions.

Demo of using window function with JOOQ & Springboot

A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored procedures, and other out of the box solutions.

bunch of SQL Window function query examples

MySQL + Tableau Project

data-modeling-analysis-sql

Analyzing and cleaning of COVID-19 data using different SQL functionalities.

Аналитический проект из ad-hoc запросов к базе данных с данными об авиаперевозках

A Data Collection and Storage project using SQL from TripleTen

Get ready to boost your SQL proficiency, solve intriguing data problems, and earn a sense of accomplishment as you complete this 8-week journey. Whether you're a data analyst, a database administrator, or simply passionate about data, the '8 Weeks of SQL Challenge' will help you level up your SQL skills and open up new opportunities.

This project analyzes e-commerce order fulfillment using Advanced SQL Techniques and Python-based visualization to uncover insights on sales trends, customer segmentation, shipping cost optimization, and payment preferences.

SQL Data Analysis and Estimation Projects

MySQL code using subqueries and window functions

Case Study #1 - Danny's Diner

SQL exercises and projects done at alx training

Built a Data Model, Implemented Basic to Advanced SQL Queries