arrow_back
Introduction
Introduction to Course
Download and Install Azure Data Studio on Mac and Windows
Installation Introduction
Windows Installation-SQL Server & Azure Data Studio
MAC Installation-SQL Server & Azure Data Studio
30 Scenarios to learn SQL quickly
Scenario 1 - Sorting a result set
Scenario 2 - Sorting using expression
Scenario 3 - Retrieve a percentage of the result set
Scenario 4 - Retrieve distinct values
Scenario 5 - Return values based on condition
Scenario 6 - Replacing NULL Values
Scenario 7 - Replacing names temporarily
Scenario 8 - Filtering out Information
Scenario 9 - Filtering on more than 1 condition
Scenario 10 - Search within a range of values
Scenario 11 - Filtering out data by comparing value
Scenario 12 - Finding rows based on a list of values
Scenario 13 - Finding rows having a specific string
Scenario 14 - Filtering rows having no data
Scenario 15 - Filtering rows based on values in sub-query
Scenario 16 - Converting to Upper case or Lower case
Scenario 17 - Extracting specific characters
Scenario 18 - Using INNER JOIN
Scenario 19 - Using LEFT JOIN
Scenario 20 - Using RIGHT JOIN
Scenario 21 - Using FULL JOIN
Scenario 22 - Return number of items
Scenario 23 - Compute the total amount
Scenario 24 - Compute the average value
Scenario 25 - Compute the lowest value
Scenario 26 - Compute the largest value
Scenario 27 - Combine values from two columns
Scenario 28 - Create a calculated field
Scenario 29 - Arrange rows in groups
Scenario 30 - Filter groups based on condition