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 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
  •  
    Microsoft Partner Gold LearningPrometricEC-Council
    Microsoft Certified ProgramsAdditional Certification Courses