Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server: Triggers Stored Procedures and Functions

via LinkedIn Learning

Overview

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

Taught by

Martin Guidry

Related Courses

Reviews

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

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free