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.
- 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
Hi! I'm Martin Guidry and welcome to SQL Server: Triggers, Stored Procedures, and Functions. I'll start by showing you how to create stored procedures using T-SQL or C# code. Then show you how to use SQL Server Management Studio to simplify database development. We'll see how to create triggers using SQL Server Management Studio and we'll take a look at the Common Language Runtime and how it enables us to create more powerful, faster performing stored procedures, and functions. We'll end with using Visual Studio to create a web application that utilizes the store procedures created earlier in the course.
We'll be covering all these features plus best practices and techniques for avoiding common problems. Now let's get started with SQL Server: Triggers, Stored Procedures, and Functions.
There are currently no FAQs about SQL Server: Triggers, Stored Procedures, and Functions.
SQL Server 2008 Essential Training1,609,014 Views
SQL Essential Training1,927,099 Views
PHP with MySQL Essential Training3,907,848 Views
ASP.NET Essential Training1,800,850 Views
SQL Server Reporting Services in Depth508,991 Views
C# Essential Training882,903 Views
Foundations of Programming: Fundamentals6,728,971 Views
Foundations of Programming: Object-Oriented Design3,170,273 Views