GitHub topics: cte | Ecosyste.ms: Repos

Tynoee/nashville-housing-data-cleaning

This repository contains SQL scripts used to clean and prepare the Nashville Housing dataset for analysis.

Language: TSQL - Size: 5.64 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

Blazebit/blaze-persistence

Rich Criteria API for JPA providers

Language: Java - Size: 35 MB - Last synced at: 8 days ago - Pushed at: 2 months ago - Stars: 790 - Forks: 96

VeronSheva/HR_dashboards

Interactive HR dashboard using Tableau & MySQL – explore employee trends, performance, attrition, and salary insights.

Size: 8.56 MB - Last synced at: 3 days ago - Pushed at: 8 days ago - Stars: 0 - Forks: 0

Hercules-NET/ZeusFiscal

A Principal Biblioteca em C# para Emissão e Impressão de NFe, NFCe, MDF-e e CT-e

Language: C# - Size: 34.1 MB - Last synced at: 1 day ago - Pushed at: about 1 month ago - Stars: 104 - Forks: 50

VitalinaZlo/IT-planeta2024_SberTex_PostgreSQL

Проект предназначен для нахождения маршрута в базе данных PostgreSQL с максимальным количеством станций в заданные даты, учитывая расписание поездов, условия пересадок и ограничения.

Size: 1.25 MB - Last synced at: 11 days ago - Pushed at: 11 days ago - Stars: 0 - Forks: 0

ProjetoACBr/ACBr

Mirror não oficial do Projeto ACBr

Language: Pascal - Size: 1.1 GB - Last synced at: 12 days ago - Pushed at: 12 days ago - Stars: 63 - Forks: 33

OCA/l10n-brazil

Localização brasileira oficial do Odoo.

Language: Python - Size: 119 MB - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 277 - Forks: 255

ZeusAutomacao/DFe.NET

Biblioteca para Geração de NFe(2.0, 3.10 e 4.0) e NFCe(3.10 e 4.0) e consumo dos serviços necessários à sua manutenção, conforme descritos em http://www.nfe.fazenda.gov.br/portal/principal.aspx

Language: C# - Size: 37.8 MB - Last synced at: 10 days ago - Pushed at: 10 days ago - Stars: 770 - Forks: 485

WillianMonteiro23/projetos-sql

Esta repositório contém projetos que utilizam SQL para análise de dados. Cada projeto explora conjuntos de dados, realizando consultas para extrair insights, transformar dados e visualizar resultados, demonstrando habilidades em gerenciamento de banco de dados e otimização de consultas.

Language: TSQL - Size: 60.8 MB - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 0 - Forks: 0

akretion/nfelib

nfelib - bindings Python para e ler e gerir XML de NF-e, NFS-e nacional, CT-e, MDF-e, BP-e

Language: Python - Size: 3.54 MB - Last synced at: 4 days ago - Pushed at: about 1 month ago - Stars: 159 - Forks: 60

somnambulist-tech/cte-builder

Common Table Expression builder that uses Doctrine DBAL

Language: PHP - Size: 62.5 KB - Last synced at: 10 days ago - Pushed at: about 1 year ago - Stars: 22 - Forks: 2

Shriyaak/Retail-Sales-Analysis

Size: 44.9 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

Samuel-Oliveira/Java_CTe

Projeto Open Source Java - CTe

Language: Java - Size: 130 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 80 - Forks: 40

kjchrz03/sql_data_requests

A sample of play data requests showcasing my intermediate SQL data skills.

Size: 13.7 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

husskhosravi/major_baseball_sql

SQL analysis of Major League Baseball data exploring player statistics, team performance and historical trends

Size: 1.53 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

wmixvideo/nfe

Nota Fiscal Eletrônica em Java.

Language: Java - Size: 20.9 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 675 - Forks: 381

Eficaz-Sistemas/EficazFramework.SPED

Biblioteca para leitura, auditoria e escrita das obrigações acessórias, documentos e escriturações do projeto SPED (Federal, B2G), Operações Financeiras (B2B) e documentos fiscais eletrônicos (NFe, CTe, NFSe).

Language: C# - Size: 4.27 MB - Last synced at: 8 days ago - Pushed at: about 1 month ago - Stars: 16 - Forks: 6

Mandeep04Sharma/Walmart-Sales-Performance-Analysis

This project analyzes historical transaction data from Walmart stores using advanced SQL queries to uncover insights related to sales performance, customer behavior, and operational efficiency. By leveraging SQL techniques, the project covers various aspects such as branch performance, product profitability, customer segmentation, and sales trends.

Size: 13.2 MB - Last synced at: 4 days ago - Pushed at: about 1 month ago - Stars: 1 - Forks: 0

Mandeep04Sharma/Pizza-Hut-Sales-Analysis---SQL

This SQL-based project analyzes Pizza Hut's sales data to uncover insights about customer behavior, product performance, and store efficiency. It focuses on optimizing decision-making by leveraging advanced SQL techniques.

Size: 5.52 MB - Last synced at: 4 days ago - Pushed at: about 1 month ago - Stars: 1 - Forks: 0

OmenApps/django-postgresql-dag

Directed Acyclic Graphs with a variety of methods for both Nodes and Edges, and multiple exports (NetworkX, Pandas, etc). This project is the foundation for a commercial product, so expect regular improvements. PR's and other contributions are welcomed.

Language: Python - Size: 139 KB - Last synced at: 3 days ago - Pushed at: 2 months ago - Stars: 44 - Forks: 5

kskmemory/SQL-Advance-Data-Analytics-Project-by-using-CTE-and-Window-Functions

SQL Advance Data Analytics Project by using CTE and Window Functions

Size: 3.27 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

matthiask/django-cte-forest

django-cte-forest implements efficient adjacency list trees using Django and PostgreSQL Common Table Expressions (CTE).

Language: Python - Size: 144 KB - Last synced at: 8 days ago - Pushed at: over 1 year ago - Stars: 28 - Forks: 3

nikhilbordekar/SQL-Practice

"SQL Practice" is a project that offers opportunities to enhance SQL skills. It provides a material for SQL enthusiasts to work on a variety of SQL queries and challenges, helping them become more proficient in database querying and management.

Language: Jupyter Notebook - Size: 15.9 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 1 - Forks: 1

riju18/Dashing-Datawarehouse-dbt

Design the Data Warehouse with minimalistic code.

Size: 758 KB - Last synced at: 23 days ago - Pushed at: about 2 months ago - Stars: 3 - Forks: 1

Subash-d/Shiv-restaurant

Analyze a restaurant's new menu performance using MySQL. Explore `menu_items` and `order_details` tables to identify popular items, customer preferences, and revenue insights. Includes SQL queries, database schema, and sample data.

Size: 118 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

nuno-faria/tetris-sql

Using SQL's Turing Completeness to Build Tetris

Language: PLpgSQL - Size: 322 KB - Last synced at: 2 months ago - Pushed at: 9 months ago - Stars: 946 - Forks: 38

data-analyst77/Rockbuster-Stealth-Analysis

Data-driven strategy for online streaming, analyzing top/bottom-performing movies and customer trends (regions, lifetime value). Uses SQL & PostgreSQL for querying, filtering, cleaning, summarizing, joins, subqueries, and CTEs to uncover key insights for business growth.

Size: 1.62 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 1 - 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

piotr-yuxuan/cte2dbt

Tools with batteries included to extract CTE from a large SQL query and split them iteratively into dbt models.

Language: Python - Size: 533 KB - Last synced at: about 7 hours ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

ShaliniVerma21/MySQL-Queries-and-Excersizes-Batch13thJan-2025

Designed to help students and beginners build a solid foundation in database management and SQL. 🌟 📘 Structured Learning: Progress day by day with clear, organized exercises. 🎯 Practical Application: Learn SQL skills for academic, project, and professional needs. 💡 Collaborative Space: Share and enhance your knowledge with a growing community.

Size: 115 KB - Last synced at: 2 months ago - Pushed at: 3 months ago - Stars: 2 - Forks: 0

saiteja007-mv/-Target-Brazil-Ecommerce-Data-Analysis-using-SQL

📊 Target Brazil E-commerce Data Analysis - This project analyzes 100K+ orders from Target Brazil (2016-2018) using BigQuery SQL to extract insights on regional expansion, shipping, payments, and customer trends. 🚀 Leveraging CTEs, window functions & joins, it provides data-driven recommendations for business growth. 📈💡

Size: 29.4 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 1 - Forks: 1

netojoao85/SQL

🔎 Database querying

Language: HTML - Size: 8.51 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

LorinczAkos/SQL-Projects

This is a collection of my SQL scripts that I wrote and were approved through my course with GoIT Romania Data Analyst course

Size: 14.6 KB - Last synced at: 2 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

elkronos/SQL_Portfolio

Examples of SQL scripts. Includes templates for admin (SQL server) and data cleaning, as well as scripts designed for creating a mock database, illustrating triggers, common table expressions, analysis, and ETL.

Language: TSQL - Size: 48.8 KB - Last synced at: 2 months ago - Pushed at: over 1 year ago - Stars: 3 - Forks: 1

Owuor7/Covid-19-SQL-Analysis-

This repository provides a structured SQL analysis for COVID-19 datasets, helping data enthusiasts and analysts derive actionable insights

Size: 4.88 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

frones/ACBr

Projeto ACBr - O branch master é um repositório espelho do SVN original (svn://svn.code.sf.net/p/acbr/code/trunk2), criado e mantido com git-svn.

Language: Pascal - Size: 1010 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 160 - Forks: 155

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: 4 months ago - Stars: 1 - Forks: 0

codewithjaspreet/Sql

Advanced SQL - Discover sequential, step-by-step explanations and solutions, accompanied by the necessary database creation codes, available on Ankit Bansal Sir's YouTube channel for SQL. Give it a ⭐ and stay tuned for more updates!

Size: 146 KB - Last synced at: about 1 month ago - Pushed at: over 1 year ago - Stars: 22 - Forks: 3

sayed-ashfaq/Target-SQL

In this project, I analyzed Target company's data using SQL in BigQuery, focusing on data extraction, manipulation, and performing various analytical queries to derive insights.

Size: 2.16 MB - Last synced at: about 2 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

ranvikhalar/sql Fork of UofT-DSI/sql

Language: HTML - Size: 325 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

iamkirankumaryadav/SQL

Structured Query Language

Size: 7.02 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

DebjyotiSaha/Hands-On-SQL

My Learning Path towards SQL

Language: Jupyter Notebook - Size: 12.7 KB - Last synced at: about 2 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

tecnospeed/plugnotas-php

Pacote para integração com o Plugnotas

Language: PHP - Size: 155 KB - Last synced at: 17 days ago - Pushed at: about 2 years ago - Stars: 22 - Forks: 17

Shitalwaghmare183/E-commerce-database

This repository contains a comprehensive database solution for an e-commerce platform, featuring key data categories . It includes various SQL queries for data retrieval and analysis, along with a downloadable dataset for exploration. Perfect for understanding e-commerce operations and enhancing database skills.

Size: 161 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

JoGMG/primed-ehealth-internship

Tasks as Software Developer Intern at Primed E-health

Language: HTML - Size: 4.69 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

arksouthern/data-cynical

The interactive SQL editor inspired by my all-time favorite, SSMS.

Language: TypeScript - Size: 24.4 KB - Last synced at: about 2 months ago - Pushed at: 7 months ago - Stars: 1 - Forks: 0

islamsamy214/learning-pgsql

Learning PostgreSQL: A Comprehensive Cheat Sheet

Language: PLpgSQL - Size: 164 KB - Last synced at: 3 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

AnoshZahir/sql-project-data-job-analysis

SQL queries developed as part of a data analysis project. Includes analysis of job data, queries for insights into job categories, salaries, and customer behavior. Techniques used include JOINS, CTEs, subqueries, and aggregate functions. Inspired by DataNerd's YouTube tutorial: https://www.youtube.com/watch?v=7mz73uXD9DA

Language: PLpgSQL - Size: 19.1 MB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

AllanOtieno254/SQL-TUTORIAL-Mastery-Guide--practicle-from-Beginner-To-Intermmediate-To-Advance

A comprehensive guide to mastering SQL, covering topics from basic commands to advanced techniques. This repository includes practical SQL examples, sample data files, and visual aids

Language: TSQL - Size: 134 KB - Last synced at: 14 days ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

amol004/Rotten-Tomatoes-movies-analysis-SQL

This repository contains a SQL case study focusing on a movie dataset sourced from Kaggle. The dataset provides detailed information about movies, including various metrics on critic and audience ratings.

Size: 3.62 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

JohnOlutubo/influencer-marketing-analysis

This project extracts and cleans raw YouTube data from excel-csv (Kaggle) through SQL and identifies the top-performing UK-based Influencers. Data Stack: Excel | Microsoft SQL Server | Power BI

Language: TSQL - Size: 10.2 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

dBalag/Chinook

The Chinook Data Analysis Project leverages PostgreSQL, Python, and Google Spreadsheets to explore and analyze the Chinook music store database. Insights will be presented through Tableau Dashboards and Stories. Stay tuned for updates as the project evolves.

Language: Jupyter Notebook - Size: 8.09 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 1 - Forks: 1

teejay-tems/Restaurant-Orders-Analysis

This project analyzes a quarter's worth of orders from a restaurant serving international cuisine, focusing on order details, item types, and pricing. The project aims to equip the restaurant with actionable insights to optimize its menu and enhance overall sales performance.

Size: 866 KB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

victor-malheiro/sql_portfolio_project

Analysis of Covid-19 related deaths and vaccinations using SQL

Language: TSQL - Size: 37.2 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

MoonmoonSamal/Customer_Purchase_Behavior_Analysis

Customer purchase analysis with SQL, Python, and PowerBI

Language: Jupyter Notebook - Size: 9.6 MB - Last synced at: 2 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

MoonmoonSamal/Cars24

Advanced SQL Analysis for Cars24 Sales Insights

Size: 2.12 MB - Last synced at: 3 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

PauloPenalva/Java_MDFe

Biblioteca Java para consumo do WebService de MDF-e

Language: Java - Size: 183 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 6 - Forks: 0

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

amanjot-git/analytics-projects-with-SQL

Solving Real World Data Problems with SQL

Size: 59.6 KB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 1 - Forks: 0

SampathVSS/DataAnalysis-IPL-Datasets-2008-to-2017-MySQL

Analysis was executed using MySQL on the IPL granular datasets which was available for the period 2008 to 2017

Size: 24.4 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

VaishnaviRThakur/Health-Analysis-Dashboard

This project aims to provide the insights into OCD patients health

Size: 97.7 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

riasingh16/Data-Cleaning-and-EDA-Project

Data Cleaning and Exploratory Data Analysis with SQL in MySQL Workbench

Size: 3.48 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

ruchi020897/Strategic_Marketing_for_Personal_Loans_using_Python_and_SQL.s

Analysed the bank's personal loan data using Python and SQL to boost campaign success, trim costs, and strengthen customer retention, leading to increased revenue growth.

Language: Jupyter Notebook - Size: 149 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

lawal-hash/alt-exam-poc Fork of JesuFemi-O/alt-exam-poc

Alt school Fall semester DE exam questions

Size: 3.39 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0