LOGO For Immediate Assistance Call 855-211-9361

Open Enrollment


Price: $1000.00

Call for availability 855-211-9361


Course Overview

What You'll Learn

  • test

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