MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Triggers, Stored Procedures, and Functions

Course Summary

Investigates several key database-programming concepts and how to combine them to create a high-quality database with Microsoft SQL Server.     

  • +

    Course Syllabus

       What you should know 
       Using the exercise files 
    1. Getting Started
       Comparing triggers, functions, and procedures 
       Why use a stored procedure? 
       Why use functions? 
       Why use triggers? 
    2. Installing SQL Server
       Configuring your environment 
       Downloading and installing a sample database 
    3. Stored Procedures
       Creating a stored procedure 
       Modifying a stored procedure 
       Returning data using data sets 
       Returning data using cursors 
       Using input and output parameters 
       Using security and permissions 
       Using transactions 
    4. User-Defined Functions
       Creating a user-defined function 
       Exploring single-value functions 
       Exploring table value functions 
    5. Triggers
       Using "after" triggers 
       Using "instead of" triggers 
       Using nested triggers 
       Using database-level triggers 
    6. Putting It All Together
       Exploring a real-world INSERT procedure 
       Exploring a real-world UPDATE procedure 
       Implementing logging on DELETE 
    7. Using CLR Assemblies
       Understanding the Common Language Runtime (CLR) and the .NET framework 
       Using CLR with SQL Server 2012 
       Writing stored procedures with C# .NET 
       Writing functions with .NET 
       Choosing between T-SQL vs. CLR 
    8. Exploring an ASP.NET Web Application
       Creating a basic web form and connecting to a database 
       Executing a stored procedure 
       Passing parameters 
       Getting return values 
       Next steps 

Course Fee:
USD 25

Course Type:


Course Status:



2 - 3 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top