Mastering SQL Server: Building a Database and Analyzing Real-World Business Insights!'

.
⚙️If you like, turn on the English subtitle from the player's settings.

Welcome to this comprehensive SQL Server project! In this video, we’ll begin by exploring a realistic dataset featuring five tables: one fact table for transactions and four dimension tables supporting it. We’ll examine the relationships between these tables through an entity-relationship diagram and create a structured database from scratch. You’ll learn how to define primary keys, establish table relationships, and create tables using both the SQL Server GUI and queries. After populating the database with data, we’ll address real-world business questions, such as identifying high-spending customers and their provinces, analyzing daily spending by customer category, and identifying inactive customers by year. Let’s dive into the world of SQL and unlock valuable insights from data!

🕒 00:00 Introduction
🕒 00:10 Look at Data
🕒 02:54 Look at Relationships
🕒 05:23 Create Database
🕒 06:05 Create Tables
🕒 14:53 Define Primary Keys
🕒 16:49 Draw Entity Diagram of Tables
🕒 21:19 Ingest Data to Database
🕒 31:55 Question 1: Identify High-Spending Customers and Their Provinces
🕒 42:19 Question 2: Daily Spending by Customer Category
🕒 47:56 Question 3: Inactive Customers by Year

🧷 If you like, you can walk through the project's materials:
-------------------------------------------------------------------
Also, you can find more videos like this in the below playlists:
-------------------------------------------------------------------
I'd be pleased if you see my profile:

[KasunWitharana-qorr]

amazing video. Keep up the good work, but data on the GitHub excel is different. can you please upload the correct data set.