arrow_back
1. Course Introduction
About this course
2. About Sample data
1-Create database
2-Customers table
3-Products table
4-Orders table
5-Invoice table
6-Additional Note
Table creation - SQL Scripts
3. Module 1: Real-World Scenarios on SQL JOINS
Scenario 1- Find Sales People
Scenario 2- Display Order dates
Scenario 3- Specific Orders
Scenario 4- Filter Customer Orders
Scenario 5- Find Invoices
Scenario 6- Invoices of specific Orders
Scenario 7- Filter Invoice details
Scenario 8- Get Delivery Instructions
Scenario 9- Invoice Date details
Scenario 10- Get Invoices for large Orders
Module 1- SQL Scripts
4. Module 2: Real-World Scenarios on SQL JOINS
Scenario 11- Most Recent Invoice
Scenario 12- Finding Order details
Scenario 13- Listing Invoices
Scenario 14- Order placed
Scenario 15- Finding the Customers
Scenario 16- Order details
Scenario 17- Products made Available
Scenario 18- Calculate Average orders
Scenario 19- Counting Invoices
Scenario 20- Stock Item details
Module 2- SQL scripts
5. Module 3: Real-World Scenarios on SQL JOINS
Scenario 21- Counting Orders
Scenario 22- Most Recent Order
Scenario 23- Oldest Order date
Scenario 24- Country of Manufacture
Scenario 25- Account Open Date
Scenario 26- Orders by Postal Code
Scenario 27- Filter Customer Names
Scenario 28- Invoices by Postal Code
Scenario 29- Highest Credit Limit
Scenario 30- Invoices by Order count
Module 3- SQL scripts
Course completion
Thank You!