Training Services
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 Content1. 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.