What you should know SQL Server
Video: What you should know SQL ServerWhat you should know provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions
- Next steps
What you should know provides you with in-depth training on Business. Taught by Martin Guidry as part of the 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
What you should know
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.