This course covers designing database objects that define and retrieve data, extend the functionality of the server, and perform actions.
Objectives:
Use indexes and partitioning
Discuss the various objects supported by SQL Server 2005
Examine the different types of triggers
Explain the scheduled job execution and alerts produced by the SQL Server Agent
Topics:
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
