Description

Type

Course
Location

Washington

Duration

2 Days

This course is intended to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005. It is a very hands on course that covers SQL query writing from the basics to advanced queries.

Facilities

Washington (Tyne and Wear)

See map

Suite 13, Vermont, House Concorde, NE37 2SQ

Start date

On request

About this course

Requirements

An understanding of basic relational database concepts, including: Logical and physical database design Data integrity concepts. Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many). How data is stored in tables (rows and columns).

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Overview

This course is intended to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005. It is a very hands on course that covers SQL query writing from the basics to advanced queries.
Prerequisites

An understanding of basic relational database concepts, including:
Logical and physical database design
Data integrity concepts.
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
How data is stored in tables (rows and columns).

Objectives

Describe the uses of and ways to execute the Transact-SQL language.
Use querying tools.
Write SELECT queries to retrieve data.
Group and summarize data by using Transact-SQL.
Join data from multiple tables.
Write queries that retrieve and modify data by using subqueries.
Modify data in tables.
Describe how to create programming objects.

Whats Included

Comprehensive colour course manual and exercises
Use of a Modern Training suite with 19 inch flat screen monitors
1 delegate per computer
Lunch (When at our training venue)
Refreshments (When at our training venue)
Relaxed refreshment area at our training room

Course Content
Introduction to Transact-SQL

The transact-SQL programming language
Types of transact-SQL statements
Transact-SQL syntax elements
Using SQL server books online

Using Transact-SQL Querying Tools

SQL query analyzer
Using the object browser tool in SQL query analyzer
Using the OSQL utility
Executing transact-SQL statements
Creating and executing transact-SQL scripts

Retrieving Data

Retrieving data by using the select statement
Filtering data
Formatting result sets
How queries are processed
Performance considerations
Retrieving data and manipulating result sets

Grouping and Summarizing Data

Listing the top n values
Using aggregate functions
Grouping by fundamentals
Generating aggregate values within result sets
Using the compute and compute by clauses
Grouping and summarizing data

Joining Multiple Tables

Using aliases for table names
Combining data from multiple tables
Combining multiple result sets
Querying multiple tables

Working with Subqueries

Introduction to subqueries
Using a subquery as a derived table
Using a subquery as an expression
Using the exists and not exists clauses
Working with subqueries

Modifying Data

Using transactions
Inserting data
Deleting data
Updating data
Modifying data

Introduction to Programming Objects

Introduction to views
Advantages of views
Creating views
Introduction to stored procedures
Introduction to triggers
Introduction to user-defined functions
Working with views

See related categories

Contact us

Querying Microsoft SQL Server 2005

Questions & Answers

Reviews

Course programme

Add similar courses
and compare them to help you choose.

Querying Microsoft SQL Server 2005

Questions & Answers

Reviews

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.