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

Centennial College Logo

Oracle Database Administration Fundamentals 1

Oracle Database Administration Fundamentals 1 teaches how to install and maintain an Oracle database, the first step in obtaining a solid foundation in basic database administration.

by Centennial College [Claim Listing ]
  • Price
  • Start Date
  • Duration
Global Erp Solutions Brampton Logo

SQL

This course would prepare candidates for SQL Certification for Foundation level.

by Global Erp Solutions Brampton [Claim Listing ]
Ultimate IT Courses Logo

Database Training

Effective data management: Databases allow for the systematic storage and organization of enormous volumes of data, making it simple to retrieve and change the data as required.

by Ultimate IT Courses [Claim Listing ]
OptionTrain College Of Management & Technology Logo

Oracle Database 11G (Introduction To SQL)

This course 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 OptionTrain College Of Management & Technology [Claim Listing ]
The Great Canadian Training & Consulting Company Logo

SQL Training Courses

SQL (Structured Query Language) is a standard language used for storing, manipulating, and retrieving data from relational databases. It is the primary language for interacting with most databases.

by The Great Canadian Training & Consulting Company

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