Loading Events

← Back to Events

WARDY IT Solutions Sydney

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

January 2018

20761 Querying Data with Transact-SQL – Sydney

January 15, 2018 @ 9:00 am - January 19, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$3650
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 »

10985 Introduction to SQL Databases – Sydney

January 22, 2018 @ 9:00 am - January 24, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$2190
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 »

10985 Introduction to SQL Databases

January 22, 2018 @ 9:00 am - January 24, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2190
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

January 29, 2018 @ 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
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 »

10987 Performance Tuning & Optimising SQL Databases – Sydney

January 30, 2018 @ 9:00 am - February 2, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$2920
Database Performance

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

February 2, 2018 @ 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
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 »

20764 Administering a SQL Database Infrastructure – Sydney

February 5, 2018 @ 9:00 am - February 9, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$3650
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 »

PBIE Power BI Essentials – Sydney

February 22, 2018 @ 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

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

February 26, 2018 @ 9:00 am - March 2, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
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 2018

10998 Updating Your Skills to SQL Server 2017 – Sydney

March 1, 2018 @ 9:00 am - March 2, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$1460

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

April 18, 2018 @ 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
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 »

May 2018

55119 SQL Server 2012 Reporting Services – Sydney

May 8, 2018 @ 9:00 am - May 10, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2190
SQL Server 2012 Reporting Services

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

May 15, 2018 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675
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 »

PBIE Power BI Essentials – Sydney

May 18, 2018 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675

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

June 25, 2018 @ 9:00 am - June 29, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650
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 »

September 2018

SSISE SQL Server Integration Services Essentials – Sydney

September 4, 2018 @ 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
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 »

Dashboard in a Day – Sydney

September 17, 2018 @ 9:00 am - 4:30 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$99
Dashboard in A Day

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

September 24, 2018 @ 9:00 am - September 28, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$3650
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 »

October 2018

PBIE Power BI Essentials – Sydney

October 15, 2018 @ 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

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

October 17, 2018 @ 9:00 am - October 18, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$1460

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

November 19, 2018 @ 9:00 am - November 21, 2018 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$2190

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

December 10, 2018 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675
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 »

PBIE Power BI Essentials – Sydney

December 14, 2018 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675

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

January 17, 2019 @ 9:00 am - January 18, 2019 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$1460
Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, & SQL 2014

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

May 8, 2019 @ 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
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

May 9, 2019 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675
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 »

PBIE Power BI Essentials – Sydney

May 10, 2019 @ 9:00 am - 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
$675

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

August 12, 2019 @ 9:00 am - August 16, 2019 @ 5:00 pm UTC+11
WARDY IT Solutions Sydney, Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia
+ Google Map
$3650.00
Analyzing Data with SQL Server Reporting Services (10990)

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

November 25, 2019 @ 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
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 »

February 2020

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
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 »

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

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
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 »
+ Export Events