冠通|棋牌

  • The Knowledge Academy Logo
    The Knowledge Academy Logo
    01344 203999 - Available 24/7

    Send us your message.

    X

    Querying Data With Transact-SQL M20761 - United Kingdom

    Key points about this course


    Duration: 5 Days*

    Accredited: Yes

    Support: 24/7

    Dates & Prices Enquire
    • Microsoft Silver Learning Partner, therefore fully accredited training
    • Prepare for the Microsoft 70-761 examination
    • Exam guidance, course materials and pre & post course support provided

    Available delivery methods for this course

    Classroom Icon

    Classroom

    Virtual Icon

    Live Virtual

    Online Icon

    Online

    Onsite Icon

    Onsite

    Course Information

    Querying Data with Transact-SQL Overview

    This 5 day Microsoft Querying Data with Transact-SQL training course provides delegates with an introduction to Transact-SQL. The first 3 days take the form of classroom teaching whereby candidates acquire the knowledge needed to complete more SQL Server courses. The final 2 days focus more on the exam, developing the skills needed to complete it successfully. Delegates will understand Transact-SQL language adopted by those within SQL Server disciplines.

     

    They will be taught the fundamentals of Transact-SQL, how to write queries, how to sort data, and the process of executing procedures. By the end of this training course, delegates will be ready to complete and pass the Querying Data with Transact-SQL 70-761 examination.

    Querying Data with Transact-SQL Outline

    Module 1: Introduction to Microsoft SQL Server 2016

    • The Basic Architecture of SQL Server

    • SQL Server Editions and Versions

    • Getting Started with SQL Server Management Studio

    • Lab: Working with SQL Server 2016 Tools

      • Working with SQL Server Management Studio

      • Creating and Organizing T-SQL Scripts

      • Using Books Online

     

    Module 2: Introduction to T-SQL Querying

    • Introducing T-SQL

    • Understanding Sets

    • Writing Queries

    • Understanding Predicate Logic

    • Understanding the Logical Order of Operations in SELECT statements

    • Lab: Introduction to T-SQL Querying

      • Executing Basic SELECT Statements

      • Executing Queries that Filter Data using Predicates

      • Executing Queries That Sort Data Using ORDER BY

     

    Module 3: Writing SELECT Queries

    • Writing Simple SELECT Statements

    • Eliminating Duplicates with DISTINCT

    • Using Column and Table Aliases

    • Writing Simple CASE Expressions

    • Lab: Writing Basic SELECT Statements

      • Writing Simple SELECT Statements

      • Eliminating Duplicates Using DISTINCT

      • Using Column and Table Aliases

      • Using a Simple CASE Expression

     

    Module 4: Querying Multiple Tables

    • Understanding the Fundamentals of Joins

    • Querying with Inner Joins

    • Querying with Outer Joins

    • Querying with Cross Joins and Self Joins

    • Lab: Querying Multiple Tables

      • Writing Queries that use Inner Joins

      • Writing Queries that use Multiple-Table Inner Joins

      • Writing Queries that use Self-Joins

      • Writing Queries that use Outer Joins

      • Writing Queries that use Cross Joins

     

    Module 5: Sorting and Filtering Data

    • Sorting Data

    • Filtering Data with Predicates

    • Filtering Data with TOP and OFFSET-FETCH

    • Working with Unknown Values

    • Lab: Sorting and Filtering Data

      • Writing Queries that Filter Data using a WHERE Clause

      • Writing Queries that Sort Data Using an ORDER BY Clause

      • Writing Queries that Filter Data Using the TOP Option

     

    Module 6: Working with SQL Server 2016 Data Types

    • Introducing SQL Server 2016 Data Types

    • Working with Character Data

    • Working with Date and Time Data

    • Lab: Working with SQL Server 2016 Data Types

      • Writing Queries that Return Date and Time Data

      • Writing Queries that use Date and Time Functions

      • Writing Queries That Return Character Data

      • Writing Queries That Return Character Functions

     

    Module 7: Using DML to Modify Data

    • Inserting Data

    • Creating DML Queries

    • Modifying and Deleting Data

    • Lab: Using DML to Modify Data

      • Inserting Data

      • Updating, Merging, and Deleting Data

     

    Module 8: Using Built-In Functions

    • Writing Queries with Built-In Functions

    • Using Conversion Functions

    • Using Logical Functions

    • Using Functions to Work with NULL

    • Lab: Using Built-In Functions

      • Writing Queries That Use Conversion Functions

      • Writing Queries that use Logical Functions

      • Writing Queries that Test for Nullability

     

    Module 9: Grouping and Aggregating Data

    • Using Aggregate Functions

    • Using the GROUP BY Clause

    • Filtering Groups with HAVING

    • Lab: Grouping and Aggregating Data

      • Writing Queries That Use the GROUP BY Clause

      • Writing Queries that Use Aggregate Functions

      • Writing Queries that Use Distinct Aggregate Functions

      • Writing Queries that Filter Groups with the HAVING Clause

     

    Module 10: Using Subqueries

    • Writing Self-Contained Subqueries

    • Writing Correlated Subqueries

    • Using the EXISTS Predicate with Subqueries

    • Lab: Using Subqueries

      • Writing Queries That Use Self-Contained Subqueries

      • Writing Queries That Use Scalar and Multi-Result Subqueries

      • Writing Queries That Use Correlated Subqueries and an EXISTS Clause

     

    Module 11: Using Table Expressions

    • Using Views

    • Using Inline Table-Valued Functions (TVFs)

    • Using Derived Tables

    • Using Common Table Expressions (CTEs)

    • Lab: Using Table Expressions

      • Writing Queries That Use Views

      • Writing Queries That Use Derived Tables

      • Writing Queries That Use Common Table Expressions (CTEs)

      • Writing Queries That Sue Inline Table-Valued Expressions

     

    Module 12: Using Set Operators

    • Writing Queries with the UNION operator

    • Using EXCEPT and INTERSECT

    • Using APPLY

    • Comparing Rows Between Two Input Sets

    • Lab: Using Set Operators

      • Writing Queries That Use UNION Set Operators and UNION ALL

      • Writing Queries That Use CROSS APPLY and OUTER APPLY Operators

      • Writing Queries That Use the EXCEPT and INTERSECT Operators

     

    Module 13: Using Windows Ranking, Offset, and Aggregate Functions

    • Benefits of Window Functions

    • Restricting Window Functions

    • Creating Windows with OVER

    • Exploring Window Functions

    • Lab: Using Windows Ranking, Offset, and Aggregate Functions

      • Writing Queries that use Ranking Functions

      • Writing Queries that use Offset Functions

      • Writing Queries that use Window Aggregate Functions

     

    Module 14: Pivoting and Grouping Sets

    • Writing Queries with PIVOT and UNPIVOT

    • Working with Grouping Sets

    • Lab: Pivoting and Grouping Sets

      • Writing Queries that use the PIVOT Operator

      • Writing Queries that use the UNPIVOT Operator

      • Writing Queries that use the GROUPING SETS CUBE and ROLLUP Subclauses

     

    Module 15: Executing Stored Procedures

    • Querying Data with Stored Procedures

    • Passing Parameters to Stored procedures

    • Creating Simple Stored Procedures

    • Working with Dynamic SQL

    • Lab: Executing Stored Procedures

      • Using the EXECUTE statement to Invoke Stored Procedures

      • Passing Parameters to Stored procedures

      • Executing System Stored Procedures

     

    Module 16: Programming with T-SQL

    • T-SQL Programming Elements

    • Controlling Program Flow

    • Lab: Programming with T-SQL

      • Declaring Variables and Delimiting Batches

      • Using Control-Of-Flow Elements

      • Using Variables in a Dynamic SQL Statement

      • Using Synonyms

     

    Module 17: Implementing Error Handling

    • Implementing T-SQL error handling

    • Implementing structured exception handling

    • Lab: Implementing Error Handling

      • Redirecting errors with TRY/CATCH

      • Using THROW to pass an error message back to a client

     

    Module 18: Implementing Transactions

    • Transactions and the Database Engines

    • Controlling Transactions

    • Lab: Implementing Transactions

      • Controlling transactions with BEGIN, COMMIT, and ROLLBACK

      • Adding error handling to a CATCH block

    Who should attend?

    Querying Data with Transact-SQL M20761 is designed for those within SQL Server-related roles, predominantly Database Administrators, Database Developers, and Business Intelligence professionals.

     

    Prerequisites

    Delegates should possess knowledge of:

    • Relational databases

    • The Microsoft Windows operating system

    Delegates will need to take the Querying Data with Transact-SQL 70-761 examination. The exam is not included with the training course and must be taken separately.
    Querying Data with Transact-SQL is a 5 day training course.
    Please arrive at the venue at 8:45am.
    No, however you will need to possess some knowledge of relational databases and Microsoft Windows operating systems.
    The price for Querying Data with Transact-SQL M20761 certification in the United Kingdom starts from £500
    The Knowledge Academy is the Leading global training provider in the world for Querying Data with Transact-SQL M20761.

    Querying Data with Transact-SQL Examination

    The exam associated with this course is the Querying Data with Transact-SQL 70-761 examination, which will cover the following areas:

    • Managing Data with Transact-SQL

    • Querying Data with Advanced Transact-SQL Components

    • Programming Databases by Using Transact-SQL

     

    Delegates will need to sign a non-disclosure exam agreement, which states that they will not share information relating to the exam structure with anyone. 

    Key points about this course


    Duration: 5 Days*

    Accredited: Yes

    Support: 24/7

    View dates & prices

    Find out more

    Please enter Name
    Please enter valid Email
    Please enter valid phone
    The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

    We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

    Or call us now
    01344 203999

    Querying Data With Transact-SQL M20761 Dates & Prices

    Select your preferred delivery method

    Choose a Region

    Choose a Location

    Choose a Month

    Office Icon Attend your course from the office or home
    Trainers Icon Interactive support from experienced trainers
    Simple Icon Simple to setup and easy to use on any device
    Glasgow
    Mon 9th Mar 2020
    Places available
    £3995
    Nottingham
    Mon 9th Mar 2020
    Places available
    £3995
    Birmingham
    Mon 9th Mar 2020
    Places available
    £2995
    Mon 9th Mar 2020
    Places available
    £2195
    Manchester
    Mon 16th Mar 2020
    Places available
    £2995
    Edinburgh
    Mon 16th Mar 2020
    Places available
    £3995
    Brighton
    Mon 16th Mar 2020
    Places available
    £3995
    Dublin
    Mon 23rd Mar 2020
    Places available
    €3995
    Leeds
    Mon 23rd Mar 2020
    Places available
    £3995
    Milton Keynes
    Mon 23rd Mar 2020
    Places available
    £3995
    Belfast
    Mon 30th Mar 2020
    Places available
    £3995
    Liverpool
    Mon 30th Mar 2020
    Places available
    £3995
    Maidstone
    Mon 30th Mar 2020
    Places available
    £3995
    Mon 6th Apr 2020
    Places available
    £2195
    Sheffield
    Mon 20th Apr 2020
    Places available
    £3995
    33%
    off
    Mon 20th Apr 2020
    Places available
    Was: £2995
    Now: £1995
    Cambridge
    Mon 20th Apr 2020
    Places available
    £3995
    Bristol
    Mon 20th Apr 2020
    Places available
    £3995
    Edinburgh
    Mon 20th Apr 2020
    Places available
    £3995
    Newcastle
    Mon 20th Apr 2020
    Places available
    £3995
    Manchester
    Mon 20th Apr 2020
    Places available
    £2995
    Leeds
    Mon 27th Apr 2020
    Places available
    £3995
    Aberdeen
    Mon 27th Apr 2020
    Places available
    £3995
    Birmingham
    Mon 27th Apr 2020
    Places available
    £2995
    Norwich
    Mon 27th Apr 2020
    Places available
    £3995
    Glasgow
    Mon 27th Apr 2020
    Places available
    £3995
    Cardiff
    Mon 27th Apr 2020
    Places available
    £3995
    Reading
    Mon 27th Apr 2020
    Places available
    £3995
    Bristol
    Mon 11th May 2020
    Places available
    £3995
    Edinburgh
    Mon 11th May 2020
    Places available
    £3995
    Southampton
    Mon 11th May 2020
    Places available
    £3995
    London
    Mon 11th May 2020
    Places available
    £2995
    Maidstone
    Mon 11th May 2020
    Places available
    £3995
    Manchester
    Mon 11th May 2020
    Places available
    £2995
    Brighton
    Mon 11th May 2020
    Places available
    £3995
    Dublin
    Mon 11th May 2020
    Places available
    €3995
    Belfast
    Mon 18th May 2020
    Places available
    £3995
    Birmingham
    Mon 18th May 2020
    Places available
    £2995
    Nottingham
    Mon 18th May 2020
    Places available
    £3995
    Liverpool
    Mon 18th May 2020
    Places available
    £3995
    Glasgow
    Mon 18th May 2020
    Places available
    £3995
    Milton Keynes
    Mon 18th May 2020
    Places available
    £3995
    Leeds
    Mon 18th May 2020
    Places available
    £3995
    Tue 26th May 2020
    Places available
    £2195
    Newcastle
    Mon 1st Jun 2020
    Places available
    £3995
    Manchester
    Mon 1st Jun 2020
    Places available
    £2995
    Bristol
    Mon 1st Jun 2020
    Places available
    £3995
    London
    Mon 8th Jun 2020
    Places available
    £2995
    Glasgow
    Mon 8th Jun 2020
    Places available
    £3995
    Cardiff
    Mon 8th Jun 2020
    Places available
    £3995
    Birmingham
    Mon 15th Jun 2020
    Places available
    £2995
    Mon 15th Jun 2020
    Places available
    £2195
    Cambridge
    Mon 15th Jun 2020
    Places available
    £3995
    Edinburgh
    Mon 15th Jun 2020
    Places available
    £3995
    Leeds
    Mon 22nd Jun 2020
    Places available
    £3995
    Reading
    Mon 22nd Jun 2020
    Places available
    £3995
    Sheffield
    Mon 22nd Jun 2020
    Places available
    £3995
    Aberdeen
    Mon 29th Jun 2020
    Places available
    £3995
    Norwich
    Mon 29th Jun 2020
    Places available
    £3995
    Manchester
    Mon 6th Jul 2020
    Places available
    £2995
    Bristol
    Mon 6th Jul 2020
    Places available
    £3995
    Dublin
    Mon 6th Jul 2020
    Places available
    €3995
    Mon 6th Jul 2020
    Places available
    £2195
    Southampton
    Mon 6th Jul 2020
    Places available
    £3995
    Glasgow
    Mon 13th Jul 2020
    Places available
    £3995
    Nottingham
    Mon 13th Jul 2020
    Places available
    £3995
    Belfast
    Mon 13th Jul 2020
    Places available
    £3995
    London
    Mon 13th Jul 2020
    Places available
    £2995
    Maidstone
    Mon 20th Jul 2020
    Places available
    £3995
    Brighton
    Mon 20th Jul 2020
    Places available
    £3995
    Edinburgh
    Mon 20th Jul 2020
    Places available
    £3995
    Birmingham
    Mon 20th Jul 2020
    Places available
    £2995
    Liverpool
    Mon 27th Jul 2020
    Places available
    £3995
    Leeds
    Mon 27th Jul 2020
    Places available
    £3995
    Milton Keynes
    Mon 27th Jul 2020
    Places available
    £3995
    Bristol
    Mon 3rd Aug 2020
    Places available
    £3995
    Sheffield
    Mon 3rd Aug 2020
    Places available
    £3995
    Newcastle
    Mon 3rd Aug 2020
    Places available
    £3995
    Manchester
    Mon 3rd Aug 2020
    Places available
    £2995
    Cardiff
    Mon 10th Aug 2020
    Places available
    £3995
    London
    Mon 10th Aug 2020
    Places available
    £2995
    Glasgow
    Mon 10th Aug 2020
    Places available
    £3995
    Edinburgh
    Mon 17th Aug 2020
    Places available
    £3995
    Birmingham
    Mon 17th Aug 2020
    Places available
    £2995
    Cambridge
    Mon 17th Aug 2020
    Places available
    £3995
    Leeds
    Mon 24th Aug 2020
    Places available
    £3995
    Norwich
    Mon 24th Aug 2020
    Places available
    £3995
    Reading
    Mon 24th Aug 2020
    Places available
    £3995
    Mon 24th Aug 2020
    Places available
    £2195
    Aberdeen
    Mon 24th Aug 2020
    Places available
    £3995
    Bristol
    Mon 7th Sep 2020
    Places available
    £3995
    Dublin
    Mon 7th Sep 2020
    Places available
    €3995
    Manchester
    Mon 7th Sep 2020
    Places available
    £2995
    Southampton
    Mon 7th Sep 2020
    Places available
    £3995
    London
    Mon 14th Sep 2020
    Places available
    £2995
    Glasgow
    Mon 14th Sep 2020
    Places available
    £3995
    Belfast
    Mon 14th Sep 2020
    Places available
    £3995
    Nottingham
    Mon 14th Sep 2020
    Places available
    £3995
    Edinburgh
    Mon 21st Sep 2020
    Places available
    £3995
    Brighton
    Mon 21st Sep 2020
    Places available
    £3995
    Birmingham
    Mon 21st Sep 2020
    Places available
    £2995
    Maidstone
    Mon 21st Sep 2020
    Places available
    £3995
    Milton Keynes
    Mon 28th Sep 2020
    Places available
    £3995
    Mon 28th Sep 2020
    Places available
    £2195
    Leeds
    Mon 28th Sep 2020
    Places available
    £3995
    Liverpool
    Mon 28th Sep 2020
    Places available
    £3995
    Manchester
    Mon 5th Oct 2020
    Places available
    £2995
    Sheffield
    Mon 5th Oct 2020
    Places available
    £3995
    Newcastle
    Mon 5th Oct 2020
    Places available
    £3995
    Bristol
    Mon 5th Oct 2020
    Places available
    £3995
    London
    Mon 12th Oct 2020
    Places available
    £2995
    Glasgow
    Mon 12th Oct 2020
    Places available
    £3995
    Cardiff
    Mon 12th Oct 2020
    Places available
    £3995
    Mon 19th Oct 2020
    Places available
    £2195
    Cambridge
    Mon 19th Oct 2020
    Places available
    £3995
    Edinburgh
    Mon 19th Oct 2020
    Places available
    £3995
    Birmingham
    Mon 19th Oct 2020
    Places available
    £2995
    Reading
    Mon 26th Oct 2020
    Places available
    £3995
    Aberdeen
    Mon 26th Oct 2020
    Places available
    £3995
    Leeds
    Mon 26th Oct 2020
    Places available
    £3995
    Norwich
    Mon 26th Oct 2020
    Places available
    £3995
    Manchester
    Mon 2nd Nov 2020
    Places available
    £2995
    Southampton
    Mon 2nd Nov 2020
    Places available
    £3995
    Bristol
    Mon 2nd Nov 2020
    Places available
    £3995
    Glasgow
    Mon 9th Nov 2020
    Places available
    £3995
    Nottingham
    Mon 9th Nov 2020
    Places available
    £3995
    London
    Mon 9th Nov 2020
    Places available
    £2995
    Mon 9th Nov 2020
    Places available
    £2195
    Edinburgh
    Mon 16th Nov 2020
    Places available
    £3995
    Birmingham
    Mon 16th Nov 2020
    Places available
    £2995
    Brighton
    Mon 16th Nov 2020
    Places available
    £3995
    Dublin
    Mon 23rd Nov 2020
    Places available
    €3995
    Leeds
    Mon 23rd Nov 2020
    Places available
    £3995
    Milton Keynes
    Mon 23rd Nov 2020
    Places available
    £3995
    Belfast
    Mon 30th Nov 2020
    Places available
    £3995
    Maidstone
    Mon 30th Nov 2020
    Places available
    £3995
    Liverpool
    Mon 30th Nov 2020
    Places available
    £3995
    Sheffield
    Mon 7th Dec 2020
    Places available
    £3995
    Cambridge
    Mon 7th Dec 2020
    Places available
    £3995
    Edinburgh
    Mon 7th Dec 2020
    Places available
    £3995
    Newcastle
    Mon 7th Dec 2020
    Places available
    £3995
    Bristol
    Mon 7th Dec 2020
    Places available
    £3995
    London
    Mon 7th Dec 2020
    Places available
    £2995
    Mon 7th Dec 2020
    Places available
    £2195
    Manchester
    Mon 7th Dec 2020
    Places available
    £2995
    Leeds
    Mon 14th Dec 2020
    Places available
    £3995
    Aberdeen
    Mon 14th Dec 2020
    Places available
    £3995
    Birmingham
    Mon 14th Dec 2020
    Places available
    £2995
    Norwich
    Mon 14th Dec 2020
    Places available
    £3995
    Cardiff
    Mon 14th Dec 2020
    Places available
    £3995
    Glasgow
    Mon 14th Dec 2020
    Places available
    £3995
    Reading
    Mon 14th Dec 2020
    Places available
    £3995

    Complete the steps below to receive a quote or more information

    How will you be funding your training?

    Self funding

    Company funding

    Not sure

    Key points about this course


    Duration: 5 Days*

    Accredited: Yes

    Support: 24/7


    Why choose TKA logo


    Gold Tag

    Best price in the industry

    You won't find better value in the marketplace. If you do find a lower price, we will beat it.

    Trusted Icon

    Trusted & Approved

    Microsoft Silver Learning Partner

    Delivery Icon

    Various delivery methods

    Flexible delivery methods are available depending on your learning style.

    Resource Icon

    Resources

    Resources are included for a comprehensive learning experience.

    Thames Water Logo

    "Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

    Joshua Davies, Thames Water

    Google Logo
    Samsung Logo
    Shell Logo

    "...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

    Diane Gray, Shell

    hsbc-logo
    mercedes-logo
  • 幸福彩票app网址

    优发|国际-在线顶级

    足彩购买app

    彩客彩票网官方端口

    乐彩网首页福彩下载

    彩客竞彩彩票官网apple

    泊利彩票登录

    彩票大赢家首页

    www德赢