Microsoft SQL Server Business Intelligence Bootcamp
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.
Attendees will work through an extensive set of detailed and practical hands-on labs that reinforce the material presented. more…
Brisbane: 6-10th September
Perth: 4-8th October
Melbourne: 11-15th October
Darwin: 25-29th October
Perth: 18-22nd April 2011
Microsoft SQL Server 2008® Reporting Services
This three-day course will start with the basic architecture and components of SQL Server® 2008 Reporting Services and then move into topics like custom expressions and functions, working with and deploying Reporting Services, building Matrix reports and charts, SSRS security, and utilizing Report Builder. more…
Perth: 6-8th December
Microsoft SQL Server 2008® Integration Services
In this three day course, you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, destinations, SSIS package management and deployment, error handling and logging techniques. more…
Perth: 11-13th October
Microsoft SQL Server 2008® Analysis Services
This 3-day course teaches you how to use Microsoft SQL Server® 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. You will also learn about end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS), Microsoft SQL Server 2005 Integrated Services, and Reporting Services. more…
Register your interest for this course and see the events calendar for courses scheduled soon
Transact-SQL® 2008
This 4-day, comprehensive course teaches students how to utilize the Transact-SQL programming language for building effective views, stored procedures, user-defined functions, and triggers, error handling, and establishing scalable databases through partitioning. more…
Perth: 15-18th November 2010
Accelerated Microsoft® Business Intelligence (SQL2008)
This 4-day, comprehensive course provides students with the knowledge and skills to develop Microsoft® End-to-End business solutions using SQL Server® 2008 in an integrated environment with SharePoint and Office® 2007. more…
Perth: 23-26th November 2010
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…
Brisbane: 6-7th September
Perth: 4-5th October
Melbourne: 11-12th October
Darwin: 25-26th October
Perth: 18-19th April 2011
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…
Brisbane: 8th September
Perth: 6th October
Melbourne: 13th October
Darwin: 27th October
Perth: 20th April 2011
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…
Brisbane: 9-10th September
Perth: 7-8th October
Melbourne: 14-15th October
Darwin: 28-29th October
Perth: 21-22nd April 2011
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.
Register your interest for this course and see the events calendar for courses scheduled soon
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.
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.
