Informationen über Kurs 73482 - Microsoft SQL Server 2000 Designing and Implementing Databases - Part 3: Managing Objects - Online
-
Ziele
- 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.
-
Anforderungen
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).
-
Titel
Kurs 73482 - Microsoft SQL Server 2000 Designing and Implementing Databases - Part 3: Managing Objects
-
Inhalt
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.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.70 CEUs
Total Learning Time
6 to 8 hours
Objectives
Unit 1: Views 2 hours
- Identify the considerations for creating views.
- Create a view by using Transact-SQL.
- Identify the syntax used to alter views.
- Identify the features of broken ownership chains.
- Encrypt a view definition by using the SQL Server Enterprise Manager.
- Modify data by using a view.
- Identify the considerations that affect view performance.
- Identify the considerations for using indexed views.
- Identify the considerations for partitioning data by using views.
Unit 2: User-Defined Functions 2 hours
- Match the different user-defined functions with their characteristics.
- Create a user-defined function by using Transact-SQL.
- Identify characteristics of schema binding.
- Create a scalar user-defined function.
- Create a multi-statement user-defined function.
- Create an inline user-defined function.
- Identify the requirements for setting permissions for user-defined functions.
- Alter a user-defined function.
Unit 3: Stored Procedures 1 - 2 hours
- Identify the features of stored procedures.
- Identify the considerations for creating stored procedures.
- Identify the features of encrypting stored procedures.
- Create a stored procedure by using SQL Query Analyzer.
- Identify steps in creating a stored procedure by using the Create Stored Procedure Wizard.
- Identify the syntax used to execute a stored procedure.
- Identify the characteristics of extended stored procedures.
- Identify considerations for modifying a stored procedure.
- Identify the considerations for using input parameters.
- Execute a stored procedure by using input parameters.
- Execute a stored procedure by using output parameters.
- Identify the methods for optimizing stored procedures by recompiling.
- Identify characteristics of error message handling.
- Create a custom error message.
- Trace a stored procedure by using SQL Profiler.
Unit 4: Triggers 1 - 2 hours
- Identify the characteristics of triggers.
- Identify the advantages of using triggers.
- Identify guidelines for creating triggers.
- Identify the syntax used to alter a trigger.
- Execute a script file that creates a trigger.
- Create a trigger that updates derived data.
- Identify the considerations for using triggers.
- Sequence the steps of how an INSERT trigger is fired.
- Identify the considerations for applying DELETE triggers.
- Sequence the steps of how an UPDATE trigger works.
- Sequence the steps of how an INSTEAD OF trigger works.
- Identify the characteristics of nested triggers.
- Identify the characteristics of recursive triggers.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
