Microsoft SQL 2005: Implementing and Maintaining a Microsoft SQL Server 2005 (5 day)

Course Overview

Students should have attended or have equivalent knowledge to Maintaining and Maintaining a Windows Server 2003 Environment course.

Have you tried to search our certifications? Use the menu bar to navigate your way around.

Related Courses

• Microsoft SQL Server 2005: Updating your Administration Skills to Microsoft SQL Server 2005
• Microsoft SQL Server 2005: Designing Microsoft SQL Server 2005 Infrastructure and Services
• Microsoft SQL Server 2005: Designing Security for Microsoft SQL Server 2005
• Microsoft SQL Server 2005: Designing a Reporting Solution Archicture using MS SQL Server 2005
• Microsoft SQL Server 2005: Implementing a SQL Server Database (5 day)
• Microsoft SQL Server 2005: MCITP Developer: Designing Server -side Solutions
• Microsoft SQL Server 2005: MCITP Developer: Designing Databases
• Microsoft SQL Server 2005: MCITP Developer: Tuning and Optimising Queries
• Microsoft SQL Server 2005: MCITP Administrator: Designing High Availability Solutions
• Microsoft SQL Server 2005: MCITP Administrator: Administering and Automating Databases and Services

Course Outline

SQL Server 2005 installation

• SQL Server features
• SQL Server installation
• Alternative installations

SQL Server management tools

• SQL Server 2005 services
• Management tools
• SQL Server settings
• Database Mail

Database management

• SQL Server data storage
• Database management
• Capacity planning and management

Data design

• The data design process
• Table and data design
• Data normalization
• Data types

Tables, constraints, and indexes

• Objects
• Tables and constraints
• Indexes

Data retrieval

• Queries
• Transact-SQL functions
• Data organization
• Multiple table queries
• Data modification
• Query Designer

Programmable objects

• Programming fundamentals
• User views
• Stored procedures
• User-defined functions

Data management

• Multiple language support
• Full-text search
• Partitions
• Error handling
• Transactions and locking
• Triggers

XML support

• XML fundamentals
• The XML data type
• XML methods and indexes
• XML and relational data integration

Data transfers

• Bulk transfers
• SQL Server 2005 Integration Services
• XML import and export

SQL Server security

• Principles
• Server securables
• Database and schema securables
• SQL auditing
• Encryption
• CLR security

Management and maintenance

• SQL Server Agent
• Distributed queries
• Replication

SQL Server optimization

• Monitoring and optimization
• Database optimization
• Database tune-ups
• Query optimization concepts

Reliability and availability

• Database backup
• Database restore
• Log shipping
• Database snapshots
• Mirrored databases

Applications

• Service Broker
• HTTP endpoints

Troubleshooting and repair

• Blocks and deadlocks
• SQL Server errors
• Recovery

Appendix A: Outlander Spices case study

• Outlanders Spices

Appendix B: Command reference

• SQL Server command reference

Appendix C: MCTS 70-431 exam objectives map

• Comprehensive exam objectives

 

Microsoft SQL 2005: Implementing and Maintaining a Microsoft SQL Server 2005 (5 day) / MSQ05-I5

Request availability or enquire by clicking a date: