Implementing and Maintaining SQL Server 2005 Course
Course Description
Course pre-requisites:
Students should have attended or have equivalent knowledge to Managing and Maintaining a Windows Server 2003 Environment course.
Topics covered on the 5 day Implementing and Maintaining SQL Server 2005 course
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
Appendix B: Command reference
- SQL Server command reference
Appendix C: MCTS 70-431 exam objectives map
- Comprehensive exam objectives
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £1475 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| 19-23 | 16-20 | 14-18 | 18-22 | 15-19 |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The Implementing and Maintaining SQL Server 2005 course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.
View SAVE IT Scheme Details
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
|
