arrow_back
1.Course Introduction
About this course
2.Understanding the sample data
1-Create database
2-Customers table
3-Products table
4-Orders table
5-Invoice table
6-Additional Note
Table Creation - Scripts
3. Level 1: Selecting Data
Scenario 1-Listing Website URL
Scenario 2-Finding Delivery address
Scenario 3-Display Credit limit
Scenario 4-Search names
Scenario 5-Exclude location
Scenario 6-Most Recent Validity
Selecting Data - SQL Scripts
4. Level 2: Joining Tables
Scenario 1-Finding Order and Invoice date
Scenario 2-Sales Person Assigned
Scenario 3-Orders placed
Scenario 4-Finding the Customers
Scenario 5-Order details
Scenario 6-Counting Orders
Joining Tables - SQL Scripts
5. Level 3: Advanced Selecting
Scenario 1-Delivery Postal code
Scenario 2-Accounts opened
Scenario 3-Lowest Unit price
Scenario 4-Marketing Comments
Scenario 5-Location of Manufacture
Scenario 6-Stock Item details
Advance Select - SQL Scripts
6. Level 4: Grouping Data
Scenario 1-Latest Order received
Scenario 2-Find Suppliers
Scenario 3-Contact Information
Scenario 4-Orders received
Scenario 5-Inventory size
Scenario 6-Counting Invoices
Grouping Data - SQL Scripts
7. Course completion
Thank You!