Pobierz kartę szkolenia

Querying Data with Microsoft Transact-SQL

kod szkolenia: DP-080 / ENG DL 2d
Authorized Microsoft Querying Data with Microsoft Transact-SQL training DP-080 Distance Learning course.   The training is addressed to:
  • Database administrator
  • IT specialist
  • Data analyst

poziom Średnio zaawansowany

W celu uzyskania informacji skontaktuj się z działem handlowym. W celu uzyskania informacji skontaktuj się z działem handlowym.
3 200,00 PLN 3 936,00 PLN brutto
  • Microsoft SQL
  • Azure SQL
  • Azure Synapse Analytics
  • Databases

 

The course will teach Microsoft dialect fundamentals in standard SQL language: Transact-SQL.

Topics include both querying and data modifications in relational databases, which are hosted in database systems based on Microsoft SQL Server, including: Microsoft SQL Server, Azure SQL Database i Azure Synapse Analytics.

  • The use of SQL Server querying tools
  • Instrukcje SELECT instructions to download columns from one or more tables
  • Sorting and filtering selected data
  • Using built-in features to return data values
  • Creating data groups and aggregating results
  • Data modification using Transact-SQL: INSERT, UPDATE, DELETE i MERGE

 

DP-080 course may be beneficial for everyone who needs to:

  • write basic SQL or Transact-SQL queries

 

or works:

 

  • with data as:
  • data analyst
  • data engineer
  • scientist
  • database administrator
  • database developer

 

  • it may also be useful for other people engaged peripherally in data or who would like to know more about working with data, such as solution architects, students and technology managers.

To make your work more convenient and training more effective, we suggest using an additional screen. Lack of such screen does not exclude participation in the training; however, it significantly influences working comfort during classes.

You can find information and requirements of participation in Distance Learning trainings at: https://www.altkomakademia.pl/distance-learning/#FAQ

  • Training: English
  • Materials: English

 

  •  

https://learn.microsoft.com/pl-pl/training/

  • access to Altkom Akademia student

 

Training method:

  • theory
  • demos
  • individual laboratories
  • 50% theory
  • 50% practice

 

  • Introduction to Transact-SQL
  • Using SELECT instruction
  1. Sorting and filtering query results
  • Sorting query results
  • Data filtering
  1. The use of connections and subqueries
  • The use of JOIN operation
  • Using subqueries
  1. The use of embedded functions
  • First steps with scalar functions
  • Grouping aggregated results
  1. Data modification
  • Placing data in tables
  • Modifying and deleting data