CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2778 - Writing Queries Using SQL Server 2008 Transact-SQL

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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

Click here for a printer-friendly version of this page.

Upcoming classes

	Number	Class Date	Location	Length	Cost	Sign up
	MS2778	Jul 01, 2013 - Jul 03, 2013	Springfield	3 days	$1595.00	Register
	MS2778	Sep 16, 2013 - Sep 18, 2013	Bloomington	3 days	$1595.00	Register
Contact us for additional availability.

Prerequisites

Before attending this course, students must have:

Knowledge of data integrity concepts.

Core Windows Server skills.

Relational database design skills.

Programming skills.

Detailed Class Syllabus

Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008

Lesson 1: Overview of SQL Server 2008

Lesson 2: Overview of SQL Server Databases

Lesson 3: Overview of the SQL Language

Lesson 4: Syntax Elements of T-SQL

Lesson 5: Working with T-SQL Scripts

Lesson 6: Using T-SQL Querying Tools

Module 2: Querying and Filtering Data

Lesson 1: Using the SELECT Statement

Lesson 2: Filtering Data

Lesson 3: Working with NULL Values

Lesson 4: Formatting Result Sets

Lesson 5: Performance Considerations for Writing Queries

Module 3: Grouping and Summarizing Data

Lesson 1: Summarizing Data by Using Aggregate Functions

Lesson 2: Summarizing Grouped Data

Lesson 3: Ranking Grouped Data

Lesson 4: Creating Crosstab Queries

Module 4: Joining Data from Multiple Tables

Lesson 1: Querying Multiple Tables by Using Joins

Lesson 2: Applying Joins for Typical Reporting Needs

Lesson 3: Combining and Limiting Result Set

Module 5: Working with Subqueries

Lesson 1: Writing Basic Subqueries

Lesson 2: Writing Correlated Subqueries

Lesson 3: Comparing Subqueries with Joins and Temporary Tables

Lesson 4: Using Common Table Expressions

Module 6: Modifying Data in Tables

Lesson 1: Overview of Transactions

Lesson 2: Inserting Data into Tables

Lesson 3: Deleting Data from Tables

Lesson 4: Updating Data in Tables

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

Lesson 1: Querying Metadata

Lesson 2: Overview of XML

Lesson 3: Querying XML Data

Lesson 4: Overview of Full-Text Indexes

Lesson 5: Querying Full-Text Indexes

Module 8: Using Programming Objects for Data Retrieval

Lesson 1: Encapsulating Expressions by Using User-Defined Functions

Lesson 2: Encapsulating Queries by Using Views

Lesson 3: Overview of Stored Procedures

Lesson 4: Writing Distributed Queries

Module 9: Using Advanced Querying Techniques

Lesson 1: Considerations for Querying Complex Data

Lesson 2: Querying Complex Table Structures

Lesson 3: Writing Efficient Queries

Lesson 4: Using Different Techniques for Complex Queries

Lesson 5: Maintaining Query Files