1 Understanding the Common Language Runtime (CLR) and the .NET framework

2 Using CLR with SQL Server 2012

3 Writing stored procedures with C# .NET

4 Writing functions with .NET

5 Choosing between T-SQL vs. CLR

1 Exploring a real-world INSERT procedure

2 Exploring a real-world UPDATE procedure

3 Implementing logging on DELETE

1 Using -after- triggers

2 Using -instead of- triggers

3 Using nested triggers

4 Using database-level triggers

1 Creating a user-defined function

2 Exploring single-value functions

3 Exploring table value functions

1 Creating a stored procedure

2 Modifying a stored procedure

3 Returning data using data sets

4 Using input and output parameters

5 Returning data using cursors

6 Using security and permissions

1 Comparing triggers, functions, and procedures

2 Why use a stored procedure

3 Why use functions

4 Why use triggers

1 Introducing query execution plans

2 Viewing index usage and statistics

1 Understanding normalization

2 Understanding table relationships

3 Understanding joins

4 Using joins in a query

1 Writing subqueries

2 Using EXISTS

3 Introducing views

4 Introducing common table expressions

1 Querying a table with SELECT

2 Using aliases in your SELECT statements

3 Using string concatenation

4 Using CASE expressions

1 Queries using date and time

2 Queries using character data types

3 Queries using character functions

1 Understanding stored procedures

2 Understanding T-SQL programming elements

3 Implementing transactions

4 Error handling

1 Understanding order

2 Sorting results with ORDER BY

3 Grouping results with GROUP BY

4 Using the TOP option

5 Using aggregates

1 Filtering duplicates with DISTINCT

2 Introducing the WHERE clause

3 WHERE clause relational operators

4 Filtering text

5 Working with NULL

1 Creating a basic web form and connecting to a database

2 Executing a stored procedure

3 Passing parameters

4 Getting return values