Course Description

Course name

SQL Server Transact-SQL using SQL Server 2008.

Course code

SQLSERVERSQL

Audience

People who wish to use SQL Server Transact-SQL to create queries and simple reports using SQL Server 2008.

Prerequisites

Familiarity with relational concepts.

Objectives

Upon successful completion, the participant will be able to:
  • Discuss the what’s and whys of SQL Server.
  • Discuss the many features of SQL Server Management Studio.
  • Learn to use Transact-SQL to get data out of SQL Server databases
  • code using the basic SQL structure of:

Select, From, Group by, Having and Order by

  • code using the following SQL techniques:

Simple or Inner Joins, Outer Joins, Sub-Selects and Correlated Sub-Selects.

  • Create queries using some of the following:

Top

Case Expression

Additional functions such as:

Cast, IsNull, +, Rollup and Rank
  • Code Action Queries to Delete, Insert and Update database tables.
  • Develop Simple SQL Server Reports using Report Builder.
  • Discuss some performance tips for SQL performance.

Duration

3 Days