Sql projects github. GitHub community articles Repositories.

Sql projects github As you have a brief idea about SQL, let us discuss some of the best project ideas for SQL that can help you as a beginner. An SQL Project for Data Analysis using Pizza sales Dataset. Users can clone the Dec 13, 2023 · Project 1: title : Library System; Description: The library system is an organized database that manages books, authors, and patrons. Feb 12, 2024 · Contributions to the project are welcome via issues, feature requests, and pull requests. sql sql-server t-sql ssdt azure-sql azure-sql-db sql-project Updated Jul 18, 2022; DVD-Rental SQL Project DVD Rental is a a PostgreSQL sample database given in PostgreSQL Official Website. Further analysis can explore the nature of transactions with this client for strategic planning. With further practice, you can explore more complex SQL projects on GitHub, introducing advanced queries and handling large About. - swaapnaa/SQL-PROJECTS This data analyst portfolio project demonstrates the ability to design a relational database, develop SQL queries to analyze the data and create dashboards to visualize the insights. A College Management System using SQL is a database-driven software that helps colleges and universities manage student information, course schedules, faculty records, and administrative tasks. Topics Trending Collections Enterprise Enterprise platform. I have used DVD rental database and retrieve a clear and simple output using PostgreSQL, saved output into . SQL Project. GitHub is where people build software. Each project includes detailed SQL queries and analysis, focusing on different datasets and domains. ; 5 Detailed Tables: Comprehensive datasets with over 1 million rows, including sales, stores, product This project will extract, analyze website traffic and performance data from the eCommerce database to quantify the company’s growth and tell story of it. The best idea to know something in depth is to work on related project ideas. Contribute to missochan/cs50-SQL development by creating an account on GitHub. The data is sourced from the U. Skip to content. In Solution Explorer, right-click on an Integration Services project and select Properties to open the property pages for the project. : This project aims to analyze and visualize the sales data for Retail and Food Services in the U. Write GitHub community articles SQL-Project---Social-Media-Analysis "Social Media Analytics Project: Designed and implemented a comprehensive database to analyze user engagement and content trends on a social media platform. The languages we used are SQL and PL/SQL. This tool has the best interface for my needs and has easy editing features. These are various solutions for Microsoft SQL Server - Microsoft SQL Server Projects. ; Data Modeling: Developing fact and dimension tables optimized for analytical queries. An SQL project using basic/intermediate SQL practices with one column of English words. You can examine the dataset with SQL and help the store understand its business growth by answering simple questions. Will also output the violated rules in an html report. A collection of SQL-related projects, including database design, query optimization, data manipulation, and various practice exercises. Dec 12, 2024 · This project showcases the development of a comprehensive Library Management System utilizing Structured Query Language (SQL). XML. sql - A school project used to answer a business question for a theoretical DVD rental business. Welcome to my SQL projects! New Wheels Project. We have 10 ad-hoc requests which we need to execute. The project involves setting up a retail sales database, performing exploratory data analysis (EDA), and answering specific business questions Feb 7, 2022 · In this repository you'll find the the sql code I used to clean and preprocess the data, as well as the sql code I wrote to get some insights from the data. md. Dataset Files: Optionally includes dataset files, if permitted. AI-powered developer platform Available add-ons In this project, you can do the following: Add new student. SqlServer. The objectives, datasets, code, and results can all be found within this repository. Rules. Write a query that returns one city that has the highest sum of invoice totals. 什么是GitHub上的SQL项目？ GitHub上的SQL项目通常是包含SQL查询、数据库结构和相关文档的开源项目。这些项目可以用于学习、练习和实际应用。 2. 🐍 Python Data Analysis: Explore Python scripts and Jupyter notebooks for data cleaning, exploration, and advanced analytics. NET Conf 2024 session Next-gen Explore a collection of my SQL projects, each designed to showcase the power of database querying, data manipulation, and relational database management. ; Analytics & Reporting: Creating SQL-based reports Apr 27, 2024 · Healthcare Data Management SQL Project. Project Structure: SQL Scripts: Contains SQL scripts used for data manipulation and analysis. The project includes detailed examples of various SQL operations, from basic data manipulation to advanced analytics. csv file and GitHub is where people build software. Sign in Useful links, scripts, tools and best practice for Microsoft SQL Server Database. However, contributions are welcome! If you have suggestions to improve the exercises, find errors in the queries or procedures, or have ideas for adding new features, I encourage you to Nov 10, 2023 · This is an integration project that creates a user-friendly User Interface with Tkinter enabling SQL database manipulation. Ever wondered which genres are thriving or how Netflix's catalog has SQL code for data cleaning and analysis in Nashville Housing project - MohanAnalytics2/Data-Cleaning-SQL-Projects Explore my comprehensive portfolio of SQL projects, showcasing diverse applications of database management and analytics, all conveniently hosted in one location on GitHub - Sk2195/SQL-Portfolio-Projects Nov 18, 2017 · More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. This project leverages SQL to perform various analyses and generate insights related to finance and market data. - aravindbc/Data-Analysis-Projects More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. For investors, I calculated user engagement metrics and flagged potential bot accounts. Features include OCR-based data extraction, machine learning for transaction categorization, Azure SQL database integration, and PowerBI Cleaned and transformed the data using SQL queries, including JOIN, CTE, and aggregation functions. Explore interactive dashboards, insightful visualizations, and efficient database querying techniques. Updated Dec 8, 2022; C#; Scripts SQL para criação e manipulação de tabelas. As you have a brief idea about SQL, let us discuss Jun 10, 2024 · Learn SQL and database management with free resources from GitHub. Sign in mysql php sql php7 course-project database-management php-project hostel-management-system hostel-room-allotment dbms-project. The project is open-source and distributed under an appropriate license (mention the chosen license). SQL Querying: Performed complex SQL queries for insights. Data Retrieval: Write an SQL query to retrieve the total weekly sales for each department in each store. Navigation Menu mysql python sql database tkinter management-system dbms-project employee-management-system mysql-project sql-project frontend-backend-db-project. These projects aim to uncover insights, trends, and metrics from data, showcasing the power of SQL in data analysis. Documentation: Includes detailed documentation explaining SQL queries and insights derived from the analysis. Phase 1 folder is the detailed description about supply chain management, phase Jun 10, 2024 · SQL Music Store Analysis Project by rishabhnmishra . These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc. This repository has a set of projects and exercises that showcases my skills as a Data Professional, who is comfy in data analysis and science using SQL, EXCEL, and, POWERBI - Oct 30, 2023 · Welcome to the Finance and Market Analytics project repository. These projects demonstrate my proficiency in SQL and my capacity to analyze complex data. r sql-server powershell sql-server-database awesome-list tsql t-sql microsoft-sql sql This project involves a comprehensive analysis of Netflix's movies and TV shows data using SQL. It features solid transaction support, relations, read replication and more. This project publishes a T-SQL for Microsoft SQL Server as the target query language. SQL Queries and Analysis: Wrote complex SQL queries to analyze budget variance, project performance, and employee allocation. Below, you’ll find a detailed breakdown of the project structure, SQL queries, and key insights derived from the data analysis. Leveraging SQL for data processing and Power BI for visualization, the analysis aims to deliver actionable insights into loan repayment trends, default probabilities, and customer segmentation. The dataset, sourced from nature. Jan 13, 2025 · This project showcases advanced SQL querying techniques through the analysis of over 1 million rows of Apple retail sales data. Sharpen SQL skills, gain hands-on experience in practical data scenarios. More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. It covers creating tables for branches, employees, members, Contribute to NoshabaNoreen/SQL-Projects development by creating an account on GitHub. Check out the GitHub repository to see my work. The first project completed involves filtering and altering employee information for a fictitious company. Backup files are not needed, # because we have git ;-) _UpgradeReport_Files / Backup * / UpgradeLog *. 📊 This repository serves as a valuable resource for SQL practitioners, offering a variety of case studies Nov 1, 2024 · GitHub is where people build software. Sorting Data: Organizing query results with ORDER BY for 🐸 Various scripts I use for SQL Server databases. - itiksha/SQL-Project SqlServer. ChatGPT - I used ChatGPT to generate data for this project to ensure the values be fictional. Excel - I used Excel to store the generated data prior Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, # Backup & report files from converting an old project file # to a newer Visual Studio version. The dataset provides comprehensive information crucial for analysis, while the SQL script encompasses meticulously crafted queries for extracting valuable insights. Navigation Menu Demo projects with document and SQL Oct 7, 2024 · Project Overview Welcome to the Netflix Data Explorer! This project dives deep into Netflix's vast collection of shows and movies using SQL to uncover intriguing insights about content trends, genre dominance, and global reach. net core project (*. Find and fix vulnerabilities Actions. About. Create a new database for the project. This project includes Feb 29, 2024 · This repository contains data analysis projects showcasing proficiency in Power BI and SQL. 📈 Power BI Dashboards: Visualize data with interactive Power BI dashboards, providing actionable insights. Contribute to NeuralNeha/SQL-Projects development by creating an account on GitHub. Automate any Mar 29, 2024 · This project demonstrates my ability to design and implement a database schema, manage inventory data, track sales, generate reports, and follow industry-standard practices for data integrity, validation, and documentation. It will also help you understand database structures, which are crucial for software development. Star 0. Follow the below-mentioned ideas to make the best projects with this language. The Online Bookstore SQL Project is a database system designed to manage books, customers, and orders efficiently. Get started with SQL database programming. It encompasses functionalities such as employee information storage, attendance tracking, payroll management, and performance evaluation. Database: In the "database" folder, you'll Dec 13, 2023 · SQL Server 2019. So we can reduce the risk or avoid this attack happening through optimizing our application code. . The project can be used as a template for other data analysts working on similar projects. Updated End-to-End Data Analytics Project using Python and SQL This project covers the full data analytics pipeline: Data Acquisition: Downloaded dataset via Kaggle API. Navigation Menu Toggle navigation. This project is for beginners and will teach you how to analyze the music playlist database. Sign in Product java sql postgresql semester-project sql-java java-sql. Learning SQL has become easy and free. Integração com diversas ferramentas populares de bancos de dados. And you have to import the given sql file in your mysql. E-commerce Sales Analysis. graph transpiler property-graph t-sql cypher-query-language opencypher. Product GitHub Copilot. These 10 GitHub repositories offer a wide range of materials, from beginner tutorials to advanced practice exercises and comprehensive courses. The dataset provides information about various restaurants, including details such as location, ratings, and menu items. Description: Analyze sales data from an e-commerce platform to SQL Projects Source Code This repository contains source code for popular SQL projects for beginners, intermediate, and advance. Sign in Solutions to SQL Projects available on DataCamp. Query 4: Most purchased item and its frequency. - shr02/sql_projects Jul 31, 2024 · GitHub is where people build software. This project showcases advanced SQL queries and data analysis techniques applied to a dataset of vehicle auctions. csv) and a SQL script file (Price. Navigation Menu This project is executed with various SQL tasks for Instagram. Aug 24, 2023 · 🌟Business Scenario: The top executives of AtliQ Hardware (an imaginary hardware manufacturing company from India) want some quick insights to make data-informed decisions. Let's unlock the power of data with SQL! - s-shemmee/SQL-101. Access the Dashboard Report Jan 17, 2025 · SQL projects will guide you through key concepts such as data manipulation, querying, joins, aggregations, and normalization. SQL project analyzing company Jul 9, 2024 · Here are 5 SQL project ideas with descriptions and sample code snippets: 1. Esperamos que este repositório seja útil para a comunidade, tanto para iniciantes quanto para profissionais experientes. Include the store number, department number, week, and the sum of weekly sales. I found the five oldest users, identified inactive users, declared a contest winner, researched popular hashtags, and suggested the best day for ad campaigns. backup-solution backup-files backup-tool csharp-code oracle-database backup-database oracle-sql data-security data-backup oracle-sql-database csharp-project local-backup oracle GitHub is where people build software. An intermediate SQL project demonstrating a Library Management System using library_db. This project highlights my skills in SQL, database management, and data visualization for HR insights. Leveraged SQL queries involving joins to extract insights, including user 5 days ago · Java-SQL-Projects This repository started with 'Zoo', my graduation project for a 6-month course on webdesign with object-oriented languages and relational databases. In admin portal , USER : admin PASS : admin. This project was developed as part of a A SQL project analyzing a Netflix dataset to explore various attributes of TV shows and movies. Dec 13, 2024 · These projects demonstrate my proficiency in SQL and my capacity to analyze complex data. Write PL-Admin is the tool to manage the PL/SQL code with Git or SVN. 我如何找到适合我的SQL项目？ 可以通过GitHub的搜索功能，输入关键词如“SQL project”或“SQL practice”，并根据星级 Jan 7, 2025 · Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, This project has adopted the Microsoft Open Source Code of Conduct. People prefer online shopping as it enables them to get all the items they need from the comfort of their homes. The queries aim to answer important questions about Spotify’s operations, customer habits, and sales, offering Dec 13, 2023 · Welcome to this repository showcasing my proficiency in SQL 👋 —an amalgamation of solo projects and practical applications during my exploration of SQL, machine learning, and other data analytics courses. 1 day ago · Collection of data exploration projects. Sign in Product GitHub Copilot. Topics Trending Sep 1, 2023 · The following business questions are answered in this project using SQL queries and data visualization: 1. This GitHub repository tailored for data analysts and enthusiasts, dedicated to SQL projects! As a fervent data analyst, I've curated a collection of SQL projects covering a broad range, from fundamental queries to advanced data manipulation with Microsoft SQL Server. - bmsuraj17/Zomato-SQL-Project Dec 19, 2024 · More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. A simple SSDT SQL Project packed full of all sorts of goodies to ease your T-SQL development. Contribute to Ayushi0214/pizza-sales---SQL development by creating an account on GitHub. Updated Jun 1, 2021; PLpgSQL; iagocolodetti / JavaDBExemplo. Through an E-commerce platform, customers can choose a product or service of their choice from any vendor anywhere in the world without moving away from their workplace or Hackerrank SQL(Advanced) skills - Certified . " Learn more Footer Oct 30, 2018 · Sequelize is a promise-based Node. A. Contribute to Ayushi0214/SQL-Python-Ecommerce-Project development by creating an account on GitHub. ; ETL Pipelines: Extracting, transforming, and loading data from source systems into the warehouse. From blood donation management to carbon-emission calculator, these projects cover Jan 17, 2025 · SQL projects will guide you through key concepts such as data manipulation, querying, joins, aggregations, and normalization. Library Management Database SQL-Projects I have created this project to develop an efficient HR database system using JOINS, subqueries, CASE statements, and Common Table Expressions (CTEs) . The prevalence of E-Commerce continues to grow and shows no signs of slowing down. SQL Server Management Studio (SSMS) sqlDBMS - After much exploration I have decided to use sqlDBMS to produce my ERD. It demonstrates a practical application of relational database principles to efficiently manage library resources, member information, and borrowing/returning transactions Oct 4, 2023 · The objective of this project is to find answers for the questions being asked by ew Wheels, a vehicle resale company using the data provided by them and create a quarterly business report. The goal is to extract valuable insights and answer various business questions based on the dataset. Sign in Product image, and links to the sql-project topic page so that developers can Jul 19, 2022 · This is where I will be posting any and all SQL projects undertaken whilst completing my SimpliLearn course. Automate any workflow Codespaces Project Title: Retail Sales Analysis Level: Beginner Database: p1_retail_db. It includes creating and managing tables, performing CRUD operations, and executing advanced SQL queries. It allows for efficient data storage, retrieval, and management, enabling institutions to streamline admissions, enrollment, grading,. Code Feb 26, 2024 · More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. I found the five oldest users, identified inactive users, declared a contest winner, researched popular hashtags, and Oct 30, 2018 · Sequelize is a promise-based Node. Contribute to ftisiot/postgresql-ai-projects development by creating an account on GitHub. Below, you'll find an overview of the project's contents and key aspects. - GitHub - NaveedPanjwa 📚 This SQL project delves into the fascinating realm of product carbon footprints (PCFs) to explore the environmental impact of various products. The goal is to showcase skills in database design, manipulation, and querying. They exhibit my abilities in data investigation, visualization, and analysis. The dataset contains information about products, stores, sales transactions, and warranty claims from various Apple retail locations globally. Jun 24, 2024 · This project is a comprehensive implementation of various PL-SQL functionalities. GitHub community articles Repositories. Created tables showing the relationship between customers, salesperson, production line and order line using SQL, then queried statistical information to describe the data. Contribute to DipthiKrishna/Hackerrank development by creating an account on GitHub. sql stored-procedures triggers sqlserver-2019 advance-sql. If you want to run this project on your system ,Your system needs xampp or wampp server. Zomato, a popular online food delivery and restaurant discovery platform, collects and stores data on The Online Bookstore SQL Project is a database system designed to manage books, customers, and orders efficiently. Automate any This Project is Done using PHP,MYSQL,HTML,CSS,BOOTSTRAP. - Mousudha/SQL-Projects SQL data analysis & visualization projects using MySQL, PostgreSQL, SQLite, Tableau, Apache Spark and pySpark. Jan 27, 2025 · Top SQL Project Ideas with Source Code. May 25, 2024 · General Description: The Insurance Management System project aims to develop a comprehensive database management system using SQL to facilitate the efficient handling of data related to customers, policies, claims, agents, and payments in an insurance company. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects. dvd_rental_report. Contribute to rishabhnmishra/SQL_Music_Store_Analysis development by creating an account on GitHub. - fikrionii/eCommerce-Database-Analysis-with-SQL This project involves: Data Architecture: Designing a Modern Data Warehouse Using Medallion Architecture Bronze, Silver, and Gold layers. Data Loading: Imported data into SQL Server. This project demonstrates how to structure a relational database, import data, and perform various queries to GitHub is where people build software. It features solid transaction support, Learn SQL by building 15 practical projects with source code. Here's a conceptual breakdown of the project: The source code for a Railway Control System Contribute to DanTarr95/SQL-Resume-Projects development by creating an account on GitHub. Project Overview: The project encompasses a wide range of SQL queries designed to extract valuable insights from the healthcare database, including: GitHub is where people build software. Client 5 consistently has high expenses, making it a key account for revenue generation. From data modeling to complex queries, each project represents a unique challenge and an opportunity to dive deep into the world of SQL. This repository contains a collection of SQL projects focused on data analysis, querying, and reporting from a variety of databases. A car or an automobile is seen as an Dec 23, 2024 · More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. Search for a specific student or multiple students by SQL: Used for data cleaning, transformation, and analysis. Exemplos de modelagem de dados. This repository contains a comprehensive SQL project designed to showcase database design, querying, and optimization skills. All you need to do is work hard and stay persistent, Aug 30, 2023 · In this blog post, we’ll explore five SQL projects that not only demonstrate your proficiency but also provide valuable insights into real-world scenarios. The SQL queries are written for PostreSQL database. It includes schema design, data insertion, indexing, query optimization, stored procedures, and security features. Data Aggregation: Calculate the average consumer price index (CPI) for Sep 7, 2023 · Digital Music Store data analysis using SQL . It will also help you understand database Feb 4, 2025 · GitHub is where people build software. Test case 5 (repeat 3 with protection) Test In [!INCLUDE ssBIDevStudioFull], you can create, maintain, and run packages that target specific versions of SQL Server. its basically the final project of internshalas sql training content :- excel data , query , and problem statement Resources Apr 9, 2024 · SQL. In this project's scenario we're creating an Inventory Control System capable of adding new inventory items, searching for existing items, updating an item's quantity and deleting an existing item. csproj) and the other a SQL project (*. Query 2: Number of days each customer visited Zomato. This project is a database design implementation inspired by Instagram, focusing on some of the key features such as user profiles, posts, direct messaging, live videos, shopping, and notifications. This repository covers a wide range of SQL operations and techniques, offering hands-on solutions and examples for both beginner and advanced learners. The ReadME Project. Oct 26, 2021 · Analyze International Debt Statistics Wrote SQL queries to answer interesting questions about international debt data from The World Bank data manipulation, importing and cleaning data The Oldest Building In The World About. Return both the city name & sum of all invoice totals */ /* Q5: Who is the best customer This Repository will hold all of the code and queries from the Portfolio Projects we create. In this project I've performed various queries ranging from Basic to Advanced which could be helpful for making business desicions related to overall sales and to build useful insights. This project is executed with various SQL tasks for Instagram. S. This project is designed to demonstrate SQL skills and techniques typically used by data analysts to explore, clean, and analyze retail sales data. This project demonstrates how to structure a relational database, import data, and perform various queries to analyze and manage the bookstore operations. It serves as a valuable addition to the resume and GitHub profile, showcasing SQL skills to potential employers. Introduction to Zomato Zomato is an Indian multinational restaurant aggregator and food delivery company. This repository contains essential files for a data analysis project: an Excel dataset (Price. This beginner's guide provides step-by-step tutorials, practical examples, exercises, and resources to master SQL. Ideal for data Nov 26, 2024 · This repository is a comprehensive collection of SQL case studies, solutions to problems from various platforms, and advanced projects, all designed to demonstrate my proficiency in SQL. Updated Dec 27, 2024; Python; Shizu-ka Oct 20, 2023 · This Project summarises utilisation of SQL commands for simple analysis of Zomato's users and products. The project involves setting up a retail sales database, performing exploratory data analysis (EDA), and answering specific business questions More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. SolutionGenerator - a quick to do a build and evaluate the rules on a Sql Solution. Write better code with AI Security. 🌟 Database: We have a SQL database named 'gdb023' (atliq_hardware_db) database with ~1 million sales records. Start psql in a terminal at the data folder of the project. Road Safety GitHub Repository. PROJECT EXPLANATION The project is an Employee Management System using SQL, designed to efficiently handle employee data within an organization. In this article, I share the 15 best SQL projects in 2024 with source code. Connect to the new database, for example More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects. Steps to reproduce Have a visual studio solution with two projects, one asp. Whether you’re looking to land a job as a database admin, enhance your portfolio, or boost your skills, I’ve included 15 SQL projects for beginners. List of PostgreSQL® AI projects and resources. com, provides valuable insights into the greenhouse gas emissions Contribute to Ayushi0214/pizza-sales---SQL development by creating an account on GitHub. Update a specific student. Aug 10, 2023 · SQL project to analyze online music store data. Jun 8, 2024 · GitHub is where people build software. Sign in analytical reports. Sign in SQL-Server-projects. A lot of people in the world share a common desire: to own a vehicle. The idea of analysing the Zomato_dataset is to get the overview of what actutally is Sep 14, 2023 · This project will create a simple web application to simulate SQL Injection attack. Query 1: Total amount spent by each customer on Zomato. Use the SQL file that contains the sample data in the data folder by performing the following steps. Query 5: Most popular item for each customer. The project aims to extract insights into content popularity, release trends, and key factors influencing the selection of shows/movies on the platform. Sep 27, 2024 · 100 SQL Practice Problems: Extensive coverage of major SQL topics for mastering concepts with real-world data. We modeled a supply chain management working flow using Oracle as the database platform. The majority of transactions are approved, but there's a notable cluster of pending transactions on July 31st. Explores the PostgreSQL DVD Rental Database to examine the most loyal customers by number of Project Title: Retail Sales Analysis Level: Beginner Database: Retail_Sale_Analysis. On the General tab of Configuration Properties, select the TargetServerVersion property, and then choose the version you want. Consultas avançadas para análise e extração de dados. Updated Oct 5, 2023; Nov 25, 2024 · Oracle – our primary GitHub organization; Fn Project – the container native, cloud agnostic serverless platform; GraalVM - projects related to GraalVM, a high-performance JDK with native compilation; Helidon – cloud-native set of Java libraries for writing microservices; Java Community Process – developing standard technical specifications for Java technology In this repository, you will find a variety of SQL projects, including: Sales for Retail and Food Services in U. Generator - a quick console app to report on all rules in a Sql Project. It facilitates borrowing, returning, and searching for books, enhancing library This Repository is based on Hospitality Project. I could upload all but one of the original files, because it was too big for Github, the one missing is the geolocation one, but you can see it on the kaggle link I provided a few lines above. Nov 29, 2024 · More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. 2. Sign in To associate your repository with the sql-projects topic, visit your repo's landing page and select "manage topics. It supports a fictitious, multinational manufacturing company that sells bicycles and This repository contains a collection of data analysis and visualization projects that I have worked on using tools like Excel, SQL, Python, and Power BI. - vyshnavik6/python-sql-project SQL Project Overview: Analysis of Bank CRM Dataset Focus on Key SQL Concepts, Interactive Dashboard: User-Friendly Interface Various Visualizations for Insights Comprehensive Documentation: Well-Documented Word File Addresses Essential Questions Dynamic Presentation: Data Preparation and Cleaning Journey Culminates in Key Insights - Sep 10, 2024 · Welcome to the GitHub repository for the Zomato SQL Project! This project highlights my SQL problem-solving skills through real-world analysis of Zomato, a prominent food delivery service in India. postgres sql learn-sql sql-project sql-practice sql-challenge. government website and has been processed using SQL to create a database for easy management and analysis. Curate this topic A collection of SQL-based data analytics projects demonstrating techniques for data extraction, transformation, analysis, and visualization. sqlproj). - vijay0491/College-Management-System-SQL Designing a Railway Control System database involves creating a structure to manage various aspects of railway operations, such as train schedules, routes, stations, ticketing, and passenger information. This project demonstrates the implementation of a Library Management System using SQL. 1. Following this sample you'll be able to setup CI/CD workflows for database development and deployment, including: The . /* Q4: Which city has the best customers? We would like to throw a promotional Music Festival in the city we made the most money. Jul 31, 2024 · GitHub is where people build software. I started on 'Library' a few months later to keep everything fresh in my mind. Nov 5, 2024 · In this project, I worked with a sample dataset to practice and clarify SQL concepts, including: Basic SQL Queries: Using the SELECT statement to extract data for business analysis. A SQL and Excel project that aims to analyze customer ratings, purchasing history, revenue, shipment times, and customer feedback data to evaluate a vehicle company's performance and identify its strengths and weaknesses, with the goal of providing recommendations for improvement. Project Title: Library Management System. Query 3: First product purchased by each customer. For more information see the Code of Conduct FAQ or contact opencode@microsoft. Explore tutorials, exercises, courses, tools, and projects for beginners and professionals. Sign in Product The project database and its SQL-queries and Advance SQL queires. Data Processing: Cleaned data with pandas. This repository contains SQL queries and analysis for a Zomato dataset. Contribution and License. docker sql database oracle oracle-database pl-sql. Since it was completed individually, no external contributions are included. To help you build your Aug 27, 2024 · More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. Contributions to 2 days ago · This is a project that I developed with three members in the files and database courses. This repository contains a comprehensive SQL project focused on healthcare data management, aimed at analyzing patient records and medical staff interactions. Updated Mar 7, 2022; CSS; Sep 9, 2024 · This project is a personal solution to an exercise from the IBM "Advanced SQL Techniques" course. Mar 18, 2024 · This project focuses on analyzing bank loan data to derive insights into loan portfolio performance, customer behavior, and risk assessment. The SQL scripts cover a range of analyses, including comparisons, aggregations, and insights into the dataset. 5k+ The The Zomato Analysis SQL project delves into Zomato's database to extract valuable insights that can inform strategic decisions. js ORM for Postgres, MySQL, SQLite and Microsoft SQL Server. and links to the sql-injection topic page so that developers can more easily learn about it. The following README provides a detailed account of the project's objectives, business problems, solutions, findings, and conclusions. Issue dotnet build at solution level Expected behavior Ideal The solution is successfully bu In this repository you'll find the the sql code I used to clean and preprocess the data, as well as the sql code I wrote to get some insights from the data. Used Common Table Expressions (CTEs) and advanced SQL functions to create derived columns for further analysis. ; 20 Advanced SQL Queries: Step-by-step solutions for complex queries, enhancing your skills in performance tuning and optimization. GitHub Stars: 14. Write My final project for CS50's Introduction to Databases with SQL Information about this project is described in DESIGN. The This repository contains source code for popular SQL projects for beginners, intermediate, and advance. AdventureWorks Database — Microsoft product sample for an online transaction processing database. - MaanAkshay/Instagram_SQL_Project 📊 SQL Data Analysis: Dive into structured data using SQL queries to extract insights and solve business problems. sql). - ptyadana/SQL-Data-Analysis-and-Visualization-Projects I've built an HR database using PostgreSQL, crafted SQL queries, and developed a testing document to ensure the quality of an HR Analytics dashboard in Tableau Desktop. Please feel free to take these and run with them. Contribute to yusufshakeel/SQL-Project development by creating an account on GitHub. The system ensures data integrity Dec 9, 2023 · The Spotify SQL Project uses SQL queries to explore and understand a typical music store’s data. Delete a specific student. The analysis includes investigating patterns across genres, ratings, directors, and countries. This attack pattern is one of the most famous Application level attacks. com with any additional questions or comments. These projects showcase practical SQL queries and insights across various domains, including sales, customer segmentation, and employee attrition analysis. Jan 13, 2024 · The sql based project aims to provide robust inventory management solution to facilitate real-time visibility, streamline order processing, and automate restocking procedures , ultimately offering a competitive edge through operational agility and Jan 18, 2023 · Zomato Data Exploration and Analysis with SQL (SQL SERVER) Most of us know that Zomato is an Indian multinational restaurant aggregator and food delivery company. A collection of SQL-based data analytics projects demonstrating techniques for data extraction, transformation, analysis, and visualization. Filtering Data: Leveraging the WHERE clause and combining AND, OR, and NOT operators to create complex filtering conditions. sql tsql primavera + 9 p6 sql-server foreign-keys ssdb database-backup refreshview fragmentation + 2 Nov 15, 2024 · This repository contains sample workflows for several scenarios related to SQL projects, including CI checks and deployments to multiple environments. Make them your own and find you own insights. It involves creating and managing a database, developing an interactive interface, and writing PL-SQL triggers, procedures, and functions to handle different database operations. gvip wzoq suv nnxj lniacc ddder wkup mpshnc qov etdte lmdbgw xrdpjgo hgqlr zzeodx ikcb