Course Catalogue  

​

Featured Courses  Technologies  Languages 
Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005, 2008 and 2012
The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005, 2008 and 2012. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Window Ranking and Offset Functions, Joins and Set Operations; Aggregating and Pivoting Data; Window Aggregate Functions; TOP, OFFSET-FETCH and APPLY; Data Modification; Working with Date and Time; Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling); Graphs, Trees and Hierarchies.
SQL Server 2012 for Experienced Developers and DBAs
In this class we introduce you deeply into the new features of SQL Server 2012. It addresses experienced developers and database administrators being familiar with SQL Server 2008 (R2). We discuss amongst others AlwaysOn, Sequences, ColumnStore Indexes, Analytical Windowing Functions and SQL Server Data Tools.
Advanced MDX - Performance, Optimization, and the MDX Script
This is an advanced MDX course. One day is spent on examining strategies for monitoring and optimizing MDX. The other day is focussed on effectively using the MDX Script. Advanced MDX concepts and functions are also covered.
MDX for Creating Business Logic
The MDX language is needed to create business logic for multidimensional cubes in Analysis Services. This course introduces the concepts needed to understand and use MDX.
Accelerated SQL Server 2012 Integration Services
This 4-day instructor led training focuses on developing and managing SSIS 2012 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS extraction, transformation, and loading (ETL) solutions from source systems extractions, data integration, SSIS server administration and package execution.
SQL Server 2012 Business Intelligence Introduction
SQL Server is leading database management product for Business Intelligence (BI) applications. SQL Server BI suite is really impressive. It can cover the needs of a single advanced analytical person, a department, a company, or an enterprise. In version 2012, it is enhanced importantly. In this seminar, attendees learn about the new BI features in SQL Server, Analysis Services, Reporting Services, and Integration Services. In addition, although data mining is a mature technology in SQL Server and there is not much new in version 2012, it is underutilized and the seminar covers this topic as well.
SQL Server High Availability
This course provides an in-depth review of SQL Server 2012 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2012, and how to implement high availability using those technologies.  Troubleshooting and operational guidance will also be provided.
SQL Server 2012 Analysis Services
During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2012 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution.
SQL Server 2012 Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. This course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and successful analytical solution using SQL Server 2012 Analysis Services.
Data Mining with SQL Server 2012
In this course attendees learn how to use data mining to find advanced patterns in their data, and perform predictions based on the patterns found using SQL Server 2012 Analysis Services. This is a high-end course, enabling students to go beyond simple usage of wizards. In-depth understanding of the data mining algorithms, how they are built and how they work, is provided.
Designing BI Report Solutions with SQL Server 2012 Reporting Services and SharePoint 2010
This course will teach students to apply industry design patterns and best practices to create business reports and reporting solutions based on years of field experience with the product in a variety of industries and business scenarios. Students will learn to avoid common pitfalls and to apply effective design techniques to meet business requirements. This course is focused on business intelligence solutions, dashboards and analytical reports deployed to an integrated SharePoint business portal environment.
1 2 3 4 5 next
Follow us on: