Exploration of Covid 19 official dataset using SQL queries. Data cleaning of Nashville housing dataset for effective modelling and analysis.
-
Updated
Sep 29, 2024
Exploration of Covid 19 official dataset using SQL queries. Data cleaning of Nashville housing dataset for effective modelling and analysis.
This project focuses on executing advanced SQL queries on an airline database to derive meaningful insights. The queries analyze key aspects of airline operations, such as ticket bookings, passenger records, flight schedules, and aircraft details. It leverages essential SQL techniques, including joins, CTEs, aggregations and a lot more.
This project presents a fictional case study analyzing the operations of a textile company, FabricFlow, using SQL. The dataset includes information about products, sales, inventory, suppliers, and purchases. The goal is to derive actionable insights to improve operational efficiency, inventory management, and supplier performance.
First practice post-LaunchCode graduation to review the various SQL skills we learned throughout the course.
Analysis of Total coronavirus cases, deaths and vaccination data of countries around the world using Microsoft SQL server. Data taken from the website: ourworldindata
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
Add a description, image, and links to the ctes topic page so that developers can more easily learn about it.
To associate your repository with the ctes topic, visit your repo's landing page and select "manage topics."