Microsoft Course 50027 Querying and Processing SQL Server Data Using Microsoft SQL Server — A 2 day course

contact usEnquire about this course
Retired Course; no longer available


This course has been retired. Please review this course as an alternative.

The two-day, Microsoft M50027 course covers everything database administrators and developers need to know to query SQL Server databases using SELECT statements ranging from simple to complex, and use INSERT, UPDATE and DELETE statements to modify and maintain data. Creating and using of VIEWS is also covered, along with accessing data through stored procedures and user-defined functions. Please note that although this course is validated and supplied by Microsoft, the content is not based on Microsoft Official Curriculum.


On completion of the Microsoft M50027 training course, delegates should be able to:

Suitable For

The Microsoft MS50027 course is intended for both non-technical "power users" and IT Professionals who will be writing queries for use with Microsoft SQL Server.


There are no technical pre-requisites for the Microsoft 50027 course and it assumes no prior knowledge of SQL Server.


This course has been retired and is no longer available.


Quick Intro to SQL Query Basics

Working with Views

Advanced SQL Query Tactics

Data Manipulation Statements

Working with Procedures

Task-Oriented Queries