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	Mar 28, 2012 - Mar 30, 2012	Springfield	3 days	$1395.00	Register

Prerequisites

Before attending this course, students must have:

Logical database design.

Physical database design.

How data is stored in tables (rows and columns).

Data integrity concepts.

Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).

Basic knowledge of the Microsoft Windows operating system and its core functionality. For example, how to use Windows Explorer, open and save files, and what a client/server application interaction means.

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