logo-img
  • In trainingen zoeken...
  • No direct match found.
    Let AI search for a suitable alternative via Enter or the search button.
We are looking for the best courses for you…
All Trainings
All Trainings
  • In trainingen zoeken...
  • No direct match found.
    Let AI search for a suitable alternative via Enter or the search button.
We are looking for the best courses for you…
NL / EN
DP-080 training - Querying Data with Microsoft Transact-SQL

DP-080 training - Querying Data with Microsoft Transact-SQL

3 days Classroom

Sharpest price in just 2 steps

Requesting more information and/or the current price of this training is easy. We take into account any ongoing promotions, subsidies, or relationship discounts.
1 of 2
2 van 2

Why DP-080 training - Querying Data with Microsoft Transact-SQL at TSTC?

  • Classroom or Live Online training in small groups of up to 10 participants with dedicated experienced instructors.
  • Practical hands-on training instead of pure PowerPoint training -> acquired knowledge is directly applicable in the workplace and less theoretical.
Training Summary

Description

In this extended training, you will learn how to use Transact-SQL to query and modify data in the following relational, Microsoft SQL Server-based database systems through a balanced combination of theory and practice:

  • Microsoft SQL Server
  • Azure SQL Database
  • Azure Synapse Analytics.

Transact-SQL is based on the SQL ANSI standard. Transact-SQL is a comprehensive language with many advanced capabilities. In this training, you will learn the most commonly used queries and we will cover among others the following most common scenarios:

  • Using SELECT to retrieve columns from a table
  • Sorting and filtering search results
  • Using joins and subqueries to retrieve data from multiple tables
  • Using built-in functions, aggregations, and groupings
  • Inserting, updating, and deleting data

Certification

There is no exam associated with this training. However, you will receive a certificate of participation.

Training Requirements

  • Deze training is bedoeld voor iedereen die basis SQL- of Transact-SQL-query’s schrijft.
  • Bijvoorbeeld data analisten, data engineers, data scientists, database beheerders of database ontwikkelaars.

Training Content

• Introduction to Transact-SQL
• Using the SELECT statement

• Sorting query results
• Filtering the data

• Using JOIN operations
• Using subqueries

• Getting started with scalar functions
• Grouping aggregated results

• Inserting data into tables
• Modifying and deleting data

Description

In this extended training, you will learn how to use Transact-SQL to query and modify data in the following relational, Microsoft SQL Server-based database systems through a balanced combination of theory and practice:

  • Microsoft SQL Server
  • Azure SQL Database
  • Azure Synapse Analytics.

Transact-SQL is based on the SQL ANSI standard. Transact-SQL is a comprehensive language with many advanced capabilities. In this training, you will learn the most commonly used queries and we will cover among others the following most common scenarios:

  • Using SELECT to retrieve columns from a table
  • Sorting and filtering search results
  • Using joins and subqueries to retrieve data from multiple tables
  • Using built-in functions, aggregations, and groupings
  • Inserting, updating, and deleting data

Certification

There is no exam associated with this training. However, you will receive a certificate of participation.

Training Requirements

  • Deze training is bedoeld voor iedereen die basis SQL- of Transact-SQL-query’s schrijft.
  • Bijvoorbeeld data analisten, data engineers, data scientists, database beheerders of database ontwikkelaars.

Training Content

• Introduction to Transact-SQL
• Using the SELECT statement

• Sorting query results
• Filtering the data

• Using JOIN operations
• Using subqueries

• Getting started with scalar functions
• Grouping aggregated results

• Inserting data into tables
• Modifying and deleting data

shape

I am taking this next step in my lifelong learning journey.

DP-080 training - Querying Data with Microsoft Transact-SQL

Enrollment Form

1

Applicant Information

2

Billing Information

What Can I Learn After The DP-080 training - Querying Data with Microsoft Transact-SQL?

  • Using SQL Server query tools
  • Use built-in functions to return data values.
  • Writing SELECT statements to retrieve columns from one or more tables
  • Grouping data and aggregating the results
  • Sorting and filtering selected data
  • Modifying data using INSERT, UPDATE, DELETE, and MERGE

Schedules

This training is scheduled as follows in the coming period. Missing a date? Feel free to contact us.

Date: In overleg

Location: TSTC Veenendaal

Request current price

DP-080 training - Querying Data with Microsoft Transact-SQL

Enrollment Form

1

Applicant Information

2

Billing Information

I am taking this next step in my lifelong learning journey.

DP-080 training - Querying Data with Microsoft Transact-SQL

Enrollment Form

1

Applicant Information

2

Billing Information

Why experienced professionals choose TSTC for their studies

Train smarter, not harder. TSTC's unique approach guarantees the effective acquisition of skills and the greatest chance of success.

Learn more about TSTC
Toucan Rhino