مهم جدا
يجب ان تكون قد انهيت كورس رقم 15 المشار اليه بالاحمر
سيتم تنزيل الدروس تدريجيا بشكل شبه يومي
محتوى الكورس
Important Introduction
Available in
days
days
after you enroll
Introduction
Available in
days
days
after you enroll
Hints
Available in
days
days
after you enroll
Relational Diagrams Projects.
Available in
days
days
after you enroll
- Project 1 - Simple Clinic (Requirements)
- Project 1 - Simple Clinic (Solution) (19:11)
- Project 2 - Simple Library (Requirements)
- Project 2 - Simple Library (Solution) (22:39)
- Project 3 - Karate Club (Requirements)
- Project 3 - Karate Club (Solution) (18:30)
- Project 4 - Car Rental (Requirements)
- Project 4 - Car Rental (Solution) (23:56)
- Project 5 - Online Store (Requirements)
- Project 5 - Online Store (Solution) (13:36)
Misc
Available in
days
days
after you enroll
Buy and Import Data
Available in
days
days
after you enroll
SQL Problems
Available in
days
days
after you enroll
- Sample Database To Practice On
- Explain Schema (15:13)
- Problem 1: Create Master View (5:46)
- Problem 2: Get all vehicles made between 1950 and 2000 (1:59)
- Problem 3 : Get number vehicles made between 1950 and 2000 (1:09)
- Problem 4 : Get number vehicles made between 1950 and 2000 per make and order them by Number Of Vehicles Descending (3:55)
- Problem 5 : Get All Makes that have manufactured more than 12000 Vehicles in years 1950 to 2000 (8:53)
- Problem 6: Get number of vehicles made between 1950 and 2000 per make and add total vehicles column beside (4:59)
- Problem 7: Get number of vehicles made between 1950 and 2000 per make and add total vehicles column beside it, then calculate it's percentage (6:10)
- Problem 8: Get Make, FuelTypeName and Number of Vehicles per FuelType per Make (3:38)
- Problem 9: Get all vehicles that runs with GAS (2:14)
- Problem 10: Get all Makes that runs with GAS (2:09)
- Problem 11: Get Total Makes that runs with GAS (3:01)
- Problem 12: Count Vehicles by make and order them by NumberOfVehicles from high to low. (2:03)
- Problem 13: Get all Makes/Count Of Vehicles that manufactures more than 20K Vehicles (3:27)
- Problem 14: Get all Makes with make starts with 'B'
- Problem 15: Get all Makes with make ends with 'W'
- Problem 16: Get all Makes that manufactures DriveTypeName = FWD
- Problem 17: Get total Makes that Mantufactures DriveTypeName=FWD
- Problem 18: Get total vehicles per DriveTypeName Per Make and order them per make asc then per total Desc
- Problem 19: Get total vehicles per DriveTypeName Per Make then filter only results with total > 10,000
- Problem 20: Get all Vehicles that number of doors is not specified
- Problem 21: Get Total Vehicles that number of doors is not specified
- Problem 22: Get percentage of vehicles that has no doors specified
- Problem 23: Get MakeID , Make, SubModelName for all vehicles that have SubModelName 'Elite'
- Problem 24: Get all vehicles that have Engines > 3 Liters and have only 2 doors
- Problem 25: Get make and vehicles that the engine contains 'OHV' and have Cylinders = 4
- Problem 26: Get all vehicles that their body is 'Sport Utility' and Year > 2020
- Problem 27: Get all vehicles that their Body is 'Coupe' or 'Hatchback' or 'Sedan'
- Problem 28: Get all vehicles that their body is 'Coupe' or 'Hatchback' or 'Sedan' and manufactured in year 2008 or 2020 or 2021
- Problem 29: Return found=1 if there is any vehicle made in year 1950
- Problem 30: Get all Vehicle_Display_Name, NumDoors and add extra column to describe number of doors by words, and if door is null display 'Not Set' (6:18)
- Problem 31: Get all Vehicle_Display_Name, year and add extra column to calculate the age of the car then sort the results by age desc.
- Problem 32: Get all Vehicle_Display_Name, year, Age for vehicles that their age between 15 and 25 years old
- Problem 33: Get Minimum Engine CC , Maximum Engine CC , and Average Engine CC of all Vehicles
- Problem 34: Get all vehicles that have the minimum Engine_CC
- Problem 35: Get all vehicles that have the Maximum Engine_CC
- Problem 36: Get all vehicles that have Engin_CC below average
- Problem 37: Get total vehicles that have Engin_CC above average
- Problem 38: Get all unique Engin_CC and sort them Desc
- Problem 39: Get the maximum 3 Engine CC
- Problem 40: Get all vehicles that has one of the Max 3 Engine CC
- Problem 41: Get all Makes that manufactures one of the Max 3 Engine CC
- Problem 42: Get a table of unique Engine_CC and calculate tax per Engine CC
- Problem 43: Get Make and Total Number Of Doors Manufactured Per Make
- Problem 44: Get Total Number Of Doors Manufactured by 'Ford'
- Problem 45: Get Number of Models Per Make
- Problem 46: Get the highest 3 manufacturers that make the highest number of models
- Problem 47: Get the highest number of models manufactured
- Problem 48: Get the highest Manufacturers manufactured the highest number of models
- Problem 49: Get the Lowest Manufacturers manufactured the lowest number of models
- Problem 50: Get all Fuel Types , each time the result should be showed in random order
Self Referential Queries
Available in
days
days
after you enroll
- Restore this simple Database First.
- Problem 51: Get all employees that have manager along with Manager's name.
- Problem 52: Get all employees that have manager or does not have manager along with Manager's name, incase no manager name show null
- Problem 53: Get all employees that have manager or does not have manager along with Manager's name, incase no manager name the same employee name as manager to himself
- Problem 54: Get All Employees managed by 'Mohammed'
End Of Course
Available in
days
days
after you enroll
