sqlqueries

There are 71 repositories under sqlqueries topic.

  • PortafolioProjects

    Language:TSQL

  • Hospital-Management-System

  • Home_Sales

    Spark Home Sales Analysis utilizes Apache Spark to explore and analyze home sales data, providing insights into average prices based on various criteria. The project employs Spark SQL queries for efficient data processing and is designed for easy setup and usage.

    Language:Jupyter Notebook

  • Analyzing_Historical_Employee_Data--SQL

    A major corporation needs to analyze employee data from the 1980s and 1990s, which is stored in separate CSV files. The project involves designing table schemas, importing data into a SQL database, and conducting data analysis tasks to extract insights.

  • sql_queries

    This repository contains the RDBMS Notes and sql queries

    Language:PLpgSQL

  • Film---Rental---SQL

    There is a film rental store that provides DVDs on a rental basis. The owner of this store is your friend and he is not at all computer savvy. To manage his business he has software that helps him to manage the business.

  • SQL_Practice_Question

    This repository contains my practice queries of SQL. I have solved these queries using Postgresql.

  • SQL-Projects

    The repository contains Structured Query Language (SQL) Scripts. The Multiple SQL scripts for various projects which includes data cleaning, data pre-processing, data processing, data transformation and insights gaining through Query Language

    Language:TSQL

  • SQL-Projects

    The repository contains Structured Query Language (SQL) Scripts. The Multiple SQL scripts for various projects which includes data cleaning, data pre-processing, data processing, data transformation and insights gaining through Query Language.

    Language:TSQL

  • Airbnb-in-Milan-city-python-SQL-import-and-queries-

    Import .CSV file into python and upload to database with mysql and sqlalchemy also some queries to find best locations and prices

    Language:Jupyter Notebook

  • Cybersecurity-Project

    Google Cybersecurity Certification Projects

  • Databases

    This repository contains a series of guides and resources dedicated to SQLite, a lightweight and embedded relational database management system. Explore various topics and learn how to work with SQLite effectively.

    Language:Python

  • sql_study

    Study SQL Queries

  • El_badr_marble_company_sql

    sql database project for El badr marble company

  • Portfolio-Project-Covid-19

    SQL queries to identify and analyze various trends in Covid-19 spread across all the countries.

  • HR-Emloyee-Report

    HR Employee dashboard using Power Bi

  • ETL_IMDB

    :movie_camera: Extraction, transformation and loading of data from IMDB using web scraping and Postgresql

    Language:Jupyter Notebook

  • Phonepe_Pulse

    | Phonepe_Pulse | Git-hub Clone | SQLite-3 | Pyplot | Streamlit |

    Language:Python

  • createsqlquery

    Automated SQL Query Generator. This program can generate SQL query automatically. DBAdmins can use it to extract effective data from large databases

    Language:Java

  • SQL

    SQL Queries, Stored Procedures

    Language:Jupyter Notebook

  • DBMS_Project

    A database model emulating the daily transactions in a No-Human Contact Grocery Store.

  • SQL_Problems

    If you not know what is SQL, SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system.

  • Cloth_Showroom_SQL

    This SQL file consists of cloth showroom management along with queries.

  • Bus_reservarion_SQL

    A SQL file consists of online ticket reservation system for buses.

  • pizzeria

    Pizza Orders Management Database System made using MySQL Community.

  • Pewlett-Hackard-Analysis

    Company records were parsed with SQL through PgAdmin to determine retirement eligible employees, potential retirement numbers per department and titles.

    Language:PLpgSQL

  • khan-academy-sql-challenges

    Lessons include: SQL basics, more advanced SQL queries, relational queries in SQL and modifying databases with SQL

  • useful-sql-queries

    Useful SQL Queries

    Language:SQL

  • SQL

    #SQL

  • Data_Modelling_with_PostgreSQL

    A hands-on project on data modelling using PostgreSQL which includes functions like creating database, inserting records, ETL process, postgresql aggregation queries.

  • live_covid19_tweets

    This is an application created in python to collect live data regarding the COVID-19 pandemic and save it to SQL storage.

    Language:Python

  • SQL-Creation-of-Relational-Database

    In this project, a database is created for an organization based on six existing separate tables of data in csv form. Relationships between the tables are defined based on the existing data. In the new relational database, specific queries are performed.

  • DemoSQLPython

    connection of mysql with pycharm and insert,update , delete, order by query execution from pycharm IDE

    Language:Python

  • Workshop_Management_System_DBMS

    Desktop application that uses C# and MySQL

    Language:C#

  • sql-prototypes

    SQL related scripts that are commonly used across different types of databases

    Language:SQLPL