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 (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/09/23 - GVT - Virtual Classroom - Virtual Instructor-Led
04/06/23 - GVT - Virtual Classroom - Virtual Instructor-Led
05/04/23 - GVT - Virtual Classroom - Virtual Instructor-Led
07/13/23 - GVT - Virtual Classroom - Virtual Instructor-Led

Outline

TOP

Module 1: Introduction to Transact-SQL

  • Understand what SQL is for
  • Identify database objects in schemas
  • Identify SQL statement types
  • Use the SELECT statement
  • Work with data types
  • Handle NULLs

Module 2: Sort and filter results in T-SQL

  • Sort your results
  • Limit the sorted results
  • Return paged results
  • Remove duplicates
  • Filter data with predicates

Module 3: Combine multiple tables with JOINs in T-SQL

  • Describe join concepts and syntax
  • Write queries that use inner and outer joins
  • Write queries that use cross joins
  • Write queries that use self joins

Module 4: Write Subqueries in T-SQL

  • Understand what subqueries are
  • Use scalar or multi-valued subqueries
  • Use self-contained or correlated subqueries

Module 5: Use built-in functions and GROUP BY in Transact-SQL

  • Categorize built-in functions
  • Use scalar functions
  • Use ranking and rowset functions
  • Use aggregate functions
  • Summarize data with GROUP BY
  • Filter groups with HAVING

Module 6: Modify data with T-SQL

  • Insert data into a table
  • Generate automatic values
  • Update data in a table
  • Delete data from a table
  • Merge data based on multiple tables

    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.