Home   Technology Courses   Management Courses   Certification   MyHistory  Course Schedule   Free Catalog   About Us   What's New   Contest   Contact Us Photo Galary

SQL Server 2005 Administration: Hands-On Skills Upgrade You Will Learn How To Leverage SQL Server 2005 features and administration tools Build database availability solutions with database mirroring and database snapshots Deploy a peer-to-peer replication topology Implement encryption and other enhanced security features Upgrade a SQL Server 2000 installation and SQL Server 2000 databases Integrate Database Mail with SQL Server Agent   Course Benefits SQL Server 2005 includes an extensive array of tools for SQL Server administrators. Those migrating from SQL Server 2000 or SQL Server 7 must upgrade their skills in order to leverage the enhanced feature set. This skills upgrade course provides the knowledge required to effectively administer SQL Server 2005. You learn to build database availability solutions and exploit the wide range of administrator tools to gain maximum benefit for your organization.   Who Should Attend Experienced SQL Server administrators considering or currently migrating to SQL Server 2005. Familiarity with administering SQL Server is assumed.   Hands-On Training Throughout this course, extensive hands-on exercises provide practical experience administering SQL Server 2005. Exercises, performed under the guidance of an expert instructor, include: Implementing peer-to-peer replication Mirroring a database Building a permission hierarchy that enforces the least privilege principle Encrypting data with certificates Deploying SQLH2 and reviewing collected data Configuring Database Mail Upgrading SQL Server 2000 databases   Introduction to SQL Server 2005 Installing SQL Server 2005 Upgrading from previous versions Upgrade Advisor Applying a Service Pack Exploring the SQL Server 2005 tools SQL Server Management Studio Registering servers Writing and issuing queries Generating scripts with Object Explorer Additional administrator tools SQLCMD Surface Area Configuration SQL Server Configuration Manager Dedicated Administrator Connection (DAC) Enhancing Database Availability Implementing database mirroring Selecting mirroring architecture Configuring the mirror and witness servers Managing database snapshots Taking database snapshots Combining snapshots and mirroring Replicating Information Installing a peer-to-peer topology Concepts and terminology Configuring peer servers Handling replication security Studying the agent security model Securing the Distributor, Publisher and Subscribers Moving to SSIS Upgrading DTS Packages Analyzing packages with the Upgrade Advisor Running the Migration Wizard Encapsulating DTS packages with the Execute SQL 2000 Package task Building an ETL package Working with Business Intelligence Development Studio Control Flow Data Flow Connections Testing the package Securing SQL Server 2005 Defining the new terminology Principals Securables Scope Applying password policy Exploring Windows security policy Specifying policy enforcement and expiration for a SQL Server login Administering schemas Users vs. schemas Designing schemas Assigning a default schema to a user Upholding the principle of least privilege Granting fine-grained permissions Server Database Schema Object Encrypting sensitive data Choosing asymmetric or symmetric keys Implementing certificate-based encryption Backing up keys Managing Common Language Runtime (CLR) Objects Enabling the CLR feature Creating Assemblies Selecting safety levels SQL Server Agent Securing Agent Creating a credential and mapping it to a proxy Specifying a proxy for CmdExec and ActiveScript steps Setting up Database Mail Creating a mail profile Configuring Agent's properties Testing the mail setup Monitoring SQL Server 2005 Studying activity with Activity Monitor Querying Dynamic Management Objects Deploying the Performance Dashboard Analyzing trends with the SQL Server Health and History tool (SQLH2)

Copyright ©2008, www.galaxy.ps

Designed By: Mohammed Fuqaha