SQL for Microsoft SQL Server Course
Course Description
The course will provide delegates with the ability to use the Data Manipulation Statements (SQL) to query on, and change the contents of a relational database, using Microsoft SQL Server utilities.
Course pre-requisites:
Topics covered on the 2 day SQL for Microsoft SQL Server course
Introduction
- Review of Relational Database Structure
- Introduction to Microsoft SQL Server and Utilities
- Introduction To Case Study Database
- The INSERT, UPDATE and DELETE Statements
The SELECT Statement Basics
- The FROM Clause
- The WHERE Clause
- The ORDER BY CLAUSE
- Arithmetic and String Expressions
- Column Aliases
- Aggregate Functions
- Date and Time Functions
- Miscellaneous Functions
Multiple Table Select Statements
- Simple Joins
- Table Aliases
Advanced Select Statements
- The GROUP BY Clause
- The HAVING Clause
- The UNION Operator
- Simple Sub-queries
Advanced Multiple Table Select Statements
- Outer Joins
- Self Joins
Advanced Select Statements
- Sub-queries
- Correlated Sub-queries
Advanced Update & Delete Statements
- Sub-queries
- Correlated Sub-queries
Practical Application of SELECT Statements
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| March 2010 | April 2010 | May 2010 | June 2010 | July 2010 |
| 4-5 | (31)-1 | 6-7 | 3-4 | - |
View full schedule of Generic courses
View full schedule of SQL Server 2008 courses
View full schedule of SQL Server 2005 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Training and bespoke SQL courses
The SQL for Microsoft SQL Server course qualifies for the PTR Training Passport SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.

