20761: Querying Data with Transact-SQL (MOC20761)

Logo TailorIT RGB

20761: Querying Data with Transact-SQL (MOC20761)


20761: Querying Data with Transact-SQL (MOC20761)

The purpose of this 5 day course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; Business Intelligence, Database Administration and Database Development.


After following this course, the students 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 Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use windows ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
  • Doelgroep

    This course is designed for Database Administrators, Businesss Intelligence professionals and Database Developers. The course will be attended by SQL power users who aren't necessarily database-focused; client application developers, namely, business analysts and report writers.


    To participate in this course the studens need working knowledge of relational databases. This knowledge can be acquired by attending course 10985: Introduction to SQL databases (MOC10985)


    Classical and Tailor iT made training


    During this course the following topics will be covered:

    Module 1: Introduction to Microsoft SQL Server

    Module 2: Introduction to T-SQL Querying

    Module 3: Writing SELECT Queries

    Module 4: Querying Multiple Tables

    Module 5: Sorting and Filtering Data

    Module 6: Working with SQL Server Data Types

    Module 7: Using DML to Modify Data

    Module 8: Using Built-In Functions

    Module 9: Grouping and Aggregating Data

    Module 10: Using Subqueries

    Module 11: Using Table Expressions

    Module 12: Using Set Operators

    Module 13: Using Windows Ranking, Offset and Aggregate Functions

    Module 14: Pivoting and Grouping Sets

    Module 15: Executing Stored Procedures

    Module 16: Programming with T-SQL

    Module 17: Implementing Error Handling

    Module 18: Implementing Transactions



    5 days

    € 2.345


    7, 8, 9, 10 en 11 oktober 2019

    4, 5, 6, 7 en 8 november 2019

    2, 3, 4, 5 en 6 december 2019

    Andere data?


    Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

    Andere locatie?

    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.