Скачать или смотреть انطلاقة كورس Art of Querying SQL

انطلاقة كورس Art of Querying SQL
https://bitsnpixels.io/course/art-of-...
Course content | محتوى الكورس
Introduction
Introduction (video)
SQL & Relational Databases (video)


Basic SQL query
Select Clause (video)
Employees names 🤔 (problem)
Bonus 🥳 (problem)
Where clause (video)
Ahmed 👨🏻‍🦱 (problem)
Mohamed 🫡 (problem)
Gift 🎁 (problem)
in-between (video)
Fun day 💃 (problem)
Cost Reduction 😢 (problem)
Nulls & Ternary logic (video)
Freelancers 🤾 (problem)
Ahmed Again 👨 (problem)
Querying Nulls (video)
Processing Order and Relationships
Introduction (video)
Logical processing order (video)
One to Many Relationship (video)
One to One Relationship (video)
Many to Many Relationship (video)


Joins
Joins Introduction (Video)
Cross Join (Video)
Products ❌ Categories (Problem)
Inner Join (Video)
Loyal Users 👥 (Problem)
Flash Sale 🔻 (Problem)
Plus one ➕ (Problem)
Rainy Day ☔ (Problem)
Outer Join (Video)
All Users Orders 🙌 (Problem)
Special Offer 🎉 (Problem)
Multiple Joins (Video)
Two Joins 2️⃣ (Problem)
Three Joins 3️⃣ (Problem)
Four Joins 4️⃣ (Problem)


Groups
Groups Introduction (Video)
Aggregate functions (Video)
Affordable product 🤑 (Problem)
Cash Flow 💸 (Problem)
Rain Has Stopped🌂 (Problem)
Ordered Products 📦 (Problem)
Group by (Video)
products per category 📋 (Problem)
User Spent 💳 (Problem)
Having (Video)
Having Practice (Video)
High Average ☝️ (Problem)
Loyal Users 2 🕺 (Problem)
Sorting and Pagination


Sorting and Pagination Introduction (Video)
Order by (Video)
Ordered Products 🔢 (Problem)
Premium Categories ✨ (Problem)
Freelancers last ⬇️ (Problem)
Pagination (Video)
Products ❌ Categories 1️⃣ (Problem)
Products ❌ Categories 2️⃣ (Problem)
Mid-priced Products ✂️ (Problem)