Search 6,000+ CA Community College Courses

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

Go to class Write review

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

Reviews

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

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.