First practice post-LaunchCode graduation to review the various SQL skills we learned throughout the course.
-
Updated
Jan 7, 2025 - Jupyter Notebook
#
ctes
Here are 6 public repositories matching this topic...
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.
-
Updated
Dec 20, 2024
Exploration of Covid 19 official dataset using SQL queries. Data cleaning of Nashville housing dataset for effective modelling and analysis.
-
Updated
Sep 29, 2024
Analysis of Total coronavirus cases, deaths and vaccination data of countries around the world using Microsoft SQL server. Data taken from the website: ourworldindata
-
Updated
Oct 26, 2021
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
sql data-analysis cte joins subquery aggregate-functions job-analysis ctes subqueries-and-joins data-nerd
-
Updated
Sep 16, 2024 - PLpgSQL
Improve this page
Add a description, image, and links to the ctes topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the ctes topic, visit your repo's landing page and select "manage topics."