Events Search and Views Navigation
May 2019
10977 Upgrading Your SQL Skills to SQL 2014 – Brisbane
This five-day instructor-led hands on course teaches participants how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.
Find out more »June 2019
Azure Data Services Essentials – Brisbane
This one-day workshop is designed to introduce the various data storage and analysis capabilities of the Microsoft Azure platform. Starting with an introduction to cloud computing and a description of traditional data warehouses, comparisons are made with modern cloud computing technologies in mind.
Find out more »ADAE Azure Data Analytics Essentials – Brisbane
This course is designed to introduce the various data analytics feature and capabilities of the Microsoft Azure platform. Beginning with an overview of the Modern Data Warehouse and how various data analytics features are used to provide a complete solution, from ingesting data, performing analytics on that data and using various services to provide in depth insights to using Machine learning, IoT hubs and streaming data. Finally, the course introduces using Power BI to report on various models and analytic…
Find out more »10987 Performance Tuning & Optimising SQL Databases – Adelaide
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Find out more »20767 Implementing a SQL Data Warehouse – Melbourne
This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.
Find out more »July 2019
SSAE SQL Server Administration Essentials – Sydney
The goal of this one-day instructor-led workshop is to provide participants with the technical skills required to administer SQL Server. Upon completion, participants will be able to install, configure and troubleshoot the client server database management system of Microsoft SQL Server. Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server.
Find out more »SSQWE SQL Server Query Writing Essentials – Brisbane
The goal of this course is to provide participants with the technical skills and knowledge to write Transact-SQL statements for Microsoft SQL Server. Upon completion, participants will be able to retrieve and modify data from SQL Server and understand how to perform these operations whilst maximising query performance. This course is designed for all SQL Server versions.
Find out more »SSRSE SQL Server Reporting Services Essentials – Brisbane
This one-day hands-on Essentials course thoroughly covers the development of Microsoft's SQL ServerReporting Services reports using SQL Server Reporting Services. The course provides an overview of the Reporting Services architecture, and then covers creating reports including parameter reports, drill-through reports, matrix reports and linked reports.
Throughout this course, you gain extensive experience creating and managing reports using real-world, commercial scenarios in Reporting Services.
Find out more »PBIE Power BI Essentials – Brisbane
This one-day instructor led course concentrates on the Power BI components available in Microsoft Office 2016 and the Power BI Desktop. The participants will learn how to gather and analyse data from a variety of sources and surface visualisations using the Power BI tools to construct compelling insights into business data.
Find out more »SSAQWE Advanced Query Writing Essentials – Brisbane
This course will provide participants with a good exposure to advanced Transact-SQL querying writing techniques allowing participants to develop more complex and robust SQL queries, like writing advanced reports against a SQL Server database, and for developers who will need to build applications with a SQL Server backend.
Find out more »