20761: Querying Data with Transact-SQL (MOC20761)

Placeholder

20761: Querying Data with Transact-SQL (MOC20761)

 2.345,00

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.

Doel

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.

    Voorkennis

    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)

    Vorm

    Classical and Tailor iT made training

    Inhoud

    During this course the following topics will be covered:

    Module 1: Introduction to Microsoft SQL Server 2016

    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 2016 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 Set Operators

    Vervolgopleidingen

    Bijzonderheden

    5 days

    € 2.345

    Cursusdata

    21, 22, 23, 24 en 25 augustus 2017

    11, 12, 13, 14 en 15 september 2017

    9, 10, 11, 12 en 13 oktober 2017

    20, 21, 22, 23 en 24 november 2017

    18, 19, 20, 21 en 22 december 2017

    Andere data?

    Locaties

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

    Andere locatie?

    SKU: MOC20761 Categorieën: , , Tag:
    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.