This repository contains SQL queries from various popular online learning resources e.g. Vertabelo Academy, SQLZoo etc.
Spark in Action, 2nd edition - chapter 15 - Aggregating your data
DataCamp project (SQL) - When Was the Golden Age of Video Games?
Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.
Query a Digital Music Store Database, For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information.
This project uses SQL to transform messy transactional sales data into a clean, validated dataset for accurate KPI and profitability analysis before BI reporting. I also built a Tableau Public dashboard from this final dataset; it can be viewed via the link below.
Basically compressing rows with aggregated functions (Equivalent to multiple COUNT())
Two SQL-based data analysis projects, demonstrating skills in querying, aggregating, and transforming structured datasets. Projects include creating complex queries, joining multiple tables, filtering and grouping data, calculating key business metrics, and generating insights for decision-making.
Collection of basic‑level SQL projects from DataCamp’s Real‑World Projects, applying query logic, filtering, joins, and aggregation to explore real‑world datasets and practice SQL fundamentals.
🐘 PostgreSQL solutions exploring relational schema design, JOIN operations, aggregation functions, stored procedures, and data integrity constraints through practical wildlife conservation database problems.
Sales Trend Analysis Using Aggregations
Sales Trend Analysis Using Aggregations
A collection of SQL practice, problem-solving exercises, and completion achievements from SQL-Practice.com, W3Schools, HackerRank, DataLemur, and LeetCode.
Comprehensive Laravel Database Engineering fundamentals covering SQL operations, database transactions, Query Builder, advanced filtering, joins, aggregations, raw queries, query optimization, pagination, cursor-based data retrieval, database migrations, and database seeding.
To associate your repository with the sql-aggregation topic, visit your repo's landing page and select "manage topics."