Activia for 50027: Sql Server: Querying & Processing Data
speedy course quote from Activia Training
Bookings and Enquiries:                0845 230 6150
Customer Service:                           0845 230 6159
We're here to help!      Click for a  FREE CALLBACK
Access your Dashboard:  Click to  log in

Activia Newsletter
If you would like us to let you know about our latest developments or periodic special promotions, please enter your email address below and click Sign Up.

We promise never to spam you or to pass your details to anyone else, and there's a simple unsubscribe link at the foot of every email.

    Groups of delegates?   Save hundreds of pounds when we deliver training  at your offices

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
Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

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.


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

Microsoft Certification Courses from Activia from Activia

We can provide courses for Microsoft Certification at any of our sixteen centres UK wide, or we can come to your offices.
We have been training since 1995 with a philosophy of high quality, flexible and cost effective provision, so you can be confident that we have the expertise, and the experience, to give all you need with MS Certification training classes.
Call us now on 0845 230 6150 or request a free callback.

Quality Assurance