Computer Training Resources
CTR Slogan

What’s New

HTML for Email

Need to create effective emails using HTML? This course will demonstrate how. Click on the title above to be directed straight to the course outline.

JavaScript Programming

Fully comprehensive JavaScript training for web developers. Coding to the latest standards, accessibility guidelines and practices. Be sure to check out the related abridged JavaScript courses too.

Special Offers

SQL Server 2005 Querying with Transact-SQL (5 days)


SQL Server 2008 System Administration Fundamentals (3 days)


SQL Server 2008 Programming (5 days)

Currently we are running special promotions on the above selected Microsoft SQL Server courses, with over 15% off our standard rate.

Click a link for details.

Quick Links

Database Courses

Get a complete listing of all database related courses on offer from CTR.

Web Courses

A comprehensive listing of our Internet web related courses.

Downloads

SQL Server 2005

Not sure which SQL Server 2005 course to take?

Click the above link to download the SQL Server 2005 Course Tracks PDF document.

Client List

Following is a list of just some of our many valued clients.

Image of Dover Harbour Board logo

Dover Harbour Board

Image of Help the Aged logo

Help the Aged

Image of ARC Solutions Ltd logo

ARC Solutions Ltd

Image of Mid Beds District Council logo

Mid Beds District Council

Image of Motor Insurers Bureau logo

Motor Insurers Bureau

Image of Leicester City Council logo

Leicester City Council

Image of 3Si Ltd logo

3Si Ltd

Image of Jordan (Cereals) Ltd logo

Jordan (Cereals) Ltd

Image of University of Lincoln logo

University of Lincoln

Image of Lloyds TSB logo

Lloyds TSB

Image of Sharp Owl logo

Sharp Owl

Image of BOC logo

BOC

Image of Cardiff University logo

Cardiff University

Image of Scottish Power logo

Scottish Power

Image of The College of West Anglia logo

The College of West Anglia

Image of Harsco Track Technologies Ltd logo

Harsco Track Technologies Ltd

Image of HSBC logo

HSBC

Image of Egg plc logo

Egg plc

Image of Derbyshire Building Society logo

Derbyshire Building Society

Image of ROC Oil logo

ROC Oil

Quick Contact

Telephone:

01332 780051

Full details on our Contact page

Training Services

Choose a Category
Choose a Product
Microsoft SQL Server 2008 System Administration Fundamentals
Course Code: SQL28AF
Course Duration: 3 days
Price: £450 for the first delegate in a group and £150 for each additional delegate
Introduction
This 3 day course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2008 database infrastructure. Being concise and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server 2008 administration concepts, tools and utilities. This course is effectively an abridged version of the full 5 day SQL28AD: Microsoft SQL Server 2008 System Administration course.
Prerequisites
It is recommended that before attending this course students possess the following:
An understanding of working in a Microsoft Windows operating system environment.
An understanding of relational databases and design principles.
Some experience of the SQL language would be beneficial.
Objectives
Upon successful completion of this course, students will be able to:
Perform an Installation of SQL Server 2008.
Configure SQL Server Post Installation.
Plan and Create Databases.
Configure and Manage Databases.
Create a Database Schema.
Create Tables in a Database.
Understand and Implement Data Integrity.
Understand and Implement SQL Server Indexes.
Understand and Implement SQL Server 2008 Security.
Understand Data Transfer Utilities.
Backup and Restore Databases.
Create and Implement Database Snapshots.
Automate Tasks in SQL Server 2008.
Use the SQL Server 2008 Tools and Utilities to Monitor Performance.
Course Content
1. Install and Configure SQL Server 2008
Installation Prerequisites
The Installation Process
Post Install Configuration Options
2. Creating, Configuring and Managing Databases
Creating a Database
Configuring and Managing a Database
Database Schemas
3. Creating and Managing Tables
Creating a Table
Native SQL Server Data Types
Columns and Column Properties
4. Implementing and Managing Data Integrity
Introducing Data Integrity
Using Constraints to Implement Data Integrity
5. Creating and Managing Indexes
SQL Server Index Architecture
Creating Clustered Indexes
Creating Non-Clustered Indexes
6. SQL Server 2008 Security
Overview of SQL Server Security
Security at the Server Level
Security at the Database Level
7. Transferring Data
Overview of Data Transfer
Examining the Data Transfer Utilities
Bulk Loading Data
Using the Import/Export Wizard
Introducing SQL Server Integration Services (SSIS)
8. Backups and Recovery
Backup Types and Strategies
Backing up a Database
Restoring a Database
Online Restore Operations
Database Snapshots
Recovering System Databases
9. SQL Server Automation
Overview of SQL Server Automation
The SQL Server Agent Service
Creating Maintenance Plans
Creating and Managing Jobs
Creating and Managing Operators
Creating and Managing Alerts
10. Monitoring SQL Server
Overview of Performance Monitoring
Viewing the Current Activity
Using System Monitor
Using SQL Server Profiler

Notes on Price - Prices quoted above (which are all in UK pounds sterling) represent our standard rates for training and CTR reserves the right to subject these prices to change without notice. The total cost to deliver any course will be confirmed in writing by one of our representatives when we have been furnished with full specific details about required course content, training venue, number of delegates and such other relevant information. Please contact us for a quote. Thank you.

Computer Training Resources can provide on-site instructor led training courses throughout the UK. If your organization is based in Amber Valley, Avon, Bedfordshire, Berkshire, Bolsover, Buckinghamshire, Cambridgeshire, Cheshire, Chesterfield, Cleveland, Cornwall, County Durham, Cumberland, Cumbria, Derbyshire, Derbyshire Dales, Devon, Dorset, Durham, East Sussex, East Yorkshire, Erewash, Essex, Gloucestershire, Greater London, Greater Manchester, Hampshire, Herefordshire, Hertfordshire, High Peak, Humberside, Huntingdonshire, Isle of Wight, Isles of Scilly, Kent, Lancashire, Leicestershire, Lincolnshire, Merseyside, Middlesex, Norfolk, North East Derbyshire, North Yorkshire, Northamptonshire, Northumberland, Nottinghamshire, Oxfordshire, Rutland, Shropshire, Somerset, South Derbyshire, South Yorkshire, Staffordshire, Stockport, Suffolk, Surrey, Tyne And Wear, Warwickshire, West Midlands, West Sussex, West Yorkshire, Westmorland, Wiltshire, Worcestershire, Aberdeenshire, Angus, Argyllshire, Ayrshire, Banffshire, Berwickshire, Buteshire, Cromartyshire, Caithness, Clackmannanshire, Dumfriesshire, Dunbartonshire, Dumbartonshire, East Lothian, Edinburghshire, Fife, Forfarshire, Haddingtonshire, Inverness-shire, Kincardineshire, Kinross-shire, Kirkcudbrightshire, Lanarkshire, Linlithgowshire, Midlothian, Morayshire, Nairnshire, Orkney, Peeblesshire, Perthshire, Renfrewshire, Ross-shire, Roxburghshire, Selkirkshire, Shetland, Stirlingshire, Sutherland, West Lothian, Wigtownshire, Anglesey, Brecknockshire, Caernarfonshire, Carmarthenshire, Cardiganshire, Denbighshire, Flintshire, Glamorgan, Merioneth, Monmouthshire, Montgomeryshire, Pembrokeshire, Radnorshire, England, Scotland or Wales then Computer Training Resources can offer you on-site instructor led training. Specialists in delivering Microsoft SQL Server training.
Computer Training Resources can deliver on-site instructor led training courses in your town or city, anywhere in the UK, for example: Alfreton, Altrincham, Ambergate, Ashbourne, Ashford, Bakewell, Barlborough, Barnsley, Basildon, Basingstoke, Bath, Bedford, Bedworth, Belper, Beverley, Birmingham, Birkenhead, Blackburn, Blackfriars, Blackpool, Bloomsbury, Bolton, Borehamwood, Borrowash, Boston, Bournemouth, Bracknell, Bradford, Braintree, Breadsall, Brentwood, Bridlington, Brighton, Brimington, Bristol, Buckingham, Burnley, Burton-upon-Trent, Buxton, Camberley, Cambridge, Camden Town, Canary Wharf, Cannock, Canterbury, Carlisle, Central London, Chapel en le Frith, Chatsworth, Chelmsford, Cheltenham, Chester, Chesterfield, City of London, Clay Cross, Clerkenwell, Clowne, Codnor, Colchester, Congleton, Covent Garden, Coventry, Crewe, Crich, Cromford, Darley Dale, Daventry, Denby, Derby, Derby City Centre, Derby City Council, Derby Derbyshire, Doncaster, Dorchester, Dorking, Dover, Driffield, Dronfield, Duffield, Durham, Ealing, Eastbourne, Eastleigh, Eastwood, Eckington, Etwall, Euston, Exeter, Falmouth, Felixstowe, Feltham, Filey, Findern, Folkestone, Gateshead, Gillingham, Glossop, Gloucester, Godalming, Grantham, Gravesend, Greenwich, Gresley, Grimsby, Guildford, Halifax, Harlow, Harrogate, Harrow, Hartshorne, Harwich, Hastings, Hatfield, Hayfield, Heage, Heanor, Hereford, Hertford, High Wycombe, Hinckley, Holbrook, Hornsea, Hounslow, Hucknall, Huddersfield, Hull, Huntingdon, Ilkeston, Ipswich, Kendal, Kilburn, Killamarsh, Kings Cross, Kingston, Lancaster, Langley Mill, Leamington Spa, Leeds, Leicester, Leicester Square, Letchworth, Lichfield, Lincoln, Linton, Liverpool, London, London Bridge, Long Eaton, Loughborough, Louth, Macclesfield, Maidenhead, Maidstone, Manchester, Mansfield, Matlock, Melbourne, Middlesbrough, Milton Keynes, Mosborough, Nantwich, New Mills, Newark, Newbury, Newcastle, Newhaven, Newmarket, Newport, North Wingfield, Northampton, Norwich, Nottingham, Nuneaton, Orpington, Oxford, Overseal, Paddington, Paignton, Penrith, Penzance, Peterborough, Piccadilly, Pinxton, Plymouth, Poole, Portsmouth, Preston, Prestwich, Reading, Repton, Retford, Richmond, Ripley, Ripon, Romford, Rotherham, Rugby, Rugeley, Runcorn, Salford, Salisbury, Sandiacre, Sawley, Scunthorpe, Sevenoaks, Sheffield, Shirebrook, Shirland, Shrewsbury, Skegness, Slough, Smalley, Soho, South Normanton, Southampton, Southend, Southport, Southwark, Southwell, St Albans, St Helens, Stafford, Staines, Stamford, Staveley, Stevenage, Stockport, Stoke-on-Trent, Stourbridge, Stratford, Stroud, Sunderland, Sutton Coldfield, Swadlincote, Swanage, Swanley, Swindon, Swiss Cottage, Tamworth, Taunton, Telford, Tewkesbury, Tibshelf, Tilbury, Torbay, Torquay, Uttoxeter, Uxbridge, Wakefield, Walsall, Wandsworth, Warrington, Warwick, Waterloo, Watford, Wellingborough, West Byfleet, West End of London, West Hallam, Westminster, Weybridge, Weymouth, Whaley Bridge, Whitehaven, Wigan, Winchester, Windsor, Wingerworth, Wirksworth, Woking, Wokingham, Wolverhampton, Worcester, Workington, Worksop, Worthing, Yeovil, York, Aberdeen, Cumbernauld, Dumfries, Dundee, Edinburgh, Fort William, Glasgow, Grangemouth, Hamilton, Inverness, Isle of Skye, Kirkcaldy, Livingston, Perth, Portree, Stirling, Cardiff, Swansea, Wrexham, Belfast, Douglas, Guernsey and Jersey. Specialists in delivering Microsoft SQL Server training.