Join Martin Guidry for an in-depth discussion in this video What you should know, part of SQL Server: Triggers Stored Procedures and Functions.
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.
- 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
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.