70-761 Querying Data with Transact-SQL

3 Day Course  |  £1195.00 (+VAT)

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
  • 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
  • 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.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron