Publisher: Microsoft

Version: 2005
Length: 2 day s
Course-ID: SX677GRB

Course Overview

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

Prerequisites

Previous programming experience and SQL querying is required.


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
  • Full-Text Search
  • Service Broker
SQL Server Manageability Features
  • Integrating Database Mail