Loading Events

← Back to Events

WARDY IT Solutions Sydney

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

February 2020

20761 Querying Data with Transact-SQL – Sydney

February 3 @ 9:00 am - February 7 @ 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 »

SSAQWE Advanced Query Writing Essentials – Sydney

February 17 @ 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 »

SSQWE SQL Server Query Writing Essentials – Sydney

February 18 @ 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 @ 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 @ 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 @ 9:00 am - February 28 @ 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 @ 9:00 am - March 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
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 »

SSQWE SQL Server Query Writing Essentials – Sydney

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

20778 Analyzing Data with Power BI – Sydney

March 30 @ 9:00 am - April 1 @ 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 »

April 2020

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

April 6 @ 9:00 am - April 9 @ 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 @ 9:00 am - April 8 @ 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 @ 9:00 am - April 24 @ 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 @ 9:00 am - May 8 @ 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 @ 9:00 am - May 15 @ 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