SQL Fundamental Course
Responsible | myanmaronlineschool2020 |
---|---|
Last Update | 09/06/2025 |
Completion Time | 1 hour 53 minutes |
Members | 1 |
Share This Course
Share Link
Share on Social Media
Share by Email
Please login to share this SQL Fundamental Course by email.
-
Student Resources
-
Student Download Folder.zipNew
-
-
Introduction
-
1-1_Course Objectives and IntroductionNew
-
-
Basic SQL Queries
-
2 1 Chapter IntroductionNew
-
2 2 Installation and Introduction to Azure Data StudioNew
-
2 3 Creating a Connection to a DatabaseNew
-
2 4 What is Adventure WorksNew
-
2 5 Example SQL CodeNew
-
2 6 Saving Your Queries in NotepadNew
-
2 7 SELECT and FROMNew
-
2 8 SELECT Specific ColumnsNew
-
2 9 Creating a Column AliasNew
-
2 10 Using WHERE to Filter RowsNew
-
2 11 CheckPoint 1New
-
2 12 Limiting Results to 1 Invoice Number for TestingNew
-
2 13 Using GROUP BY to Combine RowsNew
-
2 14 Using GROUP BY to Combine Invoice NumbersNew
-
2 15 Using HAVING to Filter Grouped RowsNew
-
2 16 Filtering Grouped Invoices with HAVINGNew
-
2 17 SQL Order of OperationsNew
-
2 18 Using ORDER BY to Sort Query RowsNew
-
2 19 Recap and Common ErrorsNew
-
2 20 Filtering Rows TOP NNew
-
2 21 Filtering Rows TOP N PercentNew
-
2 22 Filtering Rows OFFSET FETCHNew
-
2 23 FIltering Rows DISTINCTNew
-
2 24 ORDER BY Another ColumnNew
-
2 25 Chapter Summary & Student Exercise 1aNew
-
2 26 Student exercise 1a reviewNew
-
2 27 Student exercise 1bNew
-
2 28 Student Exercise 1b ReviewNew
-
2 29 Student Exercise 1cNew
-
2 30 Student Exercise 1c ReviewNew
-