Views and User Defined Functions in Microsoft SQL Server 2008 R2 (E_Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Feb 15, 2011
Language:English
Audiences:Developer
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This two-hour course provides you with the knowledge and skills required to implement views and user defined functions in Microsoft SQL Server 2008 R2.

This course covers the following topics.
Describing views and functions
Creating and managing views
Creating and managing functions
Using error handling and execution contexts in functions
Best practices for implementing views and user defined functions

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:
A good general knowledge of database concepts.
Experience working with Windows and programming concepts.
Understanding of server management concepts such as roles and tracing.
A basic understanding of XML.

Objective: 

Describe views and functions.
Create and manage views.
Create and manage functions.
Use error handling and execution contexts in functions.
Describe best practices for implementing views and user defined functions..

Prerequisites: 

None

For more information on Views and User Defined Functions in Microsoft SQL Server 2008 R2 (E_Learning) please feel free to contact us online or call us at 416-513-1535.