Activia for 50027: Sql Server: Querying & Processing Data
Bookings and Enquiries:                   0845 230 6150
Customer Service:                            0845 230 6159
We're here to help!     Click for a  FREE CALLBACK

Click to see the UK coverage of Microsoft Certification Courses from Activia

Microsoft Certification Courses From Activia

Querying and Processing SQL Server Data Using Microsoft SQL Server

A Two-Day Training Course

Your training is easier with Activia because we have:
  • Recognised national quality accreditations
  • Training businesses since 1995
  • Friendly, capable, flexible service
  • Dedicated training advisors
  • Unique tools and backup
  • Fiercely competitive prices !
Microsoft Certification Courses 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
Request a Callback

Course Content

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 the syllabus for this 2-day course are subject to change.
Alto's Querying and Processing SQL Server Data Using Microsoft SQL Server concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

Who Should Attend

The target audience for this clinic is IT Professionals who will be writing queries for use with Microsoft SQL Server. Non-technical “power users” will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.
Before attending this course, delegates must, at minimum, be comfortable working with a complex user interface like SQL Server Management Studio.

Course Outline

Module 1: Quick Intro to SQL Query Basics
• Establish baseline knowledge required elsewhere in course  • Elements of the SELECT statement  • Optional clauses  • Working with NULL values  • Working with Dates 
Module 2: Working with Views
• Nature and purpose of views  • Creating and modifying view  • Limitations and cautions 
Module 3: Advanced SQL Query Tactics
• Scalar and vector aggregations  • Everything you need to know about JOINS  • UNION queries  • GROUP BY queries  • Sub-queries 
Module 4: Data Manipulation Statements
• Insert statements  • Update statements  • Delete statements  • Manipulation through views and over JOINs 
Module 5: Working with Procedures
• Nature and purpose of stored procedures and functions  • Calling stored procedures for effect  • Passing input parameters to stored procedures  • Calling procedures that return data  • Calling built-in functions  • Calling user-defined functions 
Module 6: Task-Oriented Queries
• Finding unmatched or missing records  • Finding duplicates  • Calculating running sums  • Changing a primary key 

Course Objectives

After completing this course, delegates will be able to write queries for use with Microsoft SQL Server.

Certification

Microsoft Course 50027

More Information

Prices for
Printer-friendly course outline for Querying and Processing SQL Server Data Using Microsoft SQL Server

Contact Us

Activia Training
Head Office:
    Regus House, 268 Bath Road
    Slough,   SL1 4DX

Sales:       0845 230 6150
Service:    0845 230 6159
Accounts: 0845 230 6157
[ Close ]

Locations for Microsoft Certification Courses from Activia

With our quality accreditations for ISO9001, IITT, ILM and the ILP, and a uniquely flexible service, you can be sure that your MCSA, MCTS and MCITP certification courses will get the results you need, at the prices you want.

Activia centres for Microsoft MCSA MCTS & MCITP Certified Courses

With seventeen fully equipped training centres , Activia should be your first choice for courses for Microsoft Certification wherever you are in the UK.
We provide Microsoft MCSA MCTS & MCITP Certified Courses courses in the following locations:

  • London
    We have six centres in London, serving the City in Bank and Liverpool Street, and Canary Wharf from our London Bridge (SE1) centre, as well as North, West and South West London, in Finchley, Baker Street and London Victoria.
  • Surrey and Sussex
    Our Croydon centre serves Croydon, Reigate and Redhill as well as Crawley, Gatwick and Brighton.
  • Berkshire
    We serve Berkshire and the Thames Valley with three centres in Reading, Slough and Bracknell.
  • Bristol
    Covering Bristol, Avon, Bath and South West England
  • Milton Keynes
    Serving Buckinghamshire, covering Milton Keynes, Aylesbury and High Wycombe, as well as Luton and Bedford.
  • Birmingham
    Serving Warwickshire and the Midlands: Birmingham, Walsall and Dudley, as well as Wolverhampton, Solihull and Tamworth.
  • Nottingham
    Serving Nottingham, Long Eaton and Derby, as well as Loughborough, Melton Mowbray and Leicester.
  • Manchester
    Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.
  • Sheffield
    Serving South Yorkshire, covering Sheffield, Barnsley and Doncaster as well as Chesterfield and Wakefield.
  • Leeds
    Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.
  • Newcastle Upon Tyne
    Serving Tyneside, also Sunderland and Gateshead, as well as North Shields, South Shields and Whitley Bay.

In House Microsoft Certification Courses from Activia across the UK

For in house delivery of Microsoft MCSA MCTS & MCITP Certified Courses, you can expect the same standard of training and service for your MS Certification training classes as you get at our centres, conveniently delivered at your offices.
To book your in-house certification courses for MCSA, MCTS and MCITP, you need look no further than Activia.


Click for more about MS Certification training courses UK from Activia


[ Close ]

Quality Assurance