Querying Data With Microsoft Transact-SQL (DP-080T00)

by AFI Expertise Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

AFI Expertise Logo

img Duration

2 Days

Course Details

This 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.

 

Objectives:

  • 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
  • Quebec City Branch

    1751, rue du Marais, #300, Quebec City

Check out more SQL Server courses in Canada

VoiSAP Calgary Logo

Oracle DBA Certification Training

Moreover, with our lifelong access to the courseware and community features, you can revisit any topic whenever you want. Get the best  Oracle Database Administrator course from top certified mentors.

by VoiSAP Calgary [Claim Listing ]
MindTech Montreal Logo

Microsoft Suite Training (SSIS-SSAS-SSRS)

The Microsoft Suite training (SSIS-SSAS-SSRS) allows you to design and deploy a Business Intelligence solution with SQL Server.

by MindTech Montreal [Claim Listing ]
Doussou Formation Logo

SQL Server Training

At the end of this course, participants will be able to create tables, insert, query, modify,, and delete data from tables.

by Doussou Formation [Claim Listing ]
HiTech Institute Logo

Integrating Data Encryption into a Microsoft® SQL Server™ 2005

In this course, you apply guidelines and considerations for securing data using encryption and certificates. You describe various data encryption policies. Finally, you determine a key storage method.

by HiTech Institute [Claim Listing ]
University Of Calgary Logo

Certificate in Database Administration

Microsoft SQL Server is the backbone for thousands of industry-leading software applications, including Microsoft SharePoint and SAP. You will learn how to design, develop, administer, and troubleshoot Microsoft SQL databases and servers.

by University Of Calgary [Claim Listing ]
  • Price
  • Start Date
  • Duration

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