T-SQL queries for several useful SQL Server functions including alter column, rename column, cursor, paging, and hierarchy querying.
-
Updated
Apr 11, 2020 - TSQL
T-SQL queries for several useful SQL Server functions including alter column, rename column, cursor, paging, and hierarchy querying.
Examples of SQL queries created for Customer and Sales Data Analysis study project
Repositório do módulo de Databases, Tables and Views on Databricks do curso Data Analyst Learning Plan
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.
UI to visualize common table expressions in sql scripts
Analyze product data for an online sports retail company to optimize revenue.
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.
example sql queries
Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.
Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.
This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.
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).
Wise Owl SQL Server Exercises Solutions
TSQL-Project about the management of a plant store
Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.
A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.
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.
Common Table Expression builder that uses Doctrine DBAL
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."