The objective of this course is to provide a comprehensive understanding of the structured query language (SQL) for Microsoft SQL Server users.

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.

Delegates should be familiar with the concepts of a relational database, but no prior knowledge of SQL is required.

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

   (excl.VAT)