• 70-761 Querying Data with Transact-SQL

  • 3 Day Course | £1195.00 (+VAT) | 9am-5pm

  • On demand, please enquire

Target Audience

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Required Knowledge

  • Good understanding of t-SQL
  • Ability to create database objects using t-SQL alone
  • Understand the concepts of error handling

Purpose of the Course

This training provides focusses on the requirements for the 70-761 Querying Data with Transact-SQL exam.

This is one half of the Microsoft Certified Solutions Associate SQL 2016 Database Development certification.

Topics Covered

  • Venn diagram operators
  • Different types of JOIN and their syntax
  • Functions and data aggregation
  • Use of the APPLY operator
  • Subqueries and CTEs
  • PIVOT and UNPIVOT
  • Error handling and transactions

Course Modules

Module 1: Managing Data

  • Select Statement
  • Join Types
  • NULL Operator
  • User Defined Functions
  • Aggregating Data
  • Data Modification

Module 2: Querying with Advanced T-SQL

  • Subqueries
  • The APPLY Operator
  • CTEs
  • Temporary Tables
  • Grouping
  • PIVOT Operator
  • Temporal Tables
  • JSON / XML

Module 3: Programming Databases

  • Stored Procedures
  • Output Parameters
  • Indexed Views
  • Dynamic SQL

Module 4: Error Handling

  • TRY...CATCH
  • Throw
  • Raiserror
  • Transactions

Module 5: Performance

  • Data type conversions
  • NULL value considerations
  • isNull and Coalesce
  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.