This repository presents the Ad Hoc Insights project built for AtliQ Hardware, a leading computer hardware manufacturer. The solution addresses management's need for quick, data-informed decisions across 10 business requests.
Explore a diverse collection of MS SQL projects showcasing advanced query writing, data manipulation, and complex querying techniques, all solving real-world challenges. Demonstrates expertise in hierarchical queries, window functions, joins, and more.
SQL practice queries developed using PostgreSQL, covering database operations, joins, subqueries, window functions, views, and other essential SQL concepts.
Querying, data manipulation, performance optimization, and AWS-specific SQL
SQL case study on an employee database utilising filtering, logical conditions, pattern matching, and multi-condition queries to answer core HR questions: identifying high earners, segmenting by department and demographics. Built in MySQL Workbench.
A hands-on SQL case study answering core business questions on an employee database identifying high earners, filtering by department and demographics, and combining logical conditions and pattern matching to simulate real analyst query-writing. Built in MySQL.
To associate your repository with the query-writing topic, visit your repo's landing page and select "manage topics."