Books & Videos

Table of Contents

Chapter: Introduction

T-SQL Fundamentals LiveLessons: Introduction

03m 23s

Chapter: Lesson 1: Introduction to Databases

Learning Objectives

00m 28s

1.1 What is a Database?

04m 44s

1.2 Creating a Database

03m 37s

1.3 Creating a Table

07m 22s

1.4 Creating Check Constraints

05m 52s

1.5 Establishing Relationships between Tables

05m 45s

Chapter: Lesson 2: T-SQL Basics

Learning Objectives

00m 28s

2.1 The SELECT Statement

03m 39s

2.2 The FROM Keyword

01m 36s

2.3 The WHERE Clause

03m 39s

2.4 IN and BETWEEN

03m 57s

2.5 The ORDER BY Clause

02m 21s

Chapter: Lesson 3: TSQL - Beyond the Basics

Learning Objectives

00m 33s

3.1 The DISTINCT Keyword

02m 1s

3.2 The GROUP BY Clause

01m 31s

3.3 Aggregate Functions

04m 25s

3.4 The HAVING Clause

01m 25s

3.5 Combining Conditions

06m 38s

3.6 Top Values Queries

04m 3s

3.7 Working with Aliases

02m 3s

3.8 Working with Null

02m 22s

Chapter: Lesson 4: Join Types

Learning Objectives

00m 22s

4.1 Inner Joins

01m 55s

4.2 Outer Joins

02m 4s

4.3 Full Joins

01m 37s

4.4 Self Joins

05m 15s

Chapter: Lesson 5: Specialized T-SQL Queries

Learning Objectives

00m 37s

5.1 Union Queries

05m 59s

5.2 Subqueries

02m 0s

Chapter: Lesson 6: Modifying Data with Action Queries

Learning Objectives

00m 25s

6.1 The UPDATE Statement

03m 35s

6.2 The INSTER Statement

02m 49s

6.3 The SELECT INTO Statement

01m 22s

6.4 The DELETE Statement

01m 29s

6.5 The TRUNCATE Statement

00m 56s

Chapter: Lesson 7: T-SQL Functions

Learning Objectives

00m 36s

7.1 Numeric Functions

03m 1s

7.2 String Functions

04m 26s

7.3 Date/Time Functions

05m 52s

7.4 Working with Nulls

04m 21s

Chapter: Lesson 8: Working with SQL Server Views

Learning Objectives

00m 29s

8.1 Creating a Simple View

05m 31s

8.2 Creating Views Based on Data in Multiple Tables

04m 5s

8.3 Views and Subqueries

02m 22s

8.4 Views and Outer Joins

03m 0s

8.5 Sorting View Results

03m 14s

8.6 Views and Top Values

03m 36s

8.7 Views and Functions

02m 53s

8.8 Using Views to Secure Data

00m 58s

8.9 Modifying Data in a View

02m 48s

Chapter: Lesson 9: Designing SQL Server Stored Procedures

Learning Objectives

00m 38s

9.1 Stored Procedures Basics

04m 18s

9.2 Declaring and Working with Variables

04m 2s

9.3 Controlling the Flow

10m 43s

9.4 The SET NOCOUNT Statement

00m 46s

9.5 Using the @@ Functions

05m 26s

9.6 Working with Paramaters

06m 14s

Chapter: Lesson 10: Enhancing the Stored Procedures that You Build

Learning Objectives

00m 36s

10.1 Working with Cursors

04m 17s

10.2 Errors and Error Handling

08m 42s

10.3 Modifying Data with Stored Procedures

03m 38s

10.4 Stored Procedures and Transactions

03m 19s

10.5 Stored Procedures and Temporary Tables

02m 54s

10.6 Stored Procedures and Cursors

01m 6s

10.7 Stored Procedures and Security

06m 29s

Chapter: Lesson 11: Building and Working with User-Defined Functions

Learning Objectives

00m 29s

11.1 User-defined Functions Explained

06m 47s

11.2 Scalar Functions

03m 12s

11.3 Inline Table-Valued Functions

02m 13s

11.4 Multi-Statement Table-Valued Functions

01m 57s

Chapter: Lesson 12: Creating and Working with Triggers

Learning Objectives

00m 26s

12.1 Triggers Explained

00m 34s

12.2 Creating Triggers

06m 8s

Chapter: Lesson 13: Analyzing Performance

Learning Objectives

00m 29s

13.1 Determining the Query Execution Plan

02m 47s

13.2 Viewing the Query Statistics

01m 1s

13.3 Using the SQL Profiler

04m 23s

Chapter: Summary

T-SQL Fundamentals LiveLessons: Summary

01m 4s