Microsoft Business Intelligence & SQL Server

SQL Server 2008 R2 (An Early Look)

This intensive two-day workshop gives professional developers and DBAs early insights into the R2 release of SQL Server 2008.  It includes a large number of examples and demonstrations .

Microsoft SQL Server Business Intelligence Bootcamp  - New Version

This intensive five-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting and reporting solutions using Microsoft Business Intelligence.

Perth: 19-23rd April 2010

Sydney: 3-7th May

Brisbane: 21-25th June

Melbourne: 12-16th July

Darwin: 9-13th August

Working with SQL Server 2008 Integration Services

During this two-day course, you will learn to effectively use SSIS and how to apply its enterprise functionality to data warehouse ETL systems and general data integration requirements. At the completion this course, you will understand how to design, develop, deploy, and operate SSIS solutions from source systems extractions, to data integration and transformation, and to business intelligence system loading. 

This course will demonstrate a fully working ETL solution, including extensive demos, sample projects that will not only teach how to use the new technology, but also illustrate business intelligence ETL and data warehouse best practices. more…

Perth: 19-20th April 2010

Sydney: 3-4th May

Brisbane: 21-22nd June

Melbourne: 12-13th July

Darwin: 9-10th August

Working with SQL Server Analysis Services and Data Mining

During this one-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution. An introduction to the use of data mining is also provided.

SQL Server 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 2008 Analysis Services. more…

Perth: 21st April 2010

Sydney: 5th May

Brisbane: 23rd June

Melbourne: 14th July

Darwin: 11th August

Working with SQL Server Reporting Services

This intensive two-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting solutions using Microsoft Business Intelligence.

Attendees will work through 9 practical hands-on labs to build a complete  solution by the end of the workshop. more…

Perth: 22-23rd April 2010

Sydney: 6-7th May

Brisbane: 24-25th June

Melbourne: 15-16th July

Darwin: 12-13th August

Solving Business Problems with MDX in SQL Server 2008

This hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information.

Register  your interest for this course and see the events calendar for courses scheduled soon

Complete SQL Server 2005

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You’ll learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You’ll learn how to take advantage of SQL Server’s tools for analyzing and tuning your databases. You’ll also learn about integration services, implementing security, and Microsoft’s new Business Intelligence (BI) suite.

Perth: 12-16th April 2010

Complete SQL Server 2005 Reporting Services

In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You’ll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You’ll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You’ll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to create ad-hoc reports using Report Builder and Report Model projects. more…

Brisbane: 12-14th April 2010

Perth: 24-26th May 2010

Advanced TSQL and Query Tuning for SQL Server

The course focuses on three major areas: firstly learn what’s new in SQL Server 2008 from both a DBA and Developer perspective.  In this course you will learn the details and capabilities of SQL Server new datatypes, TSQL Enhancements, Spatial data, Resource Governor, Policy Based Management and Filestream data. 

You will develop advanced TSQL Coding Skills and understand how to create effective Stored Procedures, Views, Functions and Triggers.  You will also learn how to extend TSQL via .NET code and Service Broker,  understand Exception and Error Handling techniques and how to work with XML data in TSQL.

Along the course you will learn performance tuning techniques.  You will learn how to tune your queries, how to read SQL Server Execution plans and the best practices for designing indexes.

This course covers internals and index tuning, index access methods, temporary tables, query tuning using query revisions. Moreover, query tuning is in the heart of this course and is incorporated in the different modules throughout the course.

Register  your interest for this course and see the events calendar for courses scheduled soon

DBA & Developer Skills for SQL Server 2008

The course focuses what’s new in SQL Server 2008 from both a DBA and Developer perspective.  In this course you will learn the details and capabilities of SQL Server new datatypes, TSQL Enhancements, Spatial data, Resource Governor, Policy Based Management and Filestream data. more…

Register  your interest for this course and see the events calendar for courses scheduled soon

Advanced TSQL Coding Skills

The course focuses advanced TSQL Coding Skills, you will learn how to create effective Stored Procedures, Views, Functions and Triggers.  You will also learn how to extend TSQL via .NET code and Service Broker,  understand Exception and Error Handling techniques and how to work with XML data in TSQL.

Register  your interest for this course and see the events calendar for courses scheduled soon

SQL Server Query and Performance Tuning

This two day course is designed to provide highly practical advice on performance tuning of SQL Server systems. While the course is based on SQL Server 2008, coverage is provided of SQL Server 2005 along with a discussion of how the information differs from earlier versions. Attendees will gain a solid and practical skills that can be used on the current versions of the product as soon as they return from the class, but will also be prepared for the upcoming version. The focus of the materials is on the actual problems typically encountered by our mentors during their client engagements.

Register  your interest for this course and see the events calendar for courses scheduled soon

SQL Sever Bootcamp for SharePoint Administrators

Many SharePoint administrators now find themselves involved in managing the SQL Server installation that supports their SharePoint farms. This intensive three day course covers the most important SQL Server administration concepts and techniques that are useful for SharePoint administrators.

Material applicable to both SQL Server 2005 and 2008 is provided and enhancements only available in 2008 are clearly identified. more…

Register  your interest for this course and see the events calendar for courses scheduled soon

Receive updates regarding training courses, events and offers

View our current course calendar

A complete list of available courses can also be found in our training catalogue (use the bookmark tab to navigate within the catalogue)

To book onto a course please contact training.es@csg.com.au or (08) 6250 7900.

We have many courses available but only schedule those that will be most popular in a given period. If there is a particular course you require that is not listed, please contact us for further details of alternative dates and customised sessions.