Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
  Most popular search | Share this page  
open My list: 0 courses
Homepage IT, Computing, Telecommunications Courses Database Administration Courses SQL Server Courses

Implementing And Maintaining a Microsoft SQL 2005 Database

in Hemsley Fraser (England)

Classes Course

Place:

London

Price:

£1,595 + VAT

Duration:

5 Days

Start:

consult dates and times
See course programme

Request free information

Course objectives:

At the end of the course, delegates will be able to:

  • Install and configure SQL Server 2005.
  • Manage database files.
  • Manage security.
  • Perform administrative tasks.
  • Backup databases.
  • Rstore databases.
  • Monitor SQL Server.
  • Troubleshoot ...

  • More courses Subject area
    Place
     

    Request information

    Contact directly and with no obligation with
    Hemsley Fraser
    You must complete all fields on this form in order for us to send it to the course provider.
    We have highlighted incomplete/ incorrect details in red.
    * Compulsory fields
    By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
    I wish to receive the personalised newsletter (during a maximum period of 15 days)

    Availability?
    How do I enrol?
    Where can I get more information?

    The person in charge of this course will receive your information request instantly.

    Response time:
    :| :) ;)
    Average Fast Very fast
     

    Course details

    Type Course Duration 5 Days
    Method / place Contact course provider Classes in London where
    Suitability This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for Implementing and maintaining a SQL 2005 database. The course is also suitable to any IT Professionals wanting to update their skills from SQL 2000 to SQL 2005. All delegates should have a working knowledge of: %...
    Course objectives At the end of the course, delegates will be able to:
  • Install and configure SQL Server 2005.
  • Manage database files.
  • Manage security.
  • Perform administrative tasks.
  • Backup databases.
  • Rstore databases.
  • Monitor SQL Server.
  • Troubleshoot ...
  • Price £1,595 + VAT
    Get direct information on how to enrol, venues and availability...

    SQL Server courses (from other course providers)

     
    Microsoft SQL Server 2005 Solutions MCITP 70-441
    We Teach You
    Distance - £50 + VAT
     
    SQL Server: Introduction
    Media Training
    London - Price: On request
     
    SQL Server 2005 Database Administration Fundamentals
    Wise Ltd.
    London - £1,475 + VAT
     
    SQL for the web
    ACS Distance Education
    Distance - £280 + VAT
    Compare the selected courses

    Course programme

    Implementing And Maintaining a Microsoft SQL 2005 Database
    Course suitable for:
    This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for Implementing and maintaining a SQL 2005 database. The course is also suitable to any IT Professionals wanting to update their skills from SQL 2000 to SQL 2005.
    All delegates should have a working knowledge of:

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

    Course objectives:
    At the end of the course, delegates will be able to:

    • Install and configure SQL Server 2005.

    • Manage database files.

    • Manage security.

    • Perform administrative tasks.

    • Backup databases.

    • Rstore databases.

    • Monitor SQL Server.

    • Troubleshoot SQL Server.

    • Transfer data.

    • Maintain high availability.

    • Create databases and database files.

    • Create data types and tables.

    • Use XML-related features in Microsoft SQL Server 2005.

    • Plan, create, and optimize indexes.

    • Implement data integrity in Microsoft SQL Server 2005 databases by Using constraints, triggers, and XML schemas.

    • Implement views.

    • Implement stored procedures and functions.

    • Implement managed code in the database.

    • Use Service Broker to build a messaging-based solution.

    Course content:
    Installing and configuring SQL Server 2005

    • Preparing to install SQL Server

    • Installing SQL Server

    • Managing a SQL Server 2005 Installation
    Managing Databases and Files

    • Planning databases

    • Creating databases

    • Creating Filegroups

    • Creating Schemas

    • Creating Database Snapshots

    • Managing databases
    Creating Data Types and Tables

    • Creating Data Types

    • Creating Tables

    • Creating Partitioned Tables
    Writing Queries Using Transact-SQL

    • Getting started with Transact-SQL.

    • Performing basic queries.

    • Grouping and summarizing data.

    • Joining data from multiple tables.

    • Working with subqueries.

    • Modifying data.

    • Querying metadata, XML, and full-text indexes.

    • Using programming objects for data retrieval.

    • Using advanced querying techniques.
    Using XML

    • Retrieving XML by Using FOR XML

    • Shredding XML by Using OPENXML

    • Using the xml Data Type
    Creating and Tuning Indexes

    • Planning Indexes

    • Creating Indexes

    • Optimizing Indexes

    • Creating XML Indexes Implementing Data Integrity

    • Data Integrity Overview

    • Implementing Constraints

    • Implementing Triggers

    • Implementing XML Schemas
    Implementing Views

    • Introduction to Views

    • Creating and Managing Views

    • Optimising Performance by Using Views
    Implementing Stored Procedures and Functions

    • Implementing Stored Procedures

    • Creating Parameterized Stored Procedures

    • Creating Functions

    • Handling Errors

    • Controlling Execution Context
    Implementing Managed Code in the Database

    • Introduction to the SQL Server Common Language Runtime

    • Importing and Configuring Assemblies

    • Creating Managed Database Objects
    Using Service Broker

    • Service Broker Overview

    • Creating Service Broker Objects

    • Sending and Receiving Messages
    Managing Security

    • Overview of SQL Server Security

    • Securing the Server Scope

    • Securing the Database Scope

    • Implementing Cryptography in SQL Server
    Disaster Recovery

    • Planning a Backup Strategy

    • Backing Up User Databases

    • Restoring User Databases

    • Recovering Data from Database Snapshots
    System Database and Disaster Recovery Monitoring SQL Server

    • Viewing Current Activity

    • Using System Monitor and SQL Server Profiler
    Using DDL Triggers and Event Notifications Transferring Data

    • Overview of Data Transfer

    • Introduction to SQL Server Integration Services (SSIS)

    • Using SQL Server Integration Services
    Automating Administrative Tasks

    • Automating Administrative Tasks in SQL Server 2005

    • Configuring the SQL Server Agent

    • Creating Jobs and Operators

    • Creating Alerts

    • Managing Multiple Servers

    • Managing SQL Server Agent Security
    Maintaining High Availability

    • Introduction to High Availability

    • Implementing Server Clustering, Database Mirroring and Log Shipping
    Introduction to Replication

    • Overview of Replication

    Further courses to consider
    M2781 - Designing MS SQL Server 2005 Server-Side Solutions.
    see the full course programme

    on request

    get more information on the programme directly from Hemsley Fraser.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where London, 13 Grosvenor Place
    When Start: Ask the course provider
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On Hemsley Fraser

    Provider description
    Hemsley Fraser is a global innovator and leader in learning and people development. We have the confidence to guarantee the success of our work and help organisations and people to succeed and improve through our innovative and robust learning solutions.

    With a strong UK, European and North American presence and a global network of over 400 professionals, we bring a comprehensive range of people and organisational development capabilities to clients.

    In an increasingly competitive environment where your people are often the key differentiator, you need to think beyond the norm and continually raise the level of talent and skills in the organisation. Hemsley Fraser provides learning and development solutions that help clients to become higher-performing organisations.

    We develop learning solutions which:

    * Help Airbus to build planes more efficiently at the forefront of technological innovation and the customer experience.
    * Enable Norwich Union Life to deliver higher levels of customer satisfaction.
    * Ensure that MBDA has an organisation wide learning programme, delivered with measurable effectiveness and efficiency and which directly supports its strategy as a global player in its market.
    * Creates a large scale management capability to enable Royal Bank of Scotland Group to deliver operational and customer excellence, as one of the largest banking groups in the world.
    * Distinguish West Bromwich Building Society as an award winning high performer in its sector, which has been achieved through the commitment of its people.

    Our ability to think beyond learning distinguishes our approach and capability to make breakthrough performance a reality.

    All courses

    by Hemsley Fraser on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...

    Training related to SQL Server

    More related courses
    Database Administration Price: On request Blended
    Server+ £298 + VAT Multimedia
    Data Modelling Price: On request
     
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

    Words related to the courses viewed: sql database design sql server

    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights