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 Logo

Oracle DBA Certification Training

This Oracle DBA certification training aims to make you certified in Oracle DBA. This training program is led by industry experts from top companies like IBM, Amazon, etc. across the world.

by VoiSAP [Claim Listing ]
ETS Formation Logo

SQL Server A Functional Introduction)

Put into production and maintain Microsoft SQL Server. Securely manage, monitor and network one or more Microsoft SQL Server databases.

by ETS Formation [Claim Listing ]
Adaleg IT Logo

Database

This course provides a detailed overview of databases, security, architecture, pricing, and support. This introductory course was designed to be delivered and prepares students to pursue becoming an Database Certified Practitioner.

by Adaleg IT [Claim Listing ]
Sanrus Training Centre Logo

Java Database Connectivity

The Java Database Connectivity course will introduce you to the JDBC 3.0 API, which will teach you how to establish a connection to a database server and then various SQL operations using the JDBC API.

by Sanrus Training Centre [Claim Listing ]
OCMT (Ontario College of Management & Technology) Logo

Oracle Database (Suite 1)

To effectively and efficiently manage today’s business-critical information, organizations depend on database systems that are flexible, reliable, and scalable and on experienced professionals to handle them.

by OCMT (Ontario College of Management & Technology) [Claim Listing ]
  • Price
  • Start Date
  • Duration

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