SQL Server: Triggers Stored Procedures and Functions
Created By
Martin Guidry via LinkedIn Learning
- 0
- 1-2 hours worth of material
- LinkedIn Learning
- English
Course 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.
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.
Course Circullum
Introduction
- Welcome
- What you should know
- Using the exercise files
- Comparing triggers, functions, and procedures
- Why use a stored procedure?
- Why use functions?
- Why use triggers?
- Configuring your environment
- Downloading and installing a sample database
- 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
- Creating a user-defined function
- Exploring single-value functions
- Exploring table value functions
- Using "after" triggers
- Using "instead of" triggers
- Using nested triggers
- Using database-level triggers
- Exploring a real-world INSERT procedure
- Exploring a real-world UPDATE procedure
- Implementing logging on DELETE
- 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
- Creating a basic web form and connecting to a database
- Executing a stored procedure
- Passing parameters
- Getting return values
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Welcome
- What you should know
- Using the exercise files
- Comparing triggers, functions, and procedures
- Why use a stored procedure?
- Why use functions?
- Why use triggers?
- Configuring your environment
- Downloading and installing a sample database
- 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
- Creating a user-defined function
- Exploring single-value functions
- Exploring table value functions
- Using "after" triggers
- Using "instead of" triggers
- Using nested triggers
- Using database-level triggers
- Exploring a real-world INSERT procedure
- Exploring a real-world UPDATE procedure
- Implementing logging on DELETE
- 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
- Creating a basic web form and connecting to a database
- Executing a stored procedure
- Passing parameters
- Getting return values
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:1-2 hours worth of material
- Language CC: