Lynda – SQL Server: Triggers, Stored Procedures, and Functions

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.

Topics include:

• Comparing triggers, functions, and stored procedures
• Installing and configuring SQL Server
• Creating a stored procedure
• Returning data using data sets
• Creating user-defined functions
• Using “after,” “instead,” and nested triggers
• Modifying existing stored procedures
• Implementing logging on DELETE
• Choosing between T-SQL and CLR
• Executing a stored procedure
• Passing parameters

Table if content

Introduction

• Welcome
• What you should know
• Using the exercise files

1. Getting Started

• Comparing triggers, functions, and procedures
• Why use a stored procedure?
• Why use functions?
• Why use triggers?

2. Installing SQL Server

• Configuring your environment
• Downloading and installing a sample database

3. Stored Procedures

• Creating a stored procedure
• Modifying a stored procedure
• Returning data using data sets
• Returning data using cursors
• Using input and output parameters
• Using security and permissions
• Using transactions

4. User-Defined Functions

• Creating a user-defined function
• Exploring single-value functions
• Exploring table value functions

5. Triggers

• Using “after” triggers
• Using “instead of” triggers
• Using nested triggers
• Using database-level triggers

6. Putting It All Together

• Exploring a real-world INSERT procedure
• Exploring a real-world UPDATE procedure
• Implementing logging on DELETE

7. Using CLR Assemblies

• Understanding the Common Language Runtime (CLR) and the .NET framework
• Using CLR with SQL Server 2012
• Writing stored procedures with C# .NET
• Writing functions with .NET
• Choosing between T-SQL vs. CLR

8. Exploring an ASP.NET Web Application

• Creating a basic web form and connecting to a database
• Executing a stored procedure
• Passing parameters
• Getting return values

Conclusion

• Next steps

 

Uploaded.net

1. http://ul.to/jxtlvqt4

Cloudzer.net

1. http://clz.to/file/oejh2xqu

Rapidgator.net

1. http://rapidgator.net/file/65841835/ldsqlsvvrtrgerstreprofunc_tutdownload.com.rar.html