Course Outline

Analytical Functions

  • Use of advanced summary functions
  • Use of hierarchical queries
  • Use of analytical summary functions, e.g. moving averages, running totals
  • Use of ranking functions

Useful Database Objects

  • Principles of using indexes
  • How to create and maintain an index
  • Use of clustered tables
  • Use of partitioned tables
  • Use of metadata in the master database

Query Performance Tracing

  • Principles of query execution and optimisation
  • Use of Execution Plan
  • Use of table & index statistics
  • Use of hints

Basic Data Warehouse Techniques

  • Use of Indexed Views
  • Use of Dimension & fact tables
  • Use of Star & Snowflake designs
  7 Hours
 

Testimonials

Related Courses

Business Intelligence with SSAS

  14 hours

Business Intelligence in MS SQL Server 2008

  14 hours

Administration with Powershell

  35 hours

Developing in SQL Server Business Intelligence

  35 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

SQL in SQL Server

  14 hours

SQL in Microsoft Access

  14 hours

ORACLE PL/SQL Fundamentals

  21 hours

ORACLE SQL Fundamentals

  14 hours

Transact SQL Basic

  14 hours

SQL in MySQL

  14 hours

Oracle SQL Language

  14 hours