Training Resources
Accessibility
Web Development
Adobe / Macromedia Web
Programming
Visual Studio 2005 (.NET 2.0):
VB.NET Application Development
ADO.NET Data
Programming in VB
C#.NET Application Development
ADO.NET Data
Programming in C#
Visual Studio 2008 (.NET 3.5):
VB.NET Application Development
C#.NET Application Development
What's New in VS2008
(2-day courses):
Databases
Professional Courses
Project Management
with
Microsoft Project
Managing Enterprise Projects
Using Project Server
Adobe
Microsoft SharePoint
Technical
Geographic (GIS)
ESRI ArcGIS 9.2:
ESRI ArcGIS 9.3:
Microsoft Office
Training Resources
SQL Server 2005 Administration
5 day course
SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, you will learn about the administrative features that are available in SQL Server. This course also examines other SQL Server 2005 essential application, support, and maintenance topics – features you can use for high-availability, stability, reliability, and scalability of databases.
Course Topics:
(for a full detailed outline, visit our PDF link above)
A Tour of SQL Server 2005
Installing SQL Server 2005
- Preparing for Installation
- Upgrading an Earlier Version
- Installation Steps
- Configuring the Server
Designing and Creating a Database
- Relational Database Design Principles
- Implementing the Design
Data Selection Queries
- Understanding Transact-SQL
- The SELECT Statement
- The WHERE Clause
- Using ORDER BY to Sort Data
- The GROUP BY Clause
- Joining Tables
Modifying Data
- Modifying, Inserting, Updating, and Deleting Data
- Understanding Transaction Isolation
SQL Server Management Studio
- Getting Started with SSMS
- Exploring the Object Explorer
- Working with the Query Editor
- Using SQL Server Books Online
Understanding and Implementing Security
- SQL Server 2005 Security Overview
- Authentication and Authorization
- Permissions
- Data Encryption
- Security Epilog
Analyzing and Tuning Performance
- Evaluating Performance
- Monitoring with SQL Server Profiler
- Tuning Queries to Improve Performance
- Indexes and Partitions
- Using the Database Engine Tuning Advisor
- Understanding SQL Server Performance Problems
Automating Administrative Tasks
- SQL Server Agent
- Maintenance Plans
- SQL Management Objects (SMO)
Programming Replication
- Replication Programming Interfaces
- Configuring Replication
- Synchronizing Data
Failover Clustering
- High Availability Overview
- SQL Server 2005 Failover Cluster
- Preparing a Server Cluster
- Creating a New Cluster
- Installing SQL Server 2005 Failover
- Adding Additional SQL Server Nodes
Database Mirroring
- Understanding Mirroring
- Setting Up Database Mirroring
- Monitoring Database Mirroring
Log Shipping
- Configuring Log Shipping
- Monitoring Log Shipping Jobs
- Using Transact-SQL
Peer-to-Peer Replication
- Configuring the Distributor
- Creating the Publisher
- Configuring the Peer-to-Peer Subscribers
- Configuring Peer-to-Peer Topology
Monitoring and Troubleshooting
- Diagnosing and Resolving Database Server Errors
- Set Up Alerts Using SQL Server Agent
- Monitoring SQL Server Agent Job History
- Gathering Performance Data & Optimization w/DMV
Implementing Service Brokers
- Understanding Service Brokers
- Designing Service Broker Applications
- Programming Service Broker Applications
