January 2018
20761 Querying Data with Transact-SQL – Sydney
This course is designed to introduce participants to Transact-SQL. It is designed in such a way that the first three (3) days can be taught as a course to participants requiring the knowledge for other courses in the SQL Server curriculum.
Days 4 & 5 teach the remaining skills required to take exam 70-761.
Find out more »10985 Introduction to SQL Databases – Sydney
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
Find out more »10985 Introduction to SQL Databases
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
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 »10987 Performance Tuning & Optimising SQL Databases – Sydney
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 »February 2018
SSRSA SQL Server Reporting Services Advanced – Sydney
This one-day hands-on course covers advanced techniques in development of Microsoft’s SQL Server Reporting Services reports using SQL Server Reporting Services.
The course provides an overview of the advanced features of Reporting Services, which includes creating reports with multiple cascading parameters, drill-through, linked and subreports, custom code and advanced graphics.
Throughout this course, you gain extensive experience creating and managing reports using real-world, commercial scenarios in Reporting Services.
Find out more »20764 Administering a SQL Database Infrastructure – Sydney
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Find out more »PBIE Power BI Essentials – Sydney
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 »20762 Developing SQL Databases – Sydney
This five-day instructor-led course provides participants with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database
Find out more »March 2018
10998 Updating Your Skills to SQL Server 2017 – Sydney
This two-day instructor-led course is aimed at people looking to update their skills to include SQL Server 2017.
Find out more »April 2018
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 »May 2018
55119 SQL Server 2012 Reporting Services – Sydney
This 3-day instructor-led course is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2012 Reporting Services.
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 »PBIE Power BI Essentials – Sydney
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 »June 2018
20767 Implementing a SQL Data Warehouse – Sydney
This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.
Find out more »September 2018
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 »Dashboard in a Day – Sydney
Designed by Microsoft, delivered by WARDY IT Solutions. ‘Dashboard in a Day’ is a 1-day session including the latest features of Power BI for only $99+GST per person.
With Power BI you can now see all of your data through a single pane of glass. Live Power BI dashboards and reports show visualisations and KPIs from data residing both on-premises and in the cloud, providing a consolidated view across your business regardless of where your data lives. ‘Dashboard in a Day’ is Power BI in a nutshell and is a great way to get immediate hands on experience with new and exciting tools to gain spectacular insight into your business data.
Find out more »20761 Querying Data with Transact-SQL – Sydney
This course is designed to introduce participants to Transact-SQL. It is designed in such a way that the first three (3) days can be taught as a course to participants requiring the knowledge for other courses in the SQL Server curriculum.
Days 4 & 5 teach the remaining skills required to take exam 70-761.
Find out more »October 2018
PBIE Power BI Essentials – Sydney
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 »10998 Updating Your Skills to SQL Server 2017 – Sydney
This two-day instructor-led course is aimed at people looking to update their skills to include SQL Server 2017.
Find out more »November 2018
20773 Analyzing Big Data With Microsoft R
The main purpose of the course is to give participants the ability to use Microsoft R Server to create and run an analysis on a large dataset, and show how to utilize it in Big Data environments, such as a Hadoop or Spark cluster, or a SQL Server database.
Find out more »December 2018
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 – Sydney
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 2019
55005 Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, & SQL 2014 – Sydney
This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.
Find out more »May 2019
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 »PBIE Power BI Essentials – Sydney
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 »August 2019
10990 Analyzing Data with SQL Server Reporting Services – Sydney
This course is not currently scheduled. Please get in touch to book. This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization This course is not currently scheduled. Please get in touch to book. Overview This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools…
Find out more »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 »February 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 »20762 Developing SQL Databases – Sydney
This five-day instructor-led course provides participants with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database
Find out more »March 2020
20764 Administering a SQL Database Infrastructure – Sydney
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Find out more »