Use SDK-style SQL database projects

SQL project to deploy data-tier application(DAC) package with Github Actions. Includes IaC(bicep) for deployment of SQL database on Azure Cloud.

Tutorial to provision an Azure SQL Managed Instance with Terraform and deploy a DACPAC to it with GitHub Actions.

Data Analysis for Digital Music Store using SQL

Data Analysis project to help Chinook Digital Music Store to help how they can optimize their business opportunities and to help answering business related questions.

Contains source code for database project and documentation on how to migrate from framework based project to SDK based project.

This project analyzes pizza sales data to gain insights into customer behavior and revenue patterns. Key analyses include customer insights, popular pizza types and sizes, revenue generation, and order trends. The findings help optimize menu offerings, staffing, and marketing strategies to boost overall business performance.

Solutions to SQL Projects available on DataCamp.

Pizza sales SQL Project

# SQL Music Store Project This repository contains the SQL scripts and related files for the Music Store project. The Music Store The database schema includes tables for storing information about.

An SQL analysis exploring the relationship between reported crimes in Chicago and the average daily temperature from 2018 through 2023

Transforming banking operations with MySQL Bank Management System: robust schema, advanced queries, views, and security measures ensure efficiency and data integrity. Ready to revolutionize the industry.

Ayodhya Ram Temple Analysis

This repository contains SQL analysis of a digital music store. This project guides you through writing SQL queries to extract meaningful information. Whether you're new to SQL or looking to sharpen your skills, this project provides a hands-on learning experience, helping you become proficient in data analysis.

I've tackled intermediate-level SQL questions based on a real Olympic history dataset from Kaggle. These questions were generated by Tech TFQ. I've attempted to solve them using my own methods.

Hospital Database Management System (DBMS) is a comprehensive SQL project designed to streamline and optimize the management of hospital operations. This project aims to provide an efficient and user-friendly solution for storing, retrieving, and manipulating various types of healthcare-related data.

This repository contains SQL queries analyzing a dataset from the Golden Age of Video Games. With eight tasks fulfilled, explore trends in genres, regional sales, and more for insightful insights into this iconic era of gaming.

A SQL project based on the WideWorldImporters database with new, additional SQL objects.

This project is executed with various SQL tasks for Instagram. I found the five oldest users, identified inactive users, declared a contest winner, researched popular hashtags, and suggested the best day for ad campaigns. For investors, I calculated user engagement metrics and flagged potential bot accounts.