Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
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
Guaranteed to RunAvailable Virtual MS2778 May 12, 2014 - May 14, 2014 Springfield 3 days $1595.00 Register
Available Virtual MS2778 Jun 30, 2014 - Jul 02, 2014 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
  •  
    Microsoft Partner Gold LearningPrometricEC-Council