Responsible myanmaronlineschool2020
Last Update 09/06/2025
Completion Time 1 hour 53 minutes
Members 1
  • Student Resources
    • Student Download Folder.zip
      New
  • Introduction
    • 1-1_Course Objectives and Introduction
      New
  • Basic SQL Queries
    • 2 1 Chapter Introduction
      New
    • 2 2 Installation and Introduction to Azure Data Studio
      New
    • 2 3 Creating a Connection to a Database
      New
    • 2 4 What is Adventure Works
      New
    • 2 5 Example SQL Code
      New
    • 2 6 Saving Your Queries in Notepad
      New
    • 2 7 SELECT and FROM
      New
    • 2 8 SELECT Specific Columns
      New
    • 2 9 Creating a Column Alias
      New
    • 2 10 Using WHERE to Filter Rows
      New
    • 2 11 CheckPoint 1
      New
    • 2 12 Limiting Results to 1 Invoice Number for Testing
      New
    • 2 13 Using GROUP BY to Combine Rows
      New
    • 2 14 Using GROUP BY to Combine Invoice Numbers
      New
    • 2 15 Using HAVING to Filter Grouped Rows
      New
    • 2 16 Filtering Grouped Invoices with HAVING
      New
    • 2 17 SQL Order of Operations
      New
    • 2 18 Using ORDER BY to Sort Query Rows
      New
    • 2 19 Recap and Common Errors
      New
    • 2 20 Filtering Rows TOP N
      New
    • 2 21 Filtering Rows TOP N Percent
      New
    • 2 22 Filtering Rows OFFSET FETCH
      New
    • 2 23 FIltering Rows DISTINCT
      New
    • 2 24 ORDER BY Another Column
      New
    • 2 25 Chapter Summary & Student Exercise 1a
      New
    • 2 26 Student exercise 1a review
      New
    • 2 27 Student exercise 1b
      New
    • 2 28 Student Exercise 1b Review
      New
    • 2 29 Student Exercise 1c
      New
    • 2 30 Student Exercise 1c Review
      New