Publisher: Microsoft

Version: 2005/8
Length: 2 day s
Course-ID: SX683GRB

Course Overview

This is a comprehensive course at an advanced querying level, with plenty of illustrated examples and augmented with practical hands-on exercises.

Target student

Business Analysts, Information Systems workers, anyone using SQL Server as the data source for reporting, particularly those working with SQL Server Reporting Services, Crystal Reports and Business Objects. This course is also suitable for those transferring their skills from other database management systems such as Oracle and MySQL. The course focuses solely on querying SQL Server Databases. Temporary objects (e.g. Tables, Table Variables and Common Table Expressions) are included as are Insert, Delete and Update so that more sophisticated users can use the SQL Server engine to manipulate data for the production of complex data sets.

Prerequisites

Basic understanding of Relational Databases, and ideally a some exposure to the SQL Language.


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
  • Querying Views
  • Querying Stored Procedures
Improving Query Performance
  • Tuning Queries
  • Creating Indices