Querying Data with Microsoft Transact-SQL Training

by Web Age Solutions team Claim Listing

This course will teach the basics of Microsoft's dialect of the standard SQL language, Transact-SQL.

$1190

Contact the Institutes

Fill this form

Advertisement

Web Age Solutions team 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. Audience Profile This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries.

 

Skills Gained

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 return data values

  • Create groups of data and aggregate the results

  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

 

 

Who Can Benefit?

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator, or a database developer. It can also be useful for others peripherally involved with data or wanting to learn more about working with data, such as solution architects, students, and technology managers.

 

Outline for Querying Data with Microsoft Transact-SQL Training

Outline

  • Introduction to Transact-SQL

  • Sort and filter results in T-SQL

  • Combine multiple tables with JOINs in T-SQL

  • Write Subqueries in T-SQL

  • Use built-in functions and GROUP BY in Transact-SQL

  • Modify data with T-SQL

  • Toronto Branch

    220 Yonge Street Suite 218B, Toronto

Check out more SQL Server courses in Canada

Camosun Coastal Centre Logo

Database 12c Administration Workshop

Database 12c Administration course is offered by Camosun Coastal Centre. The Camosun Coastal Centre (CCC) brokers training to enhance workforce development in the shipbuilding industry.

by Camosun Coastal Centre [Claim Listing ]
Canadian College of Business, Science and Technology (CCBST) Logo

Oracle Certified Professional

The Oracle Certified Professional Java Programmer Certificate Course is a great starting point for both new and experienced programmers interested in learning the Java programming language, the foundation for most networked applications.

by Canadian College of Business, Science and Technology (CCBST) [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 ]
The Data Steps Logo

SQL Programming

SQL is the most sought-after skill for data analysis roles in all companies. So, whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need to know.

by The Data Steps [Claim Listing ]
Roicians Logo

SQL Training

This course is aimed at providing practical, in-depth SQL training. This training is meant to provide knowledge from the basic to the advanced level. SQL Training is for all the databases, i.e Oracle, SQL Server, etc. We prepare students for real-time scenarios.

by Roicians [Claim Listing ]

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