GitHub topics: window-functions
SergeySenigov/data-engineer-practicum-portfolio
Проекты курса Инженер данных на платформе Yandex Practicum
Language: Python - Size: 6.75 MB - Last synced at: 12 days ago - Pushed at: 12 days ago - Stars: 6 - Forks: 4

VeronSheva/HR_dashboards
Interactive HR dashboard using Tableau & MySQL – explore employee trends, performance, attrition, and salary insights.
Size: 8.56 MB - Last synced at: 14 days ago - Pushed at: 18 days ago - Stars: 0 - Forks: 0

Tharadol07969/sql_sales_analytic
A comprehensive collection of SQL scripts for data exploration, analytics, and reporting.
Language: TSQL - Size: 966 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

rogui-manal/Data-Analysis-with-SQL
This repository contains a comprehensive collection of SQL scripts based on a learning project aimed at practicing data exploration, analytics, and reporting techniques using SQL.
Size: 0 Bytes - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

NivedhaAk/world-layoffs-sql-project
SQL Data Cleaning and EDA on World Layoffs Dataset using MySQL
Size: 4.88 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

DataWithBaraa/sql-data-analytics-project
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.
Language: TSQL - Size: 20.7 MB - Last synced at: about 2 months ago - Pushed at: 2 months ago - Stars: 40 - Forks: 17

PoojaVishwakarm/SQL-Exploratory-Data-Analysis-EDA-Project-
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.
Language: TSQL - Size: 1.42 MB - Last synced at: 2 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

jatomsplamkakj/MySQL-Bootcamp-Go-from-SQL-Beginner-to-Expert
Repo containing materials from MySQL Bootcamp
Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

kmdawkins/portfolio-project2
SQL Database Normalization and Advanced Queries
Language: PLpgSQL - Size: 16.1 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

whoisalisha/BOM-Business-Analyst-Technical-Case-Study-Assignment
BOM(Bill of Materials) Business Analyst Case Study Solution using Python, Pandas manipulation and Visualization Technique
Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

ndomah/MySQL-Bootcamp-Go-from-SQL-Beginner-to-Expert
Repo containing materials from MySQL Bootcamp
Size: 586 KB - Last synced at: 2 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

Ankush-Santra/SQL_Projects
This repository showcases a curated collection of my SQL projects, demonstrating skills from foundational concepts like SELECT, INSERT, and ALTER to advanced techniques such as CTEs and Window Functions.
Size: 3.89 MB - Last synced at: 3 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

egorumaev/2024-colab-sqlite-postgresql
SQL-запросы в Google Colab с помощью SQLite и PostgreSQL
Language: Jupyter Notebook - Size: 473 KB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Prajjwol09/MySQL
The purpose of this repository is to provide a comprehensive guide to MySQL for beginners. It covers the basic concepts and operations involved in using MySQL.
Size: 28.3 KB - Last synced at: 3 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

muryulia/8-Week-SQL-Challenge
#8WeekSQLChallenge, https://8weeksqlchallenge.com: Solutions for SQL Case Studies
Size: 980 KB - Last synced at: 4 months ago - Pushed at: about 3 years ago - Stars: 41 - Forks: 17

HeatTransfer/7-Wonders
There are seven business-critical questions solved using SQL
Size: 3.91 KB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

Gopalkholade/Pizza-Sales-Analysis-with-SQL
Pizza Sales analytics with sql
Size: 15.7 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

SwethaAshervadam/RSVP_Movies_Assignment
RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2023.
Size: 112 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

victorcezeh/alt-exam-poc Fork of JesuFemi-O/alt-exam-poc
Alt school Fall semester DE exam questions.
Size: 3.38 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

maithilid12/Analyzing_Paper_Company_Database
Used Postgres SQL to analyze Parch and Posey Paper Company data
Language: TSQL - Size: 489 KB - Last synced at: about 1 year ago - Pushed at: almost 5 years ago - Stars: 0 - Forks: 0

Jaswin-J/Film-Rental-Analysis
Creating Report for decision making in Film Rental Store
Size: 796 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 1 - Forks: 0

ndleah/bitcoin-prices-analysis
💸 Bitcoin trading analysis
Language: SQL - Size: 1.11 MB - Last synced at: about 1 month ago - Pushed at: over 3 years ago - Stars: 7 - Forks: 4

arnavailable/sql
Size: 4.88 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

MuskanKhandelia/Famous_Paintings_Data_Analysis
data-analysis-sql
Language: Jupyter Notebook - Size: 6.45 MB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

dmarks84/Ind_Project_Movie-Database-SQLite
Independent Project - I joined and manipulated data from disparate tables of movie information using Python & SQLite; defined schema, created tables/views, queried data, etc. Utilized CTE's, Window Functions, and other DDL, DQL, DML, and DCL scripts.
Language: Python - Size: 2.67 MB - Last synced at: about 2 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 1

Theofilusarifin/E-Commerce-Data-Analysis-with-Elastic-Search
This project involves comprehensive e-commerce data analysis using SQLite and Elasticsearch. It starts by importing the Kaggle E-commerce dataset into SQLite for initial exploration and basic data cleaning. Then, Elasticsearch is employed for indexing and querying, enabling further analysis.
Language: Jupyter Notebook - Size: 7.08 MB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Theofilusarifin/Analyzing-eCommerce-Business-Performance-with-SQL
In any company, measuring business performance is crucial for tracking, monitoring, and evaluating the success or failure of various business processes. Therefore, this project aims to analyze the business performance of an eCommerce company, considering several business metrics: customer growth, product quality, and payment types.
Size: 64.4 MB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Gino-Freud-Hobayan/8WeekSQL_Challenge
SQL Case Studies solved using Microsoft SQL Server and PostreSQL
Size: 1.23 MB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 2 - Forks: 0

Chaitanyaprasad60/SQL-Queries
This is a list of complex SQL Queries I have practiced.
Size: 1.46 MB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

jianninapinto/COVID19_Crisis
Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.
Size: 13.1 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

tknishh/data-lemur-sql-solution
SQL solutions for DataLemur including all difficult levels.
Size: 5.86 KB - Last synced at: 3 months ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

pujaitridas/10dayschallenge
This repository hosts IVY's SQL Internship(July 2023): 10-Days Challenge, which offers participants the opportunity to practice their SQL skills through a series of progressively challenging tasks.
Size: 303 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Harkirat78/CovidAnalysis-DataExplorationSQL
SQL project that analyzes large amounts of data specifically related to Covid-19 deaths and vaccinations
Size: 23.6 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

tzelleke/postgres-notes
Personal notes on PostgreSQL
Language: Jupyter Notebook - Size: 563 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

MaxLopezSalgado/sql-playground
This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, that allow to apply basic, intermediate and advance SQL queries to different datasets.
Size: 46.9 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 1 - Forks: 0

faiyaz106/Query-performance-comparison-in-PostgreSQL
Language: Python - Size: 2.77 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

Rubina-Bansal/SQL-Projects
Size: 1.7 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

GvHemanth/RSVP_Production_SQL
Giving recommendations to the Top Indian Production team - RSVP ,for their upcoming film about to be released globally.
Size: 3.47 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

yunusbagriacik/Digital-Filters-in-Audio-Signal-Processing
Digital FIR and IIR filters with intelligible Python codes using SciPy.
Language: Jupyter Notebook - Size: 1.37 MB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 0

Nargis45/SQL_youtube
I have started a new playlist called MySQL on my YouTube channel. Watch the videos to learn SQL from scratch.
Size: 28.3 KB - Last synced at: about 2 years ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 0

graemebalint/best_hotel_prices_netherlands
A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.
Size: 2.93 KB - Last synced at: about 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

ellaclauz/SQL-FOR-DATA-ANALYSIS
SQL projects using the different functions from basic to advance
Size: 6.92 MB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

NataliaZvezdina/wib
:page_with_curl: :office: :chart: Test task for WhoIsBlogger (data analyst position) aimed at building complex SQL queries (including window functions)
Language: Python - Size: 7.81 KB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

franckbinde/dannys_diner
SQL Challenge
Size: 69.3 KB - Last synced at: 3 months ago - Pushed at: almost 3 years ago - Stars: 2 - Forks: 0

28101991SUNNY/RDBMS-and-SQL-
my learnings and practice with SQL functions
Language: Jupyter Notebook - Size: 6.86 MB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

eydelrivero/extension-functions
Extending sqlite extension-functions to support median aggregate function as a window function. See https://www.sqlite.org/contrib. Forked from https://gitlab.com/liamh/extension-functions
Language: C - Size: 46.9 KB - Last synced at: almost 2 years ago - Pushed at: over 5 years ago - Stars: 1 - Forks: 0

flapjackstan/database-code_snippets
example sql queries
Size: 6.76 MB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

etfovac/WinAPI
Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL
Language: C# - Size: 27.3 KB - Last synced at: over 2 years ago - Pushed at: over 4 years ago - Stars: 4 - Forks: 0

pablo-ferro/SQL_Advanced_practice
SQL technical cases as interview practice
Size: 9.77 KB - Last synced at: about 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

Karan-Pruthi/8-Week-SQL-Challenge
SQL Case Studies Solutions for #8WeekSQLChallenge
Size: 104 KB - Last synced at: about 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

qbart/workshop-db-03
CTEs and window functions explained for PostgreSQL
Language: Haml - Size: 24.4 KB - Last synced at: 6 days ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

Develop-Packt/Aggregate-and-Window-Functions
This module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.
Language: TSQL - Size: 9.29 MB - Last synced at: over 2 years ago - Pushed at: almost 5 years ago - Stars: 1 - Forks: 3

trajkd/Investigate-a-Relational-Database
Investigate a Relational Database (project 1 of 3 from Udacity Programming for Data Science with Python)
Language: TSQL - Size: 196 KB - Last synced at: over 2 years ago - Pushed at: about 5 years ago - Stars: 0 - Forks: 1
