Autoplay
Autocomplete
Previous Lesson
Complete and Continue
17 - Database - SQL ( Projects & Practice)
Important Introduction
About This Course
Telegram Group for This Course
Introduction
Before You Start..
Hints
Solution To: "Saving changes is not permitted" error (1:26)
Relational Diagrams Projects.
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
What is GUID? and how to use it In Database?
Buy and Import Data
Buy and Import Data (15:04)
Extract Data to a Separate Table (13:25)
SQL Problems
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
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
End Of Course (2:18)
Problem 5 : Get All Makes that have manufactured more than 12000 Vehicles in years 1950 to 2000
احضر هذا الفيديو للنهاية حتى لو بتعرف الحل، لانه سنناقش اساليب متقدمه ومقارنات مهمة
Complete and Continue
Discussion
55
comments
Load more
55 comments