Course Search:

Implementing and Maintaining SQL Server 2005

Description:
This five-day instructor-led course provides students with product knowledge and skills needed to implement and manage a Microsoft SQL Server 2005 database. It is a focused, accelerated course aimed at participants with experience and skills in SQL 2000 or other database packages.
  • Cost: Price on application
  • Duration: 5 days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Before attending this course, students must have:

- Basic knowledge of the Microsoft Windows operating system and its core functionality.

- Working knowledge of Transact-SQL.

- Working knowledge of relational databases.

- Some experience with database design.
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
Command reference:
SQL Server command reference
MCTS 70-431 exam objectives map:
Comprehensive exam objectives


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.