LOGO For Immediate Assistance Call 855-211-9361

Open Enrollment

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Price: $2,095.00

Call for availability 855-211-9361

Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material from the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

Course Overview

What You'll Learn

  • Uses of and ways to execute the Transact-SQL language
  • Use querying tools
  • Write SELECT queries to retrieve data
  • Group and summarize data by using Transact-SQL
  • Join data from multiple tables
  • Write queries that retrieve and modify data by using subqueries
  • Modify data in tables
  • Query text fields with full-text search
  • Create programming objects
  • Use various techniques when working with complex queries

Course Outline

  • Getting Started with Databases and Transact-SQL in SQL Server 2008

    • Overview of SQL Server 2008
    • Overview of SQL Server Databases
    • Overview and Syntax Elements of T-SQL
    • Working with T-SQL Scripts
    • Using T-SQL Querying Tools
  • Querying and Filtering Data

    • Using the SELECT Statement
    • Filtering Data
    • Working with NULL Values
    • Formatting Result Sets
    • Performance Considerations for Writing Queries
  • Grouping and Summarizing Data

    • Summarizing Data by Using Aggregate Functions
    • Summarizing Grouped Data
    • Ranking Grouped Data
    • Creating Crosstab Queries
  • Joining Data from Multiple Tables

    • Querying Multiple Tables by Using Joins
    • Applying Joins for Typical Reporting Needs
    • Combining and Limiting Result Set
  • Working with Subqueries

    • Writing Basic Subqueries
    • Writing Correlated Subqueries
    • Comparing Subqueries with Joins and Temporary Tables
    • Using Common Table Expressions
  • Modifying Data in Tables

    • Inserting Data into Tables
    • Deleting Data from Tables
    • Updating Data in Tables
    • Overview of Transactions
  • Querying Metadata, XML, and Full-Text Indexes

    • Querying Metadata
    • Overview of XML
    • Querying XML Data
    • Overview of Full-Text Indexes
    • Querying Full-Text Indexes
  • Using Programming Objects for Data Retrieval

    • Overview of Views
    • Overview of User-Defined Functions
    • Overview of Stored Procedures
    • Overview of Triggers
    • Writing Distributed Queries
  • Using Advanced Querying Techniques

    • Considerations for Querying Complex Data
    • Working with Data Types
    • Cursors and Set-Based Queries
    • Dynamic SQL
    • Maintaining Query Files