SQL Server 2005 / 2007 Install & Administration

SQL Server 2005 / 2007 Install & AdministrationThree Day Course Course Aims: This class consists of three days of training that focus on the new features available in SQL Server 2005 / 2007. You will learn how to install SQL Server 2005 / 2007; use the SQL Server 2005 / 2007 client tools to administer databases and create database applications; administer the database engine; use SQL Server Integration Services (SSIS) to import, export, and transform data; use SQL Server Replication to synchronize data between databases; use SQL Server Notification Services (SSNS) to push data updates to subscribing users; and use SQL Server Service Broker to establish asynchronous communications between database applications.Course Outline: An Overview of SQL Server 2005 / 2007 •New Features•Database Roles•Client ToolsInstalling SQL Server 2005 / 2007 •Preparing For Installation•Setup User Interface•Installing Express Edition•Configuring an New Instance SQL Server Notification Services (SSNS) •Overview•Subscription Management•Event Collection•Subscription Processing•Formatting and DeliveryData Availability •Disaster Recovery•High Availability•Backup•RestoreSecurity •Overview•Catalog Views•Security Functions•Cryptographic Functions•CLR Integration•Native XML Web Services•Integration Services•Analysis Services•Replication•Reports•Notifications•Service BrokerSQL Server Integration Services (SSIS) •What Happened To DTS?•What is ETL?•Integration Services Projects•SSIS Objects•Expressions SQL Server Service Broker •Overview•Conversations•Message Ordering and Coordination•Transactional Asynchronous Programming•Loosely Coupled Applications•ComponentsSQL Server Replication •Overview•Replication Types•Agents•Implementing•Administering•EnhancementsMonitoring and Performance •Windows Performance Monitor•SQL Server Profiler•Database Engine Tuning Advisor (DTA)•Federated Database Servers•Partitioned Tables•Partitioned Indexes•Query Performance Issues•Transactions and Locks•Best Practices for Native XML Web Services