Product Homepage: [url]http://www.lynda.com/SQL-Server-tutorials/SQL-Server-Triggers-Stored-Procedures-Functions/104964-2/transc
ript[/url]
This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database.
Introduction 2m 15s
Welcome 51s
What you should know 51s
Using the exercise files 33s
1. Getting Started 11m 1s
Comparing triggers, functions, and procedures 3m 25s
Why use a stored procedure? 4m 59s
Why use functions? 1m 27s
Why use triggers? 1m 10s
2. Installing SQL Server 6m 2s
Configuring your environment 4m 53s
Downloading and installing a sample database 1m 9s
3. Stored Procedures 26m 25s
Creating a stored procedure 2m 46s
Modifying a stored procedure 2m 34s
Returning data using data sets 3m 45s
Returning data using cursors 3m 45s
Using input and output parameters 5m 24s
Using security and permissions 5m 24s
Using transactions 2m 47s
4. User-Defined Functions 11m 56s
Creating a user-defined function 4m 59s
Exploring single-value functions 4m 18s
Exploring table value functions 2m 39s
5. Triggers 9m 31s
Using "after" triggers 3m 47s
Using "instead of" triggers 2m 9s
Using nested triggers 1m 38s
Using database-level triggers 1m 57s
6. Putting It All Together 12m 43s
Exploring a real-world INSERT procedure 5m 32s
Exploring a real-world UPDATE procedure 3m 13s
Implementing logging on DELETE 3m 58s
7. Using CLR Assemblies 19m 38s
Understanding the Common Language Runtime (CLR) and the .NET fr
amework 1m 52s
Using CLR with SQL Server 2012 4m 11s
Writing stored procedures with C# .NET 5m 51s
Writing functions with .NET 5m 7s
Choosing between T-SQL vs. CLR 2m 37s
8. Exploring an ASP.NET Web Application 11m 35s
Creating a basic web form and connecting to a database 2m 57s
Executing a stored procedure 2m 4s
Passing parameters 3m 41s
Getting return values 2m 53s
Conclusion 1m 43s
Next steps 1m 43s
x2WEog