
- This event has passed.
20761 Querying Data with Transact-SQL – Online
September 14, 2020 @ 9:00 am - September 18, 2020 @ 5:00 pm UTC+11
$3650
This course is not currently scheduled. Please get in touch to book.
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.
Overview
This course is not currently scheduled. Please get in touch to book.
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:
- September 14, 2020 @ 9:00 am UTC+11
- End:
- September 18, 2020 @ 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/