Sizzling Minerals
A unique Life-Changing Product that Everyone Needs

We can reveal a Critical Health Secret most people are not aware of…


SQL Server 2000 Database Design MCSE 70-229: Database Programming

Total Time: 4 hour(s)

Summary: 
This course shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming.

Ojectives: 
After completing this course, students will be able to:
Create, modify, and execute stored procedures
Create and modify triggers
Create and execute user-defined functions
Work with transactions, cursors, and locks

Topics: 
Introduction to stored procedures
Guidelines for creating stored procedures
Creating stored procedures
Modifying stored procedures
Working with stored procedures
Error handling within stored procedures
Introduction to triggers
Creating triggers
Using INSTEAD OF triggers
Modifying triggers
Introduction to functions and UDFs
Scalar-valued and table-valued UDFs
System UDFs and functions
Obtaining information about UDFs
Transactions
Transaction isolation levels
Cursors
Locks

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

 
   
 
  Home | Privacy | Contact Us