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

Sanrus Training Centre Logo

SQL

SQL is an ANSI standard computer language for dealing with relational databases. When IBM first developed the language, it was called SEQUEL, which later got abbreviated into SQL. SEQUEL was an abbreviation for Structured English Query Language.

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
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 ]
Justwin It Solutions Logo

Database Administrator

Learn how you can get into the database administrator profession with Justwin IT Solutions. Our database administrator course provides students with the skills and training required to succeed in today’s rapidly growing big data market.

by Justwin It Solutions [Claim Listing ]
Eccentrix Logo

Administering Microsoft Azure SQL Solutions (DP300)

This Microsoft certified course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings.

by Eccentrix [Claim Listing ]

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