Publisher: Microsoft

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

Course Overview

This would be an ideal course for anyone wishing to learn Microsoft SQL with the aim of implementing the language in a reporting environment. The course focuses solely on querying SQL Server Databases. You will find that this is a comprehensive course for this level, with many examples and 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.

Prerequisites

This course does not assume any knowledge of SQL, any experience of databases such as Access would be useful.


Introduction to Database Theory
  • Relational Databases
  • Normalisation
  • Transactional Databases
  • Data Warehouses
Data Retrieval
  • Querying Data
  • Joining Related Tables
  • Implementing Aggregate Queries
  • Combining DataSets
  • Applying Built-in Scalar Functions
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