Microsoft SQL for Microsoft SQL Server

Course Overview

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.

CourseMonster are unbiased and "vendor neutral" which means that we can find the right course for you or your company by looking at our entire database of Microsoft training providers.

Related Courses

• Microsoft SQL Server 2000: Reporting Services: Creating Reporting Solutions
• Microsoft SQL Server 2000: Transact-SQL Querying/Updating
• Microsoft SQL Server 2000: Transact-SQL Programming
• Microsoft SQL Server 2000 Transact-SQL Programming: Hands-On

Audience

This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.

Prerequisites

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

Course Outline

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 and Delete Statements

• Sub-queries
• Correlated Sub-queries

Practical Application of SELECT Statements