Home └SQL Fundamental Course
SQL Fundamental Course

SQL Fundamental Course

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