Upcoming courses

Oracle® 11g: Performance Tuning of SQL Expressions

The course describes the methodology that can be used for solving various performance problems related to Oracle® SQL – more specifically the 11g version.

Oracle 10g: Basics of PL/SQL language

Oracle 10g: SQL language

The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.

SQL Server 2008 Core Engine

The SQL Server 2008 Core Engine course is aimed at a broad IT audience that wants to learn how to develop and administer DBMS. Our course covers basic and advanced topics related to Transact-SQL programming, including DML/DDL features, stored procedures, triggers, indexes, functions, usage of xml, transactions, concurrency as well as monitoring and administration features.

Analysis Services 2008 for developers. Part 1

Analysis Services 2008 for Developers is aimed at individuals that want to have a better understanding of OLAP databases and Analysis Services 2008. In this course we talk about Data Warehousing, the OLAP theory and development for SSAS. The first part of the course is an introduction to OLAP and the core SSAS databases elements: dimensions, cubes and DSV.