Loading Events

← Back to Events

WARDY IT Solutions Sydney

+ Google Map
Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia

November 2019

SSAE SQL Server Administration Essentials – Sydney

November 19 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$675 4 tickets left
SQL Server Administration Essentials

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 »

SSRSE SQL Server Reporting Services Essentials – Sydney

November 20 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675 8 tickets left
SQ: Server Reporting

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

November 22 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675 8 tickets left
Advanced Query Writing Essentials

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 »

December 2019

20762 Developing SQL Databases – Sydney

December 2 @ 9:00 am - December 6 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650 8 tickets left
Developing SQL Databases

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 »

20778 Analyzing Data with Power BI – Sydney

December 11 @ 9:00 am - December 13 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2190 5 tickets left
Analazing Data with Power BI

The main purpose of the course is to give participants a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Find out more »

January 2020

SSQWE SQL Server Query Writing Essentials – Sydney

January 6, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 8 tickets left
Introduction to SQL Databases

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

January 7, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675 8 tickets left
SQL Server Integration Services Essentials

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

January 8, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 8 tickets left
SQL Server Analysis Services Essentials

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

January 9, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 8 tickets left
SQ: Server Reporting

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

January 10, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 8 tickets left
Advanced Query Writing Essentials

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 »

PBIE Power BI Essentials – Sydney

January 14, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 5 tickets left

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 »

20778 Analyzing Data with Power BI – Sydney

January 15, 2020 @ 9:00 am - January 17, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2190.00 8 tickets left
Analazing Data with Power BI

The main purpose of the course is to give participants a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Find out more »

20773 Analyzing Big Data With Microsoft R – Sydney

January 21, 2020 @ 9:00 am - January 23, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2190 8 tickets left

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 »

20768 Developing SQL Data Models – Sydney

January 29, 2020 @ 9:00 am - January 31, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$2190 5 tickets left

This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Find out more »

February 2020

20761 Querying Data with Transact-SQL – Sydney

February 3, 2020 @ 9:00 am - February 7, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650 5 tickets left
Virtual DBA

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 »

SSQWE SQL Server Query Writing Essentials – Sydney

February 18, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 5 tickets left
Introduction to SQL Databases

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 »

PBIE Power BI Essentials – Sydney

February 19, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 5 tickets left

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 »

SSRSA SQL Server Reporting Services Advanced – Sydney

February 21, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 8 tickets left
SSRSA SQL Server Reporting Services Advanced

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 »

20762 Developing SQL Databases – Sydney

February 24, 2020 @ 9:00 am - February 28, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650 5 tickets left
Developing SQL Databases

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

20774 Perform Cloud Data Science with Azure Machine Learning – Sydney

March 2, 2020 @ 9:00 am - March 6, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650 8 tickets left
Cloud Data

The main purpose of the course is to give participants the ability to analyze and present data by using Azure Machine Learning, and to provide an introduction to the use of machine learning with big data tools such as HDInsight and R Services.

Find out more »

SSAE SQL Server Administration Essentials – Sydney

March 9, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$675 5 tickets left
SQL Server Administration Essentials

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 – Sydney

March 10, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 8 tickets left
Introduction to SQL Databases

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 »

Azure Data Services Essentials – Sydney

March 11, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675.00 5 tickets left
Advanced Query Writing Essentials

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 – Sydney

March 12, 2020 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$675.00 5 tickets left
Introduction to SQL Databases

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 »

20764 Administering a SQL Database Infrastructure – Sydney

March 16, 2020 @ 9:00 am - March 20, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$3650 8 tickets left
Database Administration

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 »

April 2020

40074 Microsoft SQL Server 2014 for Oracle DBA’s – Sydney

April 6, 2020 @ 9:00 am - April 9, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2920 4 tickets left

This course provides training for an Oracle DBA to compare and contrast Oracle database management to SQL Server database management.

Find out more »

20768 Developing SQL Data Models – Sydney

April 6, 2020 @ 9:00 am - April 8, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$2190 5 tickets left

This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Find out more »

20765 Provisioning SQL Databases – Sydney

April 20, 2020 @ 9:00 am - April 24, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$3650 5 tickets left
Provisioning SQL Databases

This five-day instructor-led course provides participant with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on premise and in Azure, and covers installing from new and migration from an existing install.

Find out more »

May 2020

20775 Perform Data Engineering on Microsoft HDInsight – Sydney

May 4, 2020 @ 9:00 am - May 8, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650 8 tickets left
Database Settings

The main purpose of the course is to give participants the ability to plan and implement big data workflows on HDInsight.

Find out more »

20767 Implementing a SQL Data Warehouse – Sydney

May 11, 2020 @ 9:00 am - May 15, 2020 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650 5 tickets left
Implementing a SQL Data Warehouse

This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.

Find out more »
+ Export Events