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

by Lumify Group Claim Listing

This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and

$1600

Contact the Institutes

Fill this form

Advertisement

Lumify Group Logo

img Duration

2 Days

Course Details

This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

 

After completing this course, students will be able to:

  • Use SQL Server query tools

  • Write SELECT statements to retrieve columns from one or more tables

  • Sort and filter selected data

  • Use built-in functions to returned data values

  • Create groups of data and aggregate the results

  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE, and MERGE

  • Auckland Branch

    Ground Floor, 338 Ponsonby Road Ponsonby, Auckland
  • Wellington Branch

    Level 8, JacksonStone House 11 Hunter Street, Wellington
  • Christchurch Branch

    13 Stanley Street Sydenham, Christchurch

Check out more SQL Server courses in New Zealand

Bilginc IT Academy Logo

Administering Microsoft SQL Server Databases Training

This five-day instructor-led course provides delegates with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

by Bilginc IT Academy [Claim Listing ]
Victoria University of Wellington Logo

Databases

This course introduces the principles of database definition, design, access and implementation.

by Victoria University of Wellington [Claim Listing ]
  • Price
  • Start Date
  • Duration
Course Monster Logo

Oracle SQL Courses

The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic select statement, the use of SQL functions, and the basic table and view handling statements are introduced.

by Course Monster [Claim Listing ]
Bilginc IT Academy Logo

Apache Pig And Hive (Hadoop)

This training course is designed for developers who need to create applications to analyze Big Data stored in Apache Hadoop using Pig and Hive.

by Bilginc IT Academy [Claim Listing ]
Auckland Institute Of Studies Logo

Systems Analysis And Design (COMP601 )

Provides students with the necessary knowledge and skills to manage the complexity of software systems. It introduces systems development process concepts and activities, with a strong focus on understanding the problem and solution through modelling using structured Systems Analysis and Design .

by Auckland Institute Of Studies [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy