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.
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.
Analyzing and cleaning of COVID-19 data using different SQL functionalities.
Danny Ma's #8WeekSQLChallenge case study solutions.
bunch of SQL Window function query examples
MySQL-for data analytics
sql along with a case study
Demo of using window function with JOOQ & Springboot
MySQL + Tableau Project
data-modeling-analysis-sql
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.
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
Add a description, image, and links to the window-functions-in-sql topic page so that developers can more easily learn about it.
To associate your repository with the window-functions-in-sql topic, visit your repo's landing page and select "manage topics."