Loading Events

« All Events

  • This event has passed.

SSAQWE Advanced Query Writing Essentials – Online

August 25, 2020 @ 9:00 am - 5:00 pm UTC+11

Advanced Query Writing Essentials

This course is not currently scheduled. Please get in touch to book.
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.


This course is not currently scheduled. Please get in touch to book.


Regardless of the version of SQL Server participants are using, throughout the day participants will undertake a series of practical exercises learning the difference between and where to use an INNTER and an OUTER JOIN, when to use a LEFT vs a RIGHT JOIN, and explore the ‘how and why’ of subqueries while discovering T-SQL programming best practices.

Download Course Outline Contact Us

Who Should Attend

The course is designed for power users namely, report writers, business analysts and client application developers and report writers who are already comfortable writing queries with basic SQL syntax.

Course Objectives

After completing this course, participants will be able to, among other things:

  • Understand the order that you must use and write SQL clauses to simplify your task
  • Query multiple tables with inner joins, outer joins and self-joins
  • Write queries that retrieve and modify data by using subqueries
  • Use various techniques when working with complex queries including the use of temporary objects
  • Write queries that use advanced SQL functions and operators
  • Work with the special datatypes provided by SQL Server
  • Build queries with transactional control and sophisticated error handling
  • Understand when and where to use cursors for row based operations
  • Construct and use various programmatic objects in a SQL database

Course Prerequisites

Before attending this course, participants should have:

  • Experience navigating the Microsoft Windows environment
  • Working knowledge of relationship databases
  • Ideally will have attended the WARDY IT Solutions SQL Server Query Writing Essentials course
  • Practical experience of writing SQL queries


August 25, 2020
9:00 am - 5:00 pm UTC+11
Event Categories:
, , , , , ,


WARDY IT Solutions Training
1300 WARDY IT (927 394)




The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available