A Comprehensive Repository for Mastering SQL: Extensive Codebase and Learning Resources
-
Updated
May 20, 2024 - TSQL
A Comprehensive Repository for Mastering SQL: Extensive Codebase and Learning Resources
Publishing all latest matches, scores, goalscorers, assist makers and cards during the 2020-21 Premier League season. All SQL commands include, top scorers, which stadium has the most goals and many more.
Learning note of SQL including important concepts and practice
Microsoft SQL Server es un sistema de gestión de bases de datos relacionales (RDBMS) que admite una amplia variedad de aplicaciones de procesamiento de transacciones, inteligencia empresarial y análisis en entornos informáticos corporativos.
A comprehensive guide to mastering SQL, covering topics from basic commands to advanced techniques. This repository includes practical SQL examples, sample data files, and visual aids
Analysis of Covid-19 related deaths and vaccinations using SQL
The repository contains queries which are performed to retrieve, sort, join and aggregate Adventure works data base. We designed VIEWS, PROCEDURES, INNER, OUTTER and FULL JOINS, LOOPS.
The aim of this analysis was to extract valuable insights and answer a variety of questions related to the history, participation, and performance of nations and athletes in the Olympic Games. This project demonstrates my proficiency in Data Analysis, SQL Querying using advance functions like CTE, Joins, CASE, Pivot.
The aim of this analysis was to extract valuable insights and answer a variety of questions related to the history, participation, and performance of nations and athletes in the Olympic Games. This project demonstrates my proficiency in Data Analysis, SQL Querying using advance functions like CTE, Joins, CASE, Pivot.
This project extracts and cleans raw YouTube data from excel-csv (Kaggle) through SQL and identifies the top-performing UK-based Influencers. Data Stack: Excel | Microsoft SQL Server | Power BI
Examples of SQL scripts. Includes templates for admin (SQL server) and data cleaning, as well as scripts designed for creating a mock database, illustrating triggers, common table expressions, analysis, and ETL.
Add a description, image, and links to the cte topic page so that developers can more easily learn about it.
To associate your repository with the cte topic, visit your repo's landing page and select "manage topics."