Course Name

Querying Data with Microsoft Transact- SQL

  • Code: DP-080
  • Duration: 2 Day(s)
  • Date: 28 Nov, 2024
  • Price: R5, 075.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

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.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended 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

Course Objectives

  • Introduction to Transact-SQL
    • This module provides an introduction to relational databases, the SQL language and Transact-SQL. You’ll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.
  • Sort and filter results in T-SQL
    • Learn how to sort and filter query results.
  • Combine multiple tables with JOINs in T-SQL
    • Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.
  • Write Subqueries in T-SQL
    • Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.
  • Use built-in functions and GROUP BY in Transact-SQL
    • Learn how to use functions in Transact-SQL, and how to group aggregated results.
  • Modify data with T-SQL
    • Learn how to use Transact-SQL to insert, update, and delete data in a database.
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

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.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended 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

Course Objectives

  • Introduction to Transact-SQL
    • This module provides an introduction to relational databases, the SQL language and Transact-SQL. You’ll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.
  • Sort and filter results in T-SQL
    • Learn how to sort and filter query results.
  • Combine multiple tables with JOINs in T-SQL
    • Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.
  • Write Subqueries in T-SQL
    • Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.
  • Use built-in functions and GROUP BY in Transact-SQL
    • Learn how to use functions in Transact-SQL, and how to group aggregated results.
  • Modify data with T-SQL
    • Learn how to use Transact-SQL to insert, update, and delete data in a database.

Course Content

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US