Login to Course Campus | Call Us: 1-877-797-2799  

 

Microsoft Course Listings

Microsoft SQL Server 2005 Implementation and Maintenance 1.0

Overview
Skills Taught
Audience
 Prerequisites
Outline
Duration:6 classes
Skill Level:Intermediate
Certifications:MCSA 2003; MCSE 2003; MCTS: SQL Server 2005
Delivery Type:Expert Live; Expert Encore

Description
Microsoft SQL Server 2005 Implementation and Maintenance course introduces you to the features of different SQL Server editions and services. This course covers the prerequisites for installation and the steps for installing SQL Server 2005, SQL native client, and workstation. It also describes the options for upgrading, verifying, and reviewing SQL Server installation. This course also explores the services and management tools provided by SQL Server 2005.

Skills Taught
Upon completion of the Microsoft SQL Server 2005 Implementation and Maintenance, the student will be able to:

  • Identify the features of Microsoft SQL Server 2005
  • Identify the computing models supported by SQL Server 2005
  • List the database management system (DBMS) languages supported by SQL Server 2005
  • Identify features of key services in SQL Server 2005
  • Compare the features of the SQL Server 2005 editions
  • Identify the prerequisites for installing Microsoft SQL Server 2005
  • Identify the operating system requirements for installing SQL Server 2005
  • Identify the software requirements for installing SQL Server 2005
  • Identify the hardware requirements for installing SQL Server 2005
  • Identify the steps to prepare for a Microsoft SQL Server 2005 installation
  • Identify the options in the installation prompts
  • Install SQL Server 2005
  • Identify steps to install an SQL native client and workstation
  • Identify options to install SQL Server from a command prompt
  • List the steps to install a named instance
  • Identify the options for upgrading to SQL Server 2005
  • Run the Upgrade Advisor for migrating to SQL Server 2005
  • Identify the steps to verify an SQL Server 2005 installation
  • Identify options to review installation errors
  • Identify the services provided by SQL Server 2005
  • Identify the features of SQL Server Configuration Manager
  • Identify the features of SQL Server Surface Area Configuration
  • Identify administrative tasks performed using SQL Server Management Studio
  • Identify the components of SQL Server Management Studio
  • Identify the performance management and reporting tools
  • Identify the command-line utilities

Audience
This course is for any developers and system administrator professionals who want to implement and maintain databases using specific instructions and specifications. Professionals can take this course even if they do not use SQL Server for their primary job functions.

Prerequisites
Microsoft SQL Server 2005 Implementation and Maintenance course provides an introduction to installing SQL Server 2005 and using the components of SQL Server Management Studio. Participants, such as database administrators and database developers, taking this course should have knowledge of the tools, Transact-SQL language, and the user interface. They should have command over using wizards, writing code, debugging code, and troubleshooting.

Outline
Module 1: SQL Server Features
  • Pre-Installation of Microsoft SQL Server 2005
  • SQL Server 2005 Installation
  • SQL Server Upgrades
  • Installation Problems
  • SQL Server Management Tools
Module 2: SQL Server Settings
  • Database Management
  • Managing Databases with Transact-SQL
  • Capacity Planning and Management
Module 3: Database Designing
  • Data Design and Normalization
  • Data Types
  • Objects
  • Tables and Constraints
Module 4: Understanding Indexes
  • Managing Indexes
  • Executing Single-Table Queries
  • Understanding Functions and Clauses
Module 5: Executing Multiple Table Queries
  • Using DML Statements
  • Programming Fundamentals
  • Working with Views
Module 6: Using Programmable Objects
  • Introducing Data Management
Module 7: Handling Errors
  • Using Transactions and Locks
  • Working with Triggers
  • Exploring XML Fundamentals
  • Working with XML Data Types
Module 8: Working with XML Methods and Indexes
  • XML and Relational Data Integration
  • Transferring Data
  • SSIS
  • Working with XML Data
Module 9: Introduction to Security
  • Securables
  • SQL Auditing
  • Encryption and Decryption
  • Common Language Runtime (CLR)
Module 10: Working with SQL Server Agent
  • Working with Distributed Queries
  • Exploring Replication
Module 11: Monitoring and Optimization Tools
  • Database Optimization
  • Managing Query Optimization
Module 12: Exploring Database Reliability
  • Database Availability
Module 13: Working with Service Broker
  • Service Broker Management
  • HTTP Endpoints
  • Blocks and Deadlocks
  • SQL Server Errors
  • Exploring Recovery