Loading Events

« All Events

20761 Querying Data with Transact-SQL – Brisbane

January 13, 2020 @ 9:00 am - January 17, 2020 @ 5:00 pm UTC+11

$3650
Virtual DBA

SATVs 5 DaysThis 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.

Overview

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.

Download Course Outline View Schedule/Book Online

Who Should Attend

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

Course Objectives

After completing this course, participants will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2016.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using TransactSQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

Course Prerequisites

Before attending this course, participants must have, in addition to their professional experience:

  • A working knowledge of relational databases
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Details

Start:
January 13, 2020 @ 9:00 am
End:
January 17, 2020 @ 5:00 pm
Cost:
$3650
Event Categories:
, , , ,

Organizer

WARDY IT Solutions Training
Phone:
1300 WARDY IT (927 394)
Email:
training@wardyit.com
Website:
https://www.wardyit.com/training/

Venue

WARDY IT Solutions Brisbane
Level 1, 164 Wharf Street
Spring Hill Brisbane, Queensland 4000 Australia
Phone:
1300 927 394

Tickets

8 available
Querying Data with Transact-SQL$3,650.00 + GSTThis 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.