Writing Queries Using Microsoft® SQL Server™ 2008 Transact-SQL Training Course


Microsoft Official Curriculum Course Number: 2778
Printer Friendly Printer Friendly

This 2-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
  • 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 Data
  • Working with Data Types
  • Cursors and Set-Based Queries
  • Dynamic SQL
  • Maintaining Query Files
  • Current User's Login:


    Fill out the information as a first time user:
    Name:
    (First/Last)
     
    Email:
    (UserName)
    Confirm Email:
    Company:
    (if applicable)
    Title:
    Address 1:
    Address 2:
    City:
    State/Province:
    Postal Code:
    Country:
    Phone:
    Discount Code:
    Comments:
    To Redeem SATV vouchers please have your voucher redemption number ready


    Live Instructor-led Writing Queries Using Microsoft® SQL Server™ 2008 Transact-SQL Training Dates

    SATV Eligible
    Filter By...
    Providers:       Location:      
    Date Range:  
     to 
    Provider Location Date Type Duration Price 41 course(s)
      << Prev  1 Next >> 

    Online Self-Paced Writing Queries Using Microsoft® SQL Server™ 2008 Transact-SQL Training Options

    SATV Eligible
    No online results

    Request Training Assistance

    Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

    Request Training Assistance

    Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677