SQL Server 2005: Introduction for Beginners (5 day), the Microsoft SQL Server Training Course

	Show all Microsoft SQL Server Courses or Search:

Home

How it works

About the quality of your course

Managed services

Promote CourseMonster

Show all Microsoft SQL Server Courses

Scheduled Dates (sort by: location | date)

Request availability or book by selecting a date:

England

Berkshire

Wokingham (RG40) 14/07/08 £ 1,475

Wokingham (RG40) 18/08/08 £ 1,475

Wokingham (RG40) 15/09/08 £ 1,475

Wokingham (RG40) 13/10/08 £ 1,475

Wokingham (RG40) 17/11/08 £ 1,475

Wokingham (RG40) 08/12/08 £ 1,475

Prices exclude VAT.

Have questions or need a better city/date? Ask now.

On-site/international quote? Ask now.

Course Overview

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

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

How to make a booking for the MSQ05-I5 course

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.

Affiliate Program Training News Privacy Policy Contact us