Data Warehousing – Advanced SQL Queries & Performance

Wise

Course

In Gatwick

£ 750 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Location

    Gatwick

  • Duration

    2 Days

Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements. Suitable for: Data warehouse and BI developers, data warehouse architects and DBAs.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Platform: Multi-platform: DB2 for z/OS, DB2 for Linux/UNIX/Windows, Oracle, SQL Server, etc. Audience: Data warehouse and BI developers, data warehouse architects and DBAs.

Prerequisites: Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge.

Summary: After briefly reviewing DW and BI terms and concepts, the lecturer will develop an understanding of how to use the statistics, analytic and OLAP features in a BI environment.
The main features of this presentation are examples, intensive hands-on exercises, best practices and performance considerations.

Objectives: Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements.

See related categories

Data Warehousing – Advanced SQL Queries & Performance

£ 750 + VAT

The best SQL Server courses

See all

See all