SQL Server: Transact-SQL Basic Data Retrieval

—Introduction 1m 17s
—Thinking in 'Sets' 1m 4s
—Where to Begin? 0m 31s
—SELECT Clause 1m 8s
—Demo: SELECT Clause 3m 5s
—Column Aliases 0m 45s
—Demo: Column Aliases 1m 44s
—Identifiers 0m 53s
—Demo: Regular versus Delimited Identifiers 2m 45s
—Semicolon Statement Terminator 0m 32s
—FROM Clause 0m 44s
—Demo: FROM Clause 3m 40s
—Table Aliases 0m 56s
—Demo: Table Aliases 1m 50s
—Expressions, Operators, Predicates 0m 42s
—WHERE Clause 0m 44s
—Demo: WHERE Clause 3m 54s
—DISTINCT 0m 35s
—Demo: DISTINCT 2m 44s
—TOP 1m 13s
—Demo: TOP 2m 2s
—GROUP BY Clause 0m 38s
—Demo: GROUP BY Clause 3m 40s
—HAVING Clause 0m 34s
—Demo: HAVING Clause 3m 24s
—ORDER BY Clause 0m 58s
—Demo: ORDER BY Clause 2m 15s
—Query Paging 0m 55s
—Demo: Query Paging 1m 52s
—Binding Order 0m 31s
—Demo: Binding Order 1m 27s
—Best Practice: Commenting Your Code 1m 7s
—Demo: Commenting Your Code 1m 8s

—Introduction 0m 53s
—Inner Joins 0m 55s
—Demo: Inner Joins 3m 20s
—Outer Joins 1m 2s
—Outer Joins (2) 0m 37s
—Demo: Outer Joins 5m 0s
—Cross Joins 0m 38s
—Demo: Cross Joins 2m 10s
—Self Joins 0m 30s
—Demo: Self Joins 1m 55s
—Equi vs. Non-Equi Joins 0m 39s
—Demo: Equi vs. Non-Equi Joins 1m 31s
—Multi-Attribute Joins 0m 20s
—Demo: Multi-Attribute Joins 2m 51s
—Joining More than Two Tables 0m 38s
—Demo: Joining More than Two Tables 4m 24s
—CROSS APPLY Operator 0m 40s
—Demo: CROSS APPLY and OUTER APPLY Operator 4m 13s
—Joining Sub-Queries 0m 16s
—Defining the Sub-Query 0m 48s
—Demo: Using Sub-Queries 2m 58s
—UNION Operator 1m 12s
—Demo: UNION Operator 2m 54s
—INTERSECT and EXCEPT 0m 47s
—Demo: INTERSECT and EXCEPT Operators 2m 57s
—Data Types and Joining Tables 1m 7s
—Introduction to Common Table Expressions 0m 34s
—Demo: Introduction to Common Table Expressions 3m 41s

—Introduction 0m 41s
—Aggregate Functions 1m 10s
—Demo: Aggregate Functions 6m 26s
—Aggregate Functions (2) 0m 54s
—Demo: Aggregate Functions (2) 2m 23s
—Mathematical Functions 1m 10s
—Demo: Mathematical Functions 3m 57s
—OVER Clause 0m 40s
—Ranking Functions 0m 54s
—Demo: Ranking Functions 5m 30s
—Conversion Functions 1m 11s
—Demo: Conversion Functions 4m 15s
—Validating Data Types 0m 21s
—Demo: Validating Data Types 1m 48s
—System Time Functions 0m 58s
—Demo: System Time Functions 1m 38s
—Returning Date and Time Parts 0m 52s
—Demo: Returning Date and Time Parts 2m 25s
—Constructing Date and Time Values 0m 38s
—Demo: Constructing Date and Time Values 1m 24s
—Constructing Date and Time Values (2) 0m 26s
—Demo: Constructing Date and Time Values (2) 1m 40s
—Calculating Time Differences 0m 27s
—Demo: Calculating Time Differences 1m 42s
—Modifying Dates 0m 47s
—Demo: Modifying Dates 3m 58s
—Logical Functions 0m 43s
—Demo: Logical Functions 1m 42s
—Logical Functions (2) 0m 30s
—Demo: Logical Functions (2) 2m 52s
—Working with NULL 0m 47s
—Demo: Working with NULL 2m 30s
—String Functions 0m 38s
—Demo: String Functions 1m 28s
—String Functions (2) 0m 41s
—Demo: String Functions (2) 2m 5s
—String Functions (3) 0m 30s
—Demo: String Functions (3) 0m 54s
—String Functions (4) 0m 21s
—Demo: String Functions (4) 1m 0s
—String Functions (5) 0m 52s
—Demo: String Functions (5) 5m 48s
—String Functions (6) 0m 51s
—Demo: String Functions (6) 3m 34s
—Analytic Functions 0m 42s
—Demo: Analytic Functions 7m 34s
—Analytic Functions (2) 1m 11s
—Demo: Analytic Functions (2) 6m 20s
—Course Summary 0m 42s