logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Querying Data with Microsoft Transact-SQL (DP-080T00) (replacing 20761)

SS Course: GK821360

Course Overview

TOP

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.

                                                                  

Scheduled Classes

TOP
02/20/25 - GVT - Virtual Classroom - Virtual Instructor-Led
04/10/25 - GVT - Virtual Classroom - Virtual Instructor-Led
06/16/25 - GVT - Virtual Classroom - Virtual Instructor-Led
08/20/25 - GVT - Virtual Classroom - Virtual Instructor-Led

Outline

TOP

Module 1: Get Started Querying with Transact-SQL

  • Introduction to Transact-SQL
  • Introduction to Transact-SQL
  • Combine multiple tables with JOINs in T-SQL
  • Write Subqueries in T-SQL
  • Write Subqueries in T-SQL
  • Modify data with T-SQL

    Prerequisites

    TOP

      Who Should Attend

      TOP

      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.