Wise Owl SQL Server Exercises Solutions
-
Updated
Apr 29, 2023 - TSQL
Wise Owl SQL Server Exercises Solutions
TSQL-Project about the management of a plant store
This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.
Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.
example sql queries
Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.
A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.
Business questions were solved for Rockbuster Stealth LLC, a fictional movie rental company, through the use of SQL in this project. This project was completed as part of the CareerFoundry's curriculum.
Analyze product data for an online sports retail company to optimize revenue.
Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.
RFM Analysis for customer segemntation, to categorize the customers based on resency, frequency and monetary. by using analytical SQL functions and common table expression(CTE).
Repositório do módulo de Databases, Tables and Views on Databricks do curso Data Analyst Learning Plan
In any company, measuring business performance is crucial for tracking, monitoring, and evaluating the success or failure of various business processes. Therefore, this project aims to analyze the business performance of an eCommerce company, considering several business metrics: customer growth, product quality, and payment types.
Examples of SQL queries created for Customer and Sales Data Analysis study project
T-SQL queries for several useful SQL Server functions including alter column, rename column, cursor, paging, and hierarchy querying.
Common Table Expression builder that uses Doctrine DBAL
UI to visualize common table expressions in sql scripts
Directed Acyclic Graphs with a variety of methods for both Nodes and Edges, and multiple exports (NetworkX, Pandas, etc). This project is the foundation for a commercial product, so expect regular improvements. PR's and other contributions are welcomed.
Add a description, image, and links to the common-table-expression topic page so that developers can more easily learn about it.
To associate your repository with the common-table-expression topic, visit your repo's landing page and select "manage topics."