
- This event has passed.
20761 Querying Data with Transact-SQL – Brisbane
May 21, 2018 @ 9:00 am - May 25, 2018 @ 5:00 pm UTC+11
$3650
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.
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 OnlineWho 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:
- May 21, 2018 @ 9:00 am UTC+11
- End:
- May 25, 2018 @ 5:00 pm UTC+11
- Cost:
- $3650
- Event Categories:
- 5 Day, Querying Data with Transact-SQL (20761), SQL Server 2016, Training, Transact SQL
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