|
Provided by: Serebra Learning Corporation MS SQL Server 2000: Design and Implementation Part 3: Managing ObjectsMS SQL Server |
 |
Training
Provided by Serebra Learning Corporation
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.
|
|
||||||||||
MS SQL Server 2000: Design and Implementation Part 3: Managing Objects
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
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).
Objective
- Identify the features of views.
- Identify the considerations for creating views.
- Create a view by using TransactSQL.
- Match the different userdefined functions with their characteristics.
- Create a userdefined function by using TransactSQL.
- 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.
Topics Include
Unit 1: Views
- Identify the features of views.
- 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
- 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
- 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
- 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.
Duration
7
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
