Course not currently available

Microsoft SQL Server 2005

Course

In Fareham ()

£ 1,280 + VAT

Description

  • Type

    Course

  • Duration

    4 Days

To implement and maintain Microsoft SQL Server 2005. Suitable for: 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.

About this course

Must have a basic understanding of Microsoft Servers prior to the course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Teachers and trainers (1)

Duncan Dickinson

Duncan Dickinson

Technical Trainer

Course programme

Microsoft SQL Server 2005

Introduction
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.

Objectives

By the end of the course you will be able to:

 

  • Install SQL Server 2005
     
  • 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
     
    Content
    SQL Server 2005 installation:
    features - installation - alternative installations  
    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

Microsoft SQL Server 2005

£ 1,280 + VAT