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 48: Get the highest Manufacturers manufactured the highest number of models
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock