Events Search and Views Navigation
November 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 »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 »December 2019
PBIE Power BI Essentials – Perth
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 »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 »January 2020
SSQWE SQL Server Query Writing Essentials – Sydney
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 »SSISE SQL Server Integration Services Essentials – Sydney
This one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment. You will learn a practical approach to solving real-world problems using SSIS, which will provide you the ability to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets and more, and transform the data for OLAP analysis, mining, and reporting.
Find out more »SSASE SQL Server Analysis Services Essentials – Sydney
This one-day instructor-led course teaches participants how to develop, deploy and implement an analytical and reporting solution using SQL Server Analysis Services. The course provides a practical approach to solve real-world reporting and analytical scenarios and teaches participants how to use the Analysis Services development tools to create an Analysis Services database and an On-Line Analytical Processing (OLAP) cube, and how to manage an Analysis Services solution.
Find out more »SSRSE SQL Server Reporting Services Essentials – Sydney
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 »SSAQWE Advanced Query Writing Essentials – Sydney
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 »