GitHub topics: sql-queries
tanushree-c/SQL-Projects
A collection of hands-on SQL projects for data analysis, business insights, and reporting. Each project explores real-world datasets using SQL queries and best practices.
Size: 44.9 KB - Last synced at: 2 days ago - Pushed at: 2 days ago - Stars: 0 - Forks: 0

mukul975/mysql-mcp-server
A comprehensive Model Context Protocol (MCP) server for MySQL databases with 200+ tools for advanced database management, diagnostics, performance analysis, security auditing, and AI-powered database interactions.
Language: Python - Size: 62.5 KB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

ggommes/Data-analysis-project
This repository features SQL scripts for in-depth data analysis of a dental clinic in Brazil (2020-2025). It explores various analytical techniques, including revenue and patient trends, cumulative performance, and data segmentation, providing actionable recommendations for business growth and operational efficiency
Size: 39.1 KB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

go-jet/jet
Type safe SQL builder with code generation and automatic query result data mapping
Language: Go - Size: 6.8 MB - Last synced at: 3 days ago - Pushed at: 4 days ago - Stars: 3,284 - Forks: 154

its-ekanshi/superstore-sql-analysis
Comprehensive SQL analysis on Superstore sales data to uncover actionable insights for business growth.
Size: 1.13 MB - Last synced at: 4 days ago - Pushed at: 4 days ago - Stars: 0 - Forks: 0

its-ekanshi/SQL-Analytics-Project
Designed relational tables with primary and foreign keys, populated with sample data for real-world testing. Implemented advanced SQL techniques such as CTEs, window functions, aggregates, and filters to extract valuable insights.
Size: 12.7 KB - Last synced at: 4 days ago - Pushed at: 4 days ago - Stars: 0 - Forks: 0

IvanShestachenko/Database-technologies
Contains database modelling and setup documentation featuring several key database technologies and JPA application core that is meant to provide interface to work with the mentioned database. Produced as a duo coursework project within CTU FEE B0B36DBS - Database Systems university course.
Language: Java - Size: 1.04 MB - Last synced at: 4 days ago - Pushed at: 4 days ago - Stars: 0 - Forks: 0

satyam4235/OTT-Platform-SQL-Analytics-Project
A professional SQL analytics project for a fictional OTT streaming platform. Includes database design, ER diagram, sample data, and advanced SQL queries for user insights, movie trends, and reporting.
Size: 32.2 KB - Last synced at: 7 days ago - Pushed at: 7 days ago - Stars: 0 - Forks: 0

SyedaNimraFatima/Coffee-Shop-Sales-Analysis-SQL-PowerBI
A dynamic Power BI dashboard for analyzing sales, product trends, and customer behavior across NYC coffee shops. Built using Excel, DAX, and custom visuals to support business intelligence and decision-making.
Size: 8.33 MB - Last synced at: 7 days ago - Pushed at: 8 days ago - Stars: 0 - Forks: 0

fluent/fluent-bit
Fast and Lightweight Logs, Metrics and Traces processor for Linux, BSD, OSX and Windows
Language: C - Size: 119 MB - Last synced at: 7 days ago - Pushed at: 7 days ago - Stars: 7,064 - Forks: 1,728

yessrg/sql-server-stuff
List of useful stuff for working with SQL Server (mssql)
Size: 2.93 KB - Last synced at: 8 days ago - Pushed at: 8 days ago - Stars: 0 - Forks: 0

myusernamewastakenlol/Purrs-R-Us
Purrs-R-Us is a collaborative platform for cat lovers to share photos, stories, and tips on caring for their feline friends. Join our community to connect with other cat enthusiasts and celebrate the joys of having a purrfect companion in your life.
Size: 1000 Bytes - Last synced at: 8 days ago - Pushed at: 8 days ago - Stars: 0 - Forks: 0

thompsonmikej/SQL-Joins-in-Action-Lab
This lab provides hands-on exercises for writing SQL queries that utilize various types of JOINs to extract, analyze, and combine data from multiple related tables.
Size: 46.9 KB - Last synced at: 7 days ago - Pushed at: 9 days ago - Stars: 0 - Forks: 0

thompsonmikej/SQL-in-Action-Starter
A hands-on lab for practicing SQL queries and relational data modeling.
Size: 13.7 KB - Last synced at: 9 days ago - Pushed at: 9 days ago - Stars: 0 - Forks: 1

Tudor2223/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: 1.95 KB - Last synced at: 10 days ago - Pushed at: 10 days ago - Stars: 0 - Forks: 0

dpratt92/IBM-Data-Science-Capstone-SpaceX
Predict Falcon 9 landing success with this data science capstone project. Explore SpaceX API data, build models, and enhance decision-making. ๐๐ฆ
Language: Jupyter Notebook - Size: 13.8 MB - Last synced at: 11 days ago - Pushed at: 11 days ago - Stars: 0 - Forks: 0

gavlyukovskiy/spring-boot-data-source-decorator
Spring Boot integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuth
Language: Java - Size: 2.84 MB - Last synced at: 11 days ago - Pushed at: 11 days ago - Stars: 960 - Forks: 91

omkarshinde1711/mysql
SQL stash from LeetCode, GFG & HackerRank โ synced so you donโt have to sweat it!
Size: 3.91 KB - Last synced at: 12 days ago - Pushed at: 12 days ago - Stars: 1 - Forks: 0

mi7773/advanced_sql_data_analytics_project
A hands-on SQL project simulating data analysis using fact and dimension tables, covering trends over time, cumulative metrics, performance breakdowns, segmentation, and reporting via SQL.
Language: TSQL - Size: 829 KB - Last synced at: 14 days ago - Pushed at: 14 days ago - Stars: 0 - Forks: 0

lucianoscarpaci/SimpleDatabase-GUI
An innovative system integrating a robust database solution with a user-friendly interface to facilitate seamless record management. Leveraging the power of MySQL and MariaDB databases, alongside the convenience of phpMyAdmin for efficient administration. The deployment is streamlined using Docker.
Size: 5.86 KB - Last synced at: 7 days ago - Pushed at: 11 months ago - Stars: 1 - Forks: 0

edvin/kdbc
SQL DSL for Kotlin
Language: Kotlin - Size: 192 KB - Last synced at: about 5 hours ago - Pushed at: over 7 years ago - Stars: 45 - Forks: 6

Accenture/DBTestCompare
Application to compare results of two SQL queries
Language: Java - Size: 13.5 MB - Last synced at: 30 days ago - Pushed at: 30 days ago - Stars: 29 - Forks: 13

vishnu-t-r/sql_solved_questions
In this repository you will find SQL queries of multi-difficulty levels that can applied on to large datasets for various business requirements.
Language: TSQL - Size: 650 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 8 - Forks: 1

jackrit88/sql-data-analytics-project
Explore SQL scripts for data analytics and reporting. Perfect for data analysts and BI professionals. Boost your data exploration skills! ๐๐
Language: TSQL - Size: 6.39 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

piyush-ghavari/Climate_Analysis_Cloud
Seamless AWS S3โSnowflake integration and data loading setup for Power BI analysis.
Size: 1.03 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

ayushijani/Supply-Chain-Management
A DBMS project to manage and optimize the supply chain of a car company, covering suppliers, manufacturing, and dealer operations.
Size: 0 Bytes - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

nataliapaulino/byte-by-byte
SQL, C#, and programming exercises for learning and practice.
Language: SQL - Size: 51.8 KB - Last synced at: 19 days ago - Pushed at: about 2 months ago - Stars: 19 - Forks: 0

miyahjordan/Calbright-College-Portfolio-Projects
My portfolio projects completed in SQL at Calbright College.
Size: 52.7 KB - Last synced at: 4 days ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

cajuncoding/SqlBulkHelpers
Lightweight library for working with high performance bulk updates & materialized data in SQL Server with support for Identity columns, Annotations, Materialization from disparate systems, etc.
Language: C# - Size: 714 KB - Last synced at: 27 days ago - Pushed at: 12 months ago - Stars: 18 - Forks: 9

srujannavalkar788/Pizza_Sales_Analysis_SQL
Utilizing a combination of Excel, SQL, and Power BI, I delved into an extensive dataset comprising over 50,000 entries of pizza sales data from our business. Through meticulous data simplification and analysis, I uncovered compelling insights and illuminating trends about sales performance and customer preferences within the pizza market.
Size: 1.99 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

GuzVenegas/SQL_UDEMY
Ejercicios del curso: MySQL Workbench.
Size: 1.47 MB - Last synced at: about 23 hours ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

ptyadana/SQL-Data-Analysis-and-Visualization-Projects
SQL data analysis & visualization projects using MySQL, PostgreSQL, SQLite, Tableau, Apache Spark and pySpark.
Language: Jupyter Notebook - Size: 35.1 MB - Last synced at: 2 months ago - Pushed at: about 3 years ago - Stars: 1,436 - Forks: 553

usmana5809/Oracle-Database-Project
Oracle Database project focusing on social, financial, and university management systems. It includes SQL scripts for database creation, data insertion, and querying, along with a detailed README providing setup instructions and usage guideline
Size: 567 KB - Last synced at: about 1 month ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

blakedrumm/SCOM-Scripts-and-SQL
The scripts, tools, and queries provided here are fully compatible with System Center Operations Manager.
Language: PowerShell - Size: 226 MB - Last synced at: 2 months ago - Pushed at: 9 months ago - Stars: 83 - Forks: 35

DataWithBaraa/sql-ultimate-course
About The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world SQL
Language: TSQL - Size: 109 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 77 - Forks: 50

Marco210210/SportTech-Database-Project
Relational database project for managing sports competitions and teams, designed with conceptual and logical modeling, SQL queries, views, and triggers.
Language: PLpgSQL - Size: 1.62 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 1

virajbhutada/sql-resources
A thorough and comprehensive collection of SQL resources designed to enhance your expertise. Dive into interview preparation with Q&A, access detailed notes, and embark on thorough SQL projects with accompanying handbooks. Find quick references, insightful roadmaps, and a wealth of knowledge to elevate your SQL skills.
Size: 59.5 MB - Last synced at: about 1 month ago - Pushed at: 10 months ago - Stars: 4 - Forks: 1

JoseLVillaronga/MySQL-Admin
๐ง Curated Python scripts for MySQL administration: simplify tasks like security, backups, and performance tuning. Ready-to-use solutions for DBAs/devs to automate workflows and enforce best practices. Open-source & contributions welcome!
Language: Python - Size: 53.7 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Hifza-Khalid/SQL-Queries-Collection
๐๏ธA collection of essential SQL queries covering SELECT ๐, INSERT โ, DELETE โ, UPDATE ๐, and JOIN ๐ operations for database management and learning.
Size: 15.6 KB - Last synced at: 11 days ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Hifza-Khalid/book-management-system-sql
A Book Management System SQL project ๐ featuring tables for Authors โ๏ธ, Books ๐, Customers ๐ค, and Orders ๐. Includes sample queries for tracking book sales ๐ฐ, pricing by genre ๐ญ, and customer order history ๐ .
Size: 6.84 KB - Last synced at: about 1 month ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Erfanafshar/ecommerce-sql-db
Relational database design for a basic e-commerce system with schema definition, data insertion, and reporting queries in SQL.
Size: 120 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 2 - Forks: 1

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: 3 months ago - Pushed at: 4 months ago - Stars: 40 - Forks: 17

Buggstomper/Even-Mangament-System
A comprehensive MySQL database implementation for event planning and management with normalized schema, sample data, and complex queries.
Size: 26.4 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 1

wowinter13/real_life_interview
Some questions from real life interviews. Ruby/Rails, Golang and other backend nuances.
Size: 641 KB - Last synced at: 2 months ago - Pushed at: almost 2 years ago - Stars: 3 - Forks: 0

leandrovip/Vip.SqlQuery
Simple library for generate sql queries to MS SQL SERVER
Language: C# - Size: 71.3 KB - Last synced at: 18 days ago - Pushed at: 4 months ago - Stars: 1 - Forks: 1

Sushmashreeps10/Full-stack-development2025
Database Assessments ๐ A collection of database assessments covering SQL queries, normalization, indexing, transactions and performance optimization. Perfect for practice & skill improvement! ๐
Language: Java - Size: 5.23 MB - Last synced at: about 2 months ago - Pushed at: 4 months ago - Stars: 3 - Forks: 0

natgluons/SQL-Yelp-Dataset
SQL project analyzing Yelp and Chinook datasets with ER diagrams, query-based profiling, and beginner-friendly MySQL inferences.
Size: 1.64 MB - Last synced at: 3 days ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

Siddhant2105s/Bring-Your-Own-Device-BOYD-System
This repository contains the design and implementation of the Bring Your Own Device (BYOD) System for managing personal devices at Life Insurance Company. It includes an ERD diagram, MySQL scripts for database creation, data insertion, and queries, as well as detailed data definitions and system requirements documentation.
Size: 402 KB - Last synced at: 15 days ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

MoreSangeet/LeetCode_SQL_50
This repository contains solutions to the first 50 SQL problems on LeetCode. Each problem is solved using SQL queries, with detailed explanations and efficient approaches. These solutions aim to help users improve their SQL skills and understanding of database concepts while providing clear and well-documented code for reference.
Size: 128 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

Siddhant2105s/AirMan-Database-System
This repository contains the design and implementation of the AirMan System for managing airport operations at London Biggin Hill Airport. It includes an ERD diagram, MySQL scripts for database creation, data insertion, and queries, as well as detailed data definitions and system requirements documentation.
Size: 0 Bytes - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

REDWAN227/sql-ultimate-course
About The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world SQL
Language: TSQL - Size: 32.3 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

jmgold/SQL-Queries
Collection of SQL queries for use with Sierra ILS. Created and maintained by Jeremy Goldstein for test purposes only. Use at your own risk. Not supported by the Minuteman Library Network.
Language: Python - Size: 6.71 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 30 - Forks: 7

jschaf/pggen
Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
Language: Go - Size: 1.02 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 294 - Forks: 29

alexeyabel/user_backend_sql_raw
User management and authentication through arbitrary SQL queries for Nextcloud
Language: PHP - Size: 596 KB - Last synced at: about 2 months ago - Pushed at: about 1 year ago - Stars: 21 - Forks: 15

rumana-amin/sql-data-warehouse-and-analytics-project
Building a data warehouse using with SQL Server, including ETL processes, data modeling, and analytics
Language: TSQL - Size: 439 KB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

Madhuresh2011/Gen-Z-project-Using-SQL
Gen-Z career aspiration response data analysis ,It aims to provide actionable strategies for businesses targeting this influential generation.
Size: 4.46 MB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

shafaq-aslam/data-analytics-dairy
A comprehensive repository for Data Analytics learning and projects. It includes MySQL, Python, Power BI, Tableau, and Excel. The goal is to analyze data, generate insights, and create compelling visualizations for real-world datasets.
Size: 20.5 KB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

mahmoudwal27/SQL-Data-Analysis
This project demonstrates SQL operations for managing student enrollments, including creating tables, inserting data, updating records, and running queries to analyze student and course information. It showcases skills in data manipulation, aggregation, and advanced query formulation.
Size: 9.77 KB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

naninsv/Zomato-Data-Analysis
Comprehensive SQL-based analysis of Zomato's food delivery data. Covers customer behavior, restaurant performance, delivery efficiency, seasonal trends, and revenue optimization using advanced SQL queries.
Size: 2.48 MB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

art2url/sql-50
๐๏ธ A collection of SQL solutions for LeetCode problems, designed to help crack SQL interviews with 50 essential queries.
Language: SQL - Size: 29.3 KB - Last synced at: 2 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

hars310/insta-db-project
This repository contains SQL queries used to analyze an Instagram-like database. The queries help in deriving insights about user behavior, engagement, and activity patterns.
Size: 108 KB - Last synced at: 23 days ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

vanshuchaudhary/Retail-sale
project uses MySQL to analyze retail sales data, focusing on customer behavior, sales trends, and product performance. The dataset includes transactions, customer demographics, and purchase details, helping businesses optimize strategies. Key Insights: ๐ Revenue Analysis โ Total sales, top-spending customers ๐ Sales Trends
Size: 6.84 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

IsaacZhang4/Java-App-Course-Scheduler
GUI Java App Course Scheduler that uses Derby Database and SQL to manage the course/enrollment data
Size: 139 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

invictusaman/Socioeconomic-Indicators-in-Chicago-SQL-Python
This project displays how to create a database connection in notebook, update database using python and how to run Python program and SQL queries together. It uses SQLite and Chicago dataset for analysis.
Language: Jupyter Notebook - Size: 43.9 KB - Last synced at: 5 months ago - Pushed at: 11 months ago - Stars: 2 - Forks: 0

sxhixho/Preprocessing_Analysis
A project that demonstrates data storage, preprocessing, and analysis using tools like HDFS, Apache Pig, and Hive, executed in an Azure virtual machine environment. The project includes cleaning and aggregating a Spotify dataset and running Hive queries to extract meaningful insights.
Size: 4.24 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

bitman09/Dune-Analytics
Dune Analytics: A collection of SQL queries and interactive dashboards created on Dune for analyzing blockchain data, including DeFi protocols, NFTs, token transfers, and DAO activities.
Size: 1.95 KB - Last synced at: 2 months ago - Pushed at: 8 months ago - Stars: 2 - 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: 20 days ago - Pushed at: 6 months ago - Stars: 1 - Forks: 0

VaishnaviNagrale/Data_Structures_and_Algorithms
Repository for all my standard DSA question codes
Language: C++ - Size: 197 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

CodeHerUniverse/Purrs-R-Us
Size: 2.94 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 1 - Forks: 0

Sabdikay/SQL-Project
This project demonstrates how to analyze a restaurant database. Data was organized into a MySQL 8.0 database using MySQL Workbench/Navicat, then migrated to Google CloudMySQL. Looker Studio is used to visualize insights.The project showcases an end-to-end workflow: database design, SQL querying, and interactive reporting
Language: PLpgSQL - Size: 516 KB - Last synced at: 5 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

nidhiupman568/MY-SQL-PROBLEM-SOLVED
๐Welcome to a curated ๐ collection ๐ of solved ๐ ๏ธ MySQL ๐พ interview ๐ฌ problems โ from LeetCode ๐ก. ๐๐ This section ๐ showcases ๐ key questions โ and their solutions ๐ก, providing ๐ a valuable ๐ ๏ธ resource ๐ for anyone ๐ฌ preparing ๐ ๏ธ for SQL ๐พ interviews ๐ฌ. ๐
Size: 64.5 KB - Last synced at: 4 months ago - Pushed at: about 1 year ago - Stars: 3 - Forks: 0

zelosleone/Dune-Dashboards
This codebase contains SQL queries for analyzing blockchain network metrics across different chains using Dune Analytics, focusing on transaction patterns, wallet behaviors, smart contract usage, and network activity trends.
Size: 9.77 KB - Last synced at: 4 months ago - Pushed at: 8 months ago - Stars: 3 - Forks: 0

Arif264Shaik/Amazon-sales-analysis
The project analyzed Amazon's sales data from three branches using a dataset of 1,000 transactions. It included data wrangling, feature engineering for insights, and exploratory data analysis (EDA) to identify top products and revenue trends, using SQL and Excel.
Size: 1.35 MB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

rramoscabral/DP-080---Training---Querying-Data-with-Microsoft-Transact-SQL
DP-080 - Training - Querying Data with Microsoft Transact-SQL
Size: 114 KB - Last synced at: 4 months ago - Pushed at: 10 months ago - Stars: 2 - Forks: 0

devhns/HNS_SQLPractices
5 different datasets' scenarios and +50 SQL queries
Language: SQL - Size: 23.4 KB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

ArpitAswal/Android_Music_Player
Music Player app is designed to enhance user experience with a smooth and flexible interface, providing multiple ways to play and manage music. Transitions between screens are made seamless with sliding animations, offering a visually appealing and user-friendly experience.
Language: Kotlin - Size: 324 KB - Last synced at: about 1 month ago - Pushed at: 11 months ago - Stars: 1 - Forks: 0

Gaurav-Swami/sql-queries
postgresql queries for practice
Size: 0 Bytes - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

vvamu/PizzaDelivery
Practice project - WebApi to delivery pizza. 07.2023
Language: C# - Size: 1.97 MB - Last synced at: 4 months ago - Pushed at: about 1 year ago - Stars: 1 - Forks: 0

AAlkiyumi/Project-2-AWS-EC2-Web-Application-with-Flask-and-SQLite
This lab involves creating a Flask web app hosted on AWS EC2. It features user registration, login functionality, and data storage using SQLite. The app supports file uploads, user form submissions, and authentication. Apache with mod_wsgi is used to deploy the app, and SQL queries manage interactions with the database.
Language: Python - Size: 13.2 MB - Last synced at: 4 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

virajbhutada/music-store-data-analysis-sql
Hands-on SQL data analysis project for music store. Enhance proficiency with database queries. Ideal for practitioners seeking real-world analytics experience. Gain insights into customer behavior, revenue trends, and genre preferences, empowering strategic decision-making in the music industry. Explore the project for a rich learning experience.
Size: 35.3 MB - Last synced at: about 2 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

aleja-ren/SQL_Queries
This repository contains various SQL queries created as part of the Databases course at the University of Valladolid. Each query explores different SQL functions and commands to address common database management and analysis tasks.
Size: 8.79 KB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Romeh/spring-boot-ignite
Show case for how to integrate apache ignite with spring boot plus using the durable memory feature and sql queries over ignite in memory caches
Language: Java - Size: 516 KB - Last synced at: 4 months ago - Pushed at: almost 7 years ago - Stars: 49 - Forks: 40

Tapas-Gope/Adventure-Works
This project analyzes sales data for AdventureWorks, focusing on revenue, customer segments, and product performance. The dashboard provides insights into top-selling products, sales by region, and customer trends across multiple years. It helps in identifying sales opportunities and optimizing marketing strategies.
Language: TSQL - Size: 1.28 MB - Last synced at: 4 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

JawadSher/SQL-Problems-Solutions-HackerRank
Welcome to the HackerRank SQL Problems repository! This collection features a variety of SQL challenges from HackerRank, designed to help you sharpen your SQL skills. Whether you're a beginner or an experienced developer, you'll find solutions and explanations for everything from basic queries to advanced data manipulation.
Size: 140 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

filip-kustura/sql-database-assignment
Database Systems course project, completed in two parts: designing an arbitrary relational database and implementing it by creating, loading and querying data to meet specified criteria. Each query was accompanied by detailed explanations. Developed during the spring of 2020.
Size: 714 KB - Last synced at: 4 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

zeeshan2k2/MySQL-Notes
SQL notes
Size: 47.9 KB - Last synced at: 2 days ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

m-sarabi/DataPatternX
DataPatternX is a starter kit for seamless data pattern analysis. It connects to a PostgreSQL database (e.g., Neon Serverless Postgres), retrieves complex data patterns, and plots charts. The kit includes modules for database connection, query execution, chart plotting, and easy CLI tools for efficient interaction.
Language: Python - Size: 33.2 KB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 1 - Forks: 0

lauracarpaciu/SQL-Exercises
Size: 31.3 KB - Last synced at: 11 months ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

michaellaephillips/SQLCaseStudy
SQLite project working with data from a "resort"
Language: Jupyter Notebook - Size: 71.3 KB - Last synced at: 11 months ago - Pushed at: over 4 years ago - Stars: 0 - Forks: 0

Jaiswal0786/MySQL-database-using-IMDb-dataset
This repository contains a project that involves creating and managing a MySQL database using the IMDb dataset. It includes scripts and instructions for setting up the database, importing the IMDb dataset, and performing various queries to extract meaningful insights from the data.
Language: Jupyter Notebook - Size: 1.08 MB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 1

dbquerywatch/dbquerywatch
Shift-lefting the detection of slow queries
Language: Java - Size: 742 KB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 4 - Forks: 0

annaxyhu/sql-101
This repository contains my study notes and learning resources for SQL. Here, I document key concepts, queries, and best practices as I progress through my SQL learning journey.
Size: 49.8 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

lnvaldez/pokemon-database
A comprehensive SQL-based project for managing a Pokรฉmon database. Includes scripts for creating, reading, updating, and deleting trainers, Pokรฉmon, battles, and trainer-Pokรฉmon relationships.
Language: TSQL - Size: 28.3 KB - Last synced at: 5 months ago - Pushed at: about 1 year ago - Stars: 1 - Forks: 0

ptjahjadi/Department-Store-Database
Using SQL queries to select various data from a hypothetical big department store database.
Language: TSQL - Size: 591 KB - Last synced at: about 1 year ago - Pushed at: over 5 years ago - Stars: 1 - Forks: 1

JcoderPaul/JDBC_Practice
Examples of work with JDBC. DAO, CRUD concept. Simple SQL and Prepared Statement queries. Description in doc folder. Section cheat sheet. For memory!
Language: Java - Size: 1.13 MB - Last synced at: 5 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

martyna-adam/Dolce-Plaza-SQL-Database
A repository for my final project for the Code First Girls Introduction to Data & SQL course.
Size: 121 KB - Last synced at: about 1 year ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

soareseric/learn-sql-for-data-analysis
I am sharing foundational concepts of SQL, just like I am doing with Python, as part of my journey to become a Data Analyst. These are topics that I have studied and continue to study.
Size: 11.7 KB - Last synced at: 12 months ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 1

DarkLite1/sql-execute-query-file
Execute .SQL files in batch
Language: PowerShell - Size: 106 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 1 - Forks: 0

rishav21r/AirMan-Database-System
This repository contains the design and implementation of the AirMan System for managing airport operations at London Biggin Hill Airport. It includes an ERD diagram, MySQL scripts for database creation, data insertion, and queries, as well as detailed data definitions and system requirements documentation.
Size: 1.41 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

rishav21r/LiBOYD-System-MySQL-Project
A comprehensive implementation of the Life Insurance Co. BYOD system. Includes ERD, MySQL scripts for database creation and population, detailed data definitions, normalization documentation, and SQL queries for IT management analytics. Demonstrates best practices in database design and management.
Size: 787 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0
