HOME
 

Advanced Querying Microsoft SQL Server with Transact-SQL

StayAhead Training
Course summary
2 days
750 GBP excl. VAT
Professional Training
Next available date: 08/10/2020 09:30 - Online courses
Course Dates
London
08/10/2020 09:30 
750 GBP
19/11/2020 09:30 
750 GBP
14/01/2021 09:30 
750 GBP
Online courses
08/10/2020 09:30 
750 GBP
19/11/2020 09:30 
750 GBP
14/01/2021 09:30 
750 GBP

Course description

The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques. This course covers Microsoft SQL Server up to version 2016.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Creating and using Views
  • Using table expressions
  • Enhanced Grouping and Pivoting Data
  • Using Windowing ranking, offset and ranking functions
  • Creating and using Stored Procedures
  • Controlling Program Flow
  • Using Dynamic SQL
  • Implementing Error Handling
  • Improving Query Performance
Who will the Course Benefit?

IT Professionals and non-technical 'power users' who are required to implement more complex Transact-SQL queries.

Course Objectives

To provide more advanced coding skills for those already familiar with using basic Transact-SQL or as a follow-on course for those who have previously attended the Querying Microsoft SQL Server with Transact-SQL course.

Examinations

This course will cover some of the topics required for exam:

  • 70-761:Querying Data with Transact-SQL

Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.

Before taking any exam, ensure you have the recommended experience. The Microsoft website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Requirements

A working knowledge of SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite Querying Microsoft SQL Server with Transact-SQL course.

Pre-Requisite Courses
  • Querying Microsoft SQL Server with Transact-SQL
Follow-On Courses
  • Programming Microsoft SQL Server with Transact-SQL
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Advanced Querying Microsoft SQL Server with Transact-SQL Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: USING TABLE EXPRESSIONS

  • Creating and using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions

Session 2: PIVOTING AND ENHANCED GROUPING

  • Using PIVOT and UNPIVOT in Queries
  • Working with GROUPING SETS
  • Using ROLLUP, CUBE,GROUPING and GROUPING_ID

Session 3: USING WINDOWING FUNCTIONS

  • Using Window AGGREGATE functions in Queries
  • Using Window RANK functions in Queries
  • Using Window OFFSET functions in Queries
Advanced Querying Microsoft SQL Server with Transact-SQL Training Course

Course Contents - DAY 2

Session 4: IMPLEMENTING STORED PROCEDURES

  • Overview of Stored Procedures
  • Creating simple Stored Procedures
  • Executing Stored Procedures
  • Passing parameters to Stored Procedures

Session 5: PROGRAMMING WITH TRANSACT-SQL

  • Using Programming Elements in Transact-SQL
  • Controlling Program Flow with IF/ELSE
  • Controlling Program Flow with WHILE
  • Working with Dynamic SQL

Session 6: IMPLEMENTING ERROR HANDLING

  • Structured error handling with TRY / CATCH block
  • Unstructured error handling
  • Generating error message using THROW and RAISEERROR
  • Error handling in conjunction with Transaction Control

Session 7: IMPROVING QUERY PERFORMANCE

  • Factors in Query Performance
  • Displaying Query Performance Data

The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques. This course covers Microsoft SQL Server up to version 2016.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Creating and using Views
  • Using table expressions
  • Enhanced Grouping and Pivoting Data
  • Using Windowing ranking, offset and ranking functions
  • Creating and using Stored Procedures
  • Controlling Program Flow
  • Using Dynamic SQL
  • Implementing Error Handling
  • Improving Query Performance
Who will the Course Benefit?

IT Professionals and non-technical 'power users' who are required to implement more complex Transact-SQL queries.

Course Objectives

To provide more advanced coding skills for those already familiar with using basic Transact-SQL or as a follow-on course for those who have previously attended the Querying Microsoft SQL Server with Transact-SQL course.

Examinations

This course will cover some of the topics required for exam:

  • 70-761:Querying Data with Transact-SQL

Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.

Before taking any exam, ensure you have the recommended experience. The Microsoft website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Requirements

A working knowledge of SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite Querying Microsoft SQL Server with Transact-SQL course.

Pre-Requisite Courses
  • Querying Microsoft SQL Server with Transact-SQL
Follow-On Courses
  • Programming Microsoft SQL Server with Transact-SQL
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Advanced Querying Microsoft SQL Server with Transact-SQL Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: USING TABLE EXPRESSIONS

  • Creating and using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions

Session 2: PIVOTING AND ENHANCED GROUPING

  • Using PIVOT and UNPIVOT in Queries
  • Working with GROUPING SETS
  • Using ROLLUP, CUBE,GROUPING and GROUPING_ID

Session 3: USING WINDOWING FUNCTIONS

  • Using Window AGGREGATE functions in Queries
  • Using Window RANK functions in Queries
  • Using Window OFFSET functions in Queries
Advanced Querying Microsoft SQL Server with Transact-SQL Training Course

Course Contents - DAY 2

Session 4: IMPLEMENTING STORED PROCEDURES

  • Overview of Stored Procedures
  • Creating simple Stored Procedures
  • Executing Stored Procedures
  • Passing parameters to Stored Procedures

Session 5: PROGRAMMING WITH TRANSACT-SQL

  • Using Programming Elements in Transact-SQL
  • Controlling Program Flow with IF/ELSE
  • Controlling Program Flow with WHILE
  • Working with Dynamic SQL

Session 6: IMPLEMENTING ERROR HANDLING

  • Structured error handling with TRY / CATCH block
  • Unstructured error handling
  • Generating error message using THROW and RAISEERROR
  • Error handling in conjunction with Transaction Control

Session 7: IMPROVING QUERY PERFORMANCE

  • Factors in Query Performance
  • Displaying Query Performance Data

Expenses

£750.00

Continuing Studies

Follow on course: Programming Microsoft SQL Server with Transact-SQL

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

StayAhead Training: Linux, Oracle, SQL, Professional IT Courses

Live Virtual Training with our live Course Instructor is offered for all our courses.  Take the course from the comfort of your office, home or any location of your choice, nationally and internationally.  Public schedule and Closed Company courses.  Flexibility...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Advanced Querying Microsoft SQL Server with Transact-SQL.

  Contact the provider

  Get more information

  Register your interest

Contact info

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

 Show phone number
www.stayahead.com


Reviews

Average rating 5

Based on 4 reviews

Sorina
(5)
Excellent course, very detailed and extensive coverage for a one day course. The tutor was very helpful, answer all additional questions from attendees. In past experience, the content of today's course is covered in a number of weeks elsewhere. The course material is a complete manual that I can refer to in the future.
Milo
(5)
Very interesting and enjoyable course, a considerable step-up from the initial T-SQL course which was very welcome. Small class sizes mean there's plenty of chance for direct interaction with the lecturer who was more than helpful. The first course is really good; the advanced course is even better.
Claire
(5)
Kevin went above and beyond to make the course as applicable and accessible as possible.
Request information

Find out more about this Advanced Querying Microsoft SQL Server with Transact-SQL course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here