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

ACE Training Ltd Logo

SQL Server Integration Services (55321AC)

This five-day instructor-led course is intended for IT professionals who need to learn how to use SQL Server Integration Services to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server.

by ACE Training Ltd [Claim Listing ]
Koenig Step Forward Logo

Migrate NoSQL Workloads To Azure Cosmos DB

The DP-060T00: Migrate NoSQL workloads to Azure Cosmos DB certification is about demonstrating expertise in migrating NoSQL workloads to Microsoft's Azure Cosmos DB.

by Koenig Step Forward [Claim Listing ]
Bilginc IT Academy Logo

MySQL For Developers Training

This MySQL for Developers training teaches developers how to develop console and web applications using MySQL with their choice of the PHP, Java, or Python programming languages.

by Bilginc IT Academy [Claim Listing ]
Bilginc IT Academy Logo

Oracle Database 12c R2 (Introduction To SQL Ed 2) Training

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

by Bilginc IT Academy [Claim Listing ]
AH Accounting & Training Services Logo

Certificate in Oracle Database

This course is in preparation for the The Oracle Database 11g Administrator (OCA 11g) certification exam. The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise.

by AH Accounting & Training Services [Claim Listing ]

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