محتوى الكورس
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
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)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
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
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'
Available in
days
days
after you enroll