SQL Server: Triggers, Stored Procedures, and Functions

Product type
Level
Logo Lynda

Need more information? Get more details on the site of the provider.

Description

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. Topics include: Comparing triggers, functions, and stored procedures Installing and configuring SQL Server Creating a stored pr…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, PL/SQL, Microsoft ProClarity, Client - Server, and Oracle.

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. Topics include: 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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.