Course 20761B: Querying Data with Transact-SQL

Prihajajoče izvedbe

Nivo:For IT professionals
Prodajalec:Microsoft
Kategorija prodajalca:SQL Server
Teme:Database, Server
Trajanje (dni):5
Ur/dan:8
Tip učenja:Preko spleta
Cena:1.190€ + DDV

The main purpose of this 5 day instructor-led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused: report writers, business analysts, and client application developers.

Course will be held in English.

  • 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
  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Exam code: 70-761
  • This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Gregor Papež, MCT

V angleščini Online Termin ni potrjen

14. junij 2021 - 18. junij 2021

  • Cena: 1.190€ + DDV
Pokaži urnik
  • 14.06.2021, 08:00-16:00
    Online classroom
  • 15.06.2021, 08:00-16:00
    Online classroom
  • 16.06.2021, 08:00-16:00
    Online classroom
  • 17.06.2021, 08:00-16:00
    Online classroom
  • 18.06.2021, 08:00-16:00
    Online classroom

Za več informacij nas kontaktirajte na telefonsko številko: 01 568 40 40 ali trzenje@housing.si.