Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

SQL Server 2005 - Advanced

3 day course

View Detailed Outline in PDF Format
Get Adobe Reader

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data.  In this course, you'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks.  You will learn to install, upgrade and configure instances of SQL Server 2005, and how to take advantage of SQL Server's tools for analyzing and tuning your databases.  You'll also learn about integration services, implementing security, and Microsoft's new Business Intelligence (BI) suite.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Installing and Configuring SQL Server 2005

  • SQL Server 2005 Editions, Components, and Tools
  • Pre-Installation Planning and Requirements
  • Upgrading an Earlier Version of SQL Server
  • Installing Instances of SQL Server
  • Step-by-step Installation
  • Configuring SQL Server 2005
  • The Purpose and Function of the Transaction Log

Understanding and Implementing Security

  • SQL Server 2005 Security Overview
  • Authentication and Authorization
  • Principals and Securable Objects
  • Schemas, Roles, Users and Permissions
  • Understanding Execution Context
  • MetaData Security
  • Data Encryption
  • Security Epilog

Analyzing and Tuning Performance

  • Tools and Techniques for Evaluating Performance
  • SQL Server Profiler Terminology
  • Monitoring with SQL Server Profiler
  • Understanding How Queries are Processed
  • Tuning Queries to Improve Performance
  • Role of Indexes and Partitions in Query Execution
  • Using the Database Engine Tuning Advisor
  • Understanding SQL Server Performance Problems
  • Slow and Long-running Queries
  • Memory and CPU Bottlenecks

Automating Administrative Tasks

  • The Tasks of Database Administration
  • Using SQL Server Agent
  • Operators, Jobs and Alerts
  • Creating and Maintaining Maintenance Plans
  • SQL Server 2005 Management Objects (SMO)

Replication

  • The Purpose of Replication
  • Understanding the Publishing Model
  • Overview of SQL Server 2005 Replication
  • Types of Replication
  • Replication Programming Interfaces
  • Configuring Replication
  • Determining Synchronization Status
  • Synchronizing Data

Integration Services

  • Using Data Integration Services
  • Importing and Exporting Data from Various Sources
  • Integration Services Tools
  • Business Intelligence Development Studio (BIDS)
  • Data Sources, Control Flows and Data Flows
  • Building, Testing and Running a Package
  • Troubleshooting a Package

Analysis Services

  • Understanding Analysis Services
  • OLAP Terminology
  • Data Cubes, Dimensions and Measures
  • Creating a Unified Dimensional Model
  • Data Mining Algorithms and Structure

Introduction to Reporting Services

  • Understanding Reporting Services
  • Server Components and Client Components
  • Configuring Reporting Services
  • Building a Simple Report
  • Creating, Publishing, and Viewing Reports
  • Using and Managing Published Reports