This course is designed for Microsoft SQL Server 2005 Implementation and Maintenance. The full content will also prepare you for the [70-431] exam. If you are pursuing a career as a database administrator, database developer or business intelligence developer, or you need a technical understanding of SQL server 2005 features and implementation, this course will provide you with the necessary skills. You should be familiar with Microsoft Windows server 2003 administration and Windows Active Directory environments. You must understand networking and security concepts, including the use of certificates, and be familiar with web technology concepts. You should also have a general familiarity with .NET framework and Web programming concepts.

If there are four or more delegates from the same company, we can tailor the course to meet your specific requirements at no extra cost. Please contact us for more information.

To implement and maintain Microsoft SQL Server 2005.

• Install SQL Server 2005 [excluded from 4 day course]
• Use SQL Server management tools
• Create and manage databases
• Develop a database design for data
• Create tables, constraints and indexes
• Retrieve data from SQL Server 2005 databases
• Create programmable objects
• Manage data in a SQL Server database
• Support XML data in a SQL Server database
• Import and Export data
• Configure security
• Complete maintenance and management tasks
• Optimise SQL Server for performance
• Increase reliability and availability of data
• Implement applications
• Trooble shoot and repair SQL Server 2005 databases

Introduction to SQL

 

SQL Server 2005 installation: features - installation - alternative installations [excluded from 4 day course]

 

SQL Server management tools: SQL server services - management tools - server settings - database mail

 

Database management: Data storage - database management - capacity planning and management

 

Data design: Design process - table and data design - normalisation - data types

 

Tables, Constraints and Indexes: Objects - tables and constraints - indexes

 

Data retrieval: Queries - transact SQL functions - data organisation - 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 - XML data type - methods and indexes - relational data integration

 

Data transfers: Bulk transfers - SQL server integration services - XML import and export

 

SQL Server security: Principles - server securables - database and schema securables - SQL auditing - encription - CLR security

 

Management and maintenance: SQL server agent - distributed queries - replication

 

SQL Server optimisation: Monitoring and optimisation - database optimisation - database tune-ups - query optimisation concepts

 

Reliability and availability: Database backup - restore - log shipping - snapshots - mirrored databases

 

Applications: Server broker - HTTP endpoints

 

Troubleshooting and repair: Blocks and deadlocks - SQL server errors - recovery