Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Course

In Cardiff

£ 1,095 + VAT

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    3 Days

This three-day instructor-led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008

Facilities

Location

Start date

Cardiff
See map
East Moors Road, CF24 5RR

Start date

On request

About this course

Before attending this course, students must have: Knowledge of data integrity concepts Core Windows Server Skills Relational database design skills Programming Skills

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?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme


Overview
This three-day instructor-led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008


Examination information



Prerequisites

Before attending this course, students must have:
Knowledge of data integrity concepts
Core Windows Server Skills
Relational database design skills
Programming Skills
Course outline

Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
Overview of SQL Server 2008
Overview of SQL Server Databases
Overview and Syntax Elements of T-SQL
Working with T-SQL Scripts
Using T-SQL Querying Tools


Module 2: Querying and Filtering Data
Using the SELECT Statement
Filtering Data
Working with NULL Values
Formatting Result Sets
Performance Considerations for Writing Queries


Module 3: Grouping and Summarizing Data
Summarizing Data by Using Aggregate Functions
Summarizing Grouped Data
Ranking Grouped Data
Creating Crosstab Queries


Module 4: Joining Data from Multiple Tables
Querying Multiple Tables by Using Joins
Applying Joins for Typical Reporting Needs
Combining and Limiting Result Sets


Module 5: Working with Subqueries
Writing Basic Subqueries
Writing Correlated Subqueries
Comparing Subqueries with Joins and Temporary Tables
Using Common Table Expressions


Module 6: Modifying Data in Tables
Inserting Data into Tables
Deleting Data from Tables
Updating Data in Tables
Overview of Transactions


Module 7: Querying Metadata, XML, and Full-Text Indexes
Querying Metadata
Overview of XML
Querying XML Data
Overview of Full-Text Indexes
Querying Full-Text Indexes


Module 8: Using Programming Objects for Data Retrieval
Overview of Views
Overview of User-Defined Functions
Overview of Stored Procedures
Overview of Triggers
Writing Distributed Queries


Module 9: Using Advanced Querying Techniques
Considerations for Querying Data
Working with Data Types
Cursors and Set-Based Queries
Dynamic SQl
Maintaining Query Files

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

£ 1,095 + VAT