Introduction
Pulling the Data from Database
-
SQL Query to Select Data from a Table (12:39)
-
Selecting top N records (5:04)
-
Narrowing down result set with WHERE clause (7:20)
-
Pattern Matching in WHERE clause using LIKE (4:46)
-
Where In... SQL Clause - Using Multiple values from a column in Where Clause (5:05)
-
Sorting the Result set (4:48)
-
Selecting unique values (3:08)
-
Joining multiple tables to get the desired result set (10:25)
-
Using Alias in SQL (7:38)
-
Aggregating the Data in SQL - Count, Min and Max (13:04)
-
Aggregating Data - Sum and Average (4:05)
-
Null Values in Aggregations (3:52)
-
Using Aggregated Values in WHERE Clause (4:04)
Manipulating Data in Select Statement
Other Key SQL Statements
