Microsoft Certification Training | Accredited Microsoft Mcts Certified Training



Certified Microsoft Training

Implementing a Microsoft SQL Server 2008 Database

A Five-Day Training Course


Your training is easier with Activia because we have:
  • Recognised national quality accreditations
  • Training businesses since 1995
  • Friendly, capable, flexible service
  • Fiercely competitive prices !
microsoft certification training from activia
We'd like to discuss how we can give you the best service you will find.

Want to know more ?

Call us on 0845 230 6150

or click below to

Course Information

Click on the links below for more information about the Implementing a Microsoft SQL Server 2008 Database course.
[NOTE: links open in a new window.]

Related Courses

We also run the following courses which may be of interest to you.   Click for full details of the course content, prices and dates:

Contact Us

Do you have the information you need?

Call us on 0845 230 6150 or ask us to call you
– we'd like to discuss the best options for you.

Alternatively you can request a free brochure


Authorised Microsoft Training Course

This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.

Course Aims

Elements of this syllabus are subject to change. This five-day instructor-led course provides delegates with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Who Should Attend?

This course is intended for IT Professionals who administer and maintain SQL Server databases. Before attending this course, delegates 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
  • Quick Course Outline: Implementing a Microsoft SQL Server 2008 Database

    Module 1: Creating Databases and Database Files

    • Creating Databases  • Creating Filegroups  • Creating Schemas  • Creating Database Snapshots 

    Lab : Creating Databases and Database Files

    • (Level 200) Creating a Database  • (Level 200) Creating Schemas  • (Level 300) Creating a Database Snapshot 

    Module 2: Creating Data Types and Tables

    • Creating Data Types  • Creating Tables  • Creating Partitioned Tables 

    Lab : Creating Data Types and Tables

    • (Level 200): Creating Data Types  • (Level 200): Using New Date and Time Data Types  • (Level 200): Creating Tables  • (Level 300) Creating Partitioned Tables 

    Module 3: Creating and Tuning Indexes

    • Planning Indexes  • Creating Indexes  • Optimizing Indexes 

    Lab : Creating and Tuning Indexes

    • (Level 200) Creating Indexes  • (Level 300) Tuning Indexes 

    Module 4: Implementing Data Integrity by Using Constraints and Triggers

    • Data Integrity Overview  • Implementing Constraints  • Implementing Triggers 

    Lab : Implementing Data Integrity by Using Constraints and Triggers

    • (Level 200) Creating Constraints  • (Level 200) Disabling Constraints  • (Level 300) Creating Triggers 

    Module 5: Using XML

    • Using the XML Data Type  • Retrieving XML by Using FOR XML  • Shredding XML by Using OPENXML  • Introducing XQuery  • Creating XML Indexes  • Implementing XML Schemas 

    Lab : Using XML

    • (Level 200) Mapping Relational Data and XML  • (Level 200) Storing XML Natively in the Database  • (Level 300) Using XQuery with XML Methods  • (Level 200) Create XML Indexes  • (Level 300) Implementing XML Schemas 

    Module 6: Implementing Views

    • Introduction to Views  • Creating and Managing Views  • Optimizing Performance by Using Views 

    Lab : Implementing Views

    • (Level 200) Creating Views  • (Level 200) Creating Indexed Views  • (Level 200) Creating Partitioned Views 

    Module 7: Implementing Stored Procedures

    • Implementing Stored Procedures  • Creating Parameterized Stored Procedures  • Working With Execution Plans  • Handling Errors 

    Lab : Implementing Stored Procedures

    • (Level 300) Creating Stored Procedures  • (Level 300) Working with Execution Plans 

    Module 8: Implementing Functions

    • Creating and Using Functions  • Working with Functions  • Controlling Execution Context 

    Lab : Implementing Functions

    • (Level 300) Creating Functions  • (Level 300) Controlling Execution Context 

    Module 9: Implementing Managed Code in the Database

    • Introduction to the SQL Server Common Language Runtime  • Importing and Configuring Assemblies  • Creating Managed Database Objects 

    Lab : Implementing Managed Code in the Database

    • (Level 300) Importing an Assembly  • (Level 300) Creating Managed Database Objects 

    Module 10: Managing Transactions and Locks

    • Overview of Transactions and Locks  • Managing Transactions  • Understanding SQL Server Locking Architecture  • Managing Locks 

    Lab : Managing Transactions and Locks

    • (Level 300) Using Transactions  • (Level 300) Managing Locks  • (Level 300) Using Partition Locking 

    Module 11: Using Service Broker

    • Service Broker Overview  • Creating Service Broker Objects  • Sending and Receiving Messages 

    Lab : Using Service Broker

    • (Level 300) Creating Service Broker Objects  • (Level 300) Implementing the Initiating Service  • (Level 300) Implementing the Target Service 

    Course Objectives

    After completing this course, delegates will be able to:
  • Create databases and database files
  • Create data types and tables
  • Use XML-related features in Microsoft SQL Server 2008
  • Plan, create, and optimize indexes
  • Implement data integrity in Microsoft SQL Server 2008 databases by using constraints and triggers
  • Implement views, stored procedures and functions
  • Implement managed code in the database
  • Manage transactions and locks
  • Use Service Broker to build a messaging-based solution

  • Certification

    Microsoft Course 6232A

    Implementing a Microsoft SQL Server 2008 Database

    A Five-Day Training Course

    Prices for Implementing a Microsoft SQL Server 2008 Database

    Activia's prices are always among the best in today's market, and if you are offered a lower price for a like-for-like course, then we will match it.   Click for details of the Activia Price Promise.

    Scheduled Public Classes

    Prices for Scheduled Public Classes are as follows:
     
    Price per delegate
     Delegate
    1st
    2nd
    3rd
    4th
    5th
    6+
     Price per Delegate
    £1,495
    £1,395
    £1,325
    £1,325
    £1,325
    [ See below for dates ]

    Private & In-House Training Courses

    We can deliver private training courses on your premises:

    Implementing a Microsoft SQL Server 2008 Database

    A Five-Day Training Course

    Dates for Implementing a Microsoft SQL Server 2008 Database

    Scheduled Public Classes

     Mon, September 13, 2010
    London E1
    £1495
     Mon, September 13, 2010
    Leeds Russell St
    £1495
     Mon, September 27, 2010
    London W1U
    £1495
     Mon, September 27, 2010
    Manchester Portland Street
    £1495
     Mon, October 11, 2010
    Glasgow
    £1495
     Mon, October 11, 2010
    London E1
    £1495
     Mon, November 1, 2010
    Leeds LS1 Princes Exchange
    £1495
     Mon, November 8, 2010
    Birmingham B5
    £1495
     Mon, November 8, 2010
    Washington
    £1495
     Mon, November 8, 2010
    London E1
    £1495
     Mon, November 8, 2010
    Manchester Portland Street
    £1495
     Mon, November 15, 2010
    Edinburgh
     
    ** FULL **
     Mon, November 22, 2010
    Edinburgh
    £1495
     Mon, November 29, 2010
    London E1
    £1495
     Mon, December 13, 2010
    Bristol BS32
    £1495
     Mon, December 13, 2010
    London E1
    £1495
     Mon, January 10, 2011
    Birmingham B5
    £1495
     Mon, January 24, 2011
    Milton Keynes
    £1495
     Mon, February 7, 2011
    Washington
    £1495
     Mon, February 14, 2011
    London EC1R
    £1495
     Mon, February 28, 2011
    Edinburgh
    £1495
     Mon, February 28, 2011
    Manchester Portland Street
    £1495
     Mon, March 7, 2011
    Bristol BS32
    £1495
     Mon, March 21, 2011
    London EC1R
    £1495
     Mon, March 28, 2011
    Leeds Russell St
    £1495
     Mon, April 4, 2011
    London EC1R
    £1495
     Mon, April 4, 2011
    Birmingham B5
    £1495
     Mon, May 23, 2011
    Edinburgh
    £1495
     Mon, May 23, 2011
    London EC1R
    £1495
     Mon, June 6, 2011
    Manchester Portland Street
    £1495
     Mon, June 6, 2011
    Washington
    £1495
     Mon, June 13, 2011
    London EC1R
    £1495
     Mon, June 20, 2011
    Bristol BS32
    £1495
     Mon, July 11, 2011
    Birmingham B5
    £1495
     Mon, July 18, 2011
    Leeds Russell St
    £1495
     Mon, August 22, 2011
    Edinburgh
    £1495
     Mon, September 5, 2011
    Manchester Portland Street
    £1495
     Mon, September 12, 2011
    Washington
    £1495
    NOTES: We limit class sizes to a maximum of 20
    though individual centres may have smaller capacity.
                Prices are per delegate, excluding VAT

    Private & In-House Training Courses

    We can deliver private training courses on your premises:
    • Very competitive prices
    • Dates arranged to suit your availability
    • Content can be or tailored to your needs at no extra charge
    • Class sizes to suit you  (we recommend a maximum of 20)


    Activia Training   Abbey House   18-24 Stoke Road   Slough SL2 5AG
    Telephone: 0845 230 6150 (local rate)
    [ Close ]

    Why Activia for Certified Microsoft Training ?

    Certified Microsoft Training in London, Birmingham, Manchester, Bristol and the South East

    Activia should be your first choice for training for Microsoft Certification UK wide in the UK.   We provide you with a full range of classes for job-related Business Skills, HR & Supervision, Sales and Management Development as well as IT applications from Microsoft, MS Office, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for certified Microsoft courses throughout the UK, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Certified Microsoft Training at fiercely competitive prices.

    Certified Microsoft MCTS Training

    If your requirement is MCTS training and certification, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for certification for MCTS, MCITP and MCSE, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

    Courses in London, the Midlands, Manchester, Bristol, Berkshire (Berks), Buckinghamshire (Bucks), Hampshire (Hants), Surrey and UK wide

    We provide Certified Microsoft MCTS Training courses all over the UK, with modern, fully equipped training centres in the following locations:

    Certified Microsoft Training in the City of London

    Serving the City in Liverpool Street and Fleet Street, and the West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.

    Certified Microsoft Training in West London

    Serving West London, as well as areas like Brentford, Kew, Watford, Richmond and Hounslow.

    Certified Microsoft MCTS Training in the centre of Bristol

    Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.

    Certified Microsoft Training in Birmingham City Centre

    Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Telford and Tamworth.

    Certified Microsoft MCTS Training in Birmingham South

    Serving Warwickshire and the Midlands, covering Solihull, Halesowen and Redditch as well as Coventry, Kidderminster and Worcester.

    Certified Microsoft Training in Manchester

    Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

    Certified Microsoft Training in Reading

    Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley, Bracknell and Basingstoke.

    Certified Microsoft MCTS Training in Slough

    Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.

    Certified Microsoft MCTS Training in Milton Keynes

    Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.

    Certified Microsoft Training in Basingstoke

    Serving Hampshire, covering Basingstoke, as well as Camberley, Farnborough, Aldershot to the east, and Newbury, Andover and Winchester to the west.

    Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

    In House Certified Microsoft Training Courses across the UK

    For in house delivery of Certified Microsoft MCTS Training, we have an established national UK network of trainers, as well as centres in London, Birmingham, Manchester, Bristol, Slough, Reading, Basingstoke and Milton Keynes, so you can be sure that your training for Microsoft Certification UK wide will be delivered in a quality assured and cost effective manner.   For in-house MCTS training and certification, you need look no further than Activia.

    [ Close ]

    Activia Home page

     Home

    Activia courses

     Courses

    Activia prices

     Prices

    Course dates

     Dates

    Activia locations

     Locations

    Basket

     Basket

    Let's talk about quality assured, flexible Certified Microsoft Training.
    Call Activia to discuss your requirements for Certified Microsoft MCTS Training.