SQL Server: Triggers Stored Procedures and Functions

Go to class

Write Review

Free Online Course: SQL Server: Triggers Stored Procedures and Functions provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL Server: Triggers Stored Procedures and Functions is taught by Martin Guidry.

via LinkedIn Learning

1-2 hours worth of material

Self Paced

Investigates several key database-programming concepts and how to combine them to create a high-quality database with Microsoft SQL Server.

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.

Syllabus

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
- Using input and output parameters
- Returning data using cursors
- 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

0, based on 0 Course votes at GetYourEducation

Start your review of SQL Server: Triggers Stored Procedures and Functions

Add review ->

Language

English
Certificate
Certificate Available
Date of Start
24th September, 2012
Price
Free Trial Available
Provider
LinkedIn Learning
Taught By

Martin Guidry
Share this course