Designing a Database Access Strategy with Microsoft® SQL Server„¢ 2005(3304)


In this 2-hour premium course you will learn how to address data retrieval requirements through stored procedures, user defined functions and security context. In the lab you will design a database to which you will apply these concepts.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft® SQL Server™ 2005.



  • Design for Secure Data Access
    • Use secure execution context
    • Implement data access policy
  • Design User-Defined Functions
    • Create Transact-SQL User-Defined Functions
    • Create User-Defined Functions
    • Create User-Defined Aggregate Functions
  • Design Stored Procedures
    • Create Transact-SQL Stored Procedures
    • Create CLR Stored Procedures


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-DDA-SS205
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend