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

New Horizons London Logo

Introduction to SQL Databases

This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management.

by New Horizons London [Claim Listing ]
PMVISION Logo

Oracle Primavera P6 Training Course

The Primavera P6 Training Course will prepare you to efficiently track your project teams, schedules, tasks, and finances, manage your entire project, and accurately report your progress to date.

by PMVISION [Claim Listing ]
Formation SETC Logo

Oracle Training

The SETC Montreal-Ottawa Training Oracle courses teach you how to install, configure, and manage an Oracle database server under Windows or Linux. Our training covers the installation and administration of Oracle, Oracle Forms & Reports, and the Oracle GRID infrastructure.

by Formation SETC [Claim Listing ]
NetPLUS College of Information Technology Logo

MS SQL

Write SELECT statements to access data from more than one table using equijoins and none qui joins. Generate a Cartesian product of all rows from two or more tables

by NetPLUS College of Information Technology [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 ]

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