Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-2778 - Writing Queries Using SQL Server 2008 Transact-SQL

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 to print this page »

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