Publisher: Microsoft

Version: 2008
Length: 2 day s
Course-ID: SX679GRB

Course Overview

This 2 day course covers the basics of SQL programming and developing applications with SQL Server 2008.

Prerequisites

Previous programming experience and SQL querying is assumed.


Data Retrieval
  • Querying Data
  • Joining Related Tables
  • Implementing Aggregate Queries
  • Combining DataSets
  • Applying Built-in Scalar Functions
Modifying Data
  • INSERT, UPDATE, DELETE
  • OUTPUT, MERGE
  • Managing Transactions
Tables, Data Types, Declarative Data Integrity
  • Working with Tables and Data Types
  • Declarative Data Integrity
Additional Query Techniques
  • Recursive queries and CTE’s
  • Subqueries
  • Ranking Functions
Programming SQL Server with T-SQL
  • Stored Procedures
  • User-Defined Functions
  • Triggers
  • Views
Improving Query Performance
  • Tuning Queries
  • Creating Indices
Extending SQL Server Functionality
  • XML
  • SQLCLR and Filestream
  • Spatial Data Types
  • Full-Text Search
  • Service Broker
SQL Server Manageability Features
  • Integrating Database Mail
  • Windows Powershell
  • Tracking Data Changes