Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
To get the most out of this course you should have a little background knowledge. Specifically, I expect you to know the basics of any version of Microsoft SQL Server. You will need to have some familiarity with SQL Server Management Studio and some knowledge of the T-SQL language. Things like UPDATE, INSERT, and DELETE statements. A great way to pick up this knowledge is SQL Server 2008 Essential Training with Simon Allardice here in the lynda.com online training library.
Also, in the last two sections of the course we will be running some C# code. To get the most out of these sections you should be familiar with the basics of C# as well as the basics of Visual Studio. These topics are covered in C# Essential Training with Joe Marini also in the lynda.com online training library.
There are currently no FAQs about SQL Server: Triggers, Stored Procedures, and Functions.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.