|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Design Implement Databases Part 3 Managing Objects |
 |
Course Overview
This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers.
Learn To
- Identify the features of views.
- Identify the considerations for creating views.
- Create a view by using Transact-SQL.
- Match the different user-defined functions with their characteristics.
- Create a user-defined function by using Transact-SQL.
- Identify characteristics of schema binding.
- Identify the features of stored procedures.
- Identify the considerations for creating stored procedures.
- Identify the features of encrypting stored procedures.
- Identify the characteristics of triggers.
- Identify the advantages of using triggers.
- Identify guidelines for creating triggers.
Audience
The intended audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator. In addition, students should have taken the first two parts of this series (73480 and 73481).
|
|
||||||||||
