More results...

Generic filters
Filter by Brands/Technologies

55366 Querying Data with Transact-SQL

On‑Demand: $595 | Instructor‑Led: $2,995 | Duration: 5 Days

Upgrade your tech skills with this , training course from TechSherpas 365!

Select a Learning Method Below

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
4/6/2026 4/10/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$2,995
START DATE : 4/6/2026
END DATE : 4/10/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $2,995

Course Highlights

LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

55366 Querying Data with Transact-SQL Course Outline

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.

Who Should Attend this Course?

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.

PREREQUISITES
  • Basic understanding of relational databases.
  • Basic Windows knowledge.

Module 1: Introduction to Transact-SQL

  • What is Transact-SQL
  • The SELECT statement
  • The WHERE clause
  • Sorting results
  • Calculations
  • CASE expressions

Module 2: Joining tables with Transact-SQL

  • The JOIN clause
  • Inner joins
  • Outer joins
  • Self joins and cross joins

Module 3: Filtering and sorting results

  • Implement the ORDER BY clause
  • Filter data with the WHERE clause
  • Limit the number of rows returned by a query
  • Implement NULL logic

Module 4: SQL Server data types

  • Understand data types
  • Implement string data types
  • Implement temporal data types

Module 5: Inserting, updating and deleting data

  • Insert new records
  • Update existing records
  • Delete data

Module 6: Using SQL Server functions with Transact-SQL

  • Understand function types in SQL Server
  • Convert data using functions
  • Implement logical functions
  • Work with NULL data using functions

Module 7: Aggregating data with Transact-SQL

  • Implement aggregation in SQL Server
  • Group records in SQL Server
  • Filter aggregated data

Module 8: Implement subqueries with Transact-SQL

  • Implement scalar and multi-valued sub-queries
  • Implement correlated subqueries
  • Implement existence checks with subqueries

Module 9: Create queries that use table expressions

  • Create views
  • Create table-valued functions
  • Implement derived tables
  • Implement common table expressions

Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data

  • Write queries with the UNION operator
  • Write queries with the INTERSECT and EXCEPT operators
  • Write queries with the APPLY operator

Module 11: Implement window functions in queries

  • Understand window functions
  • Impement window functions

Module 12: Use PIVOT and grouping sets in queries

  • Implement PIVOT in queries
  • Implement grouping sets in queries

Module 13: Use stored procedures in queries

  • Query data with stored procedures
  • Interact with stored procedures using input and output parameters
  • Write simple stored procedures
  • Pass dynamic SQL to SQL Server

Module 14: Implement programming features in Transact-SQL

  • Understand T-SQL programming elements
  • Implement loops and conditions in T-SQL queries

Module 15: Add error handling to queries

  • Understand SQL Server error handling
  • Implemet structured exception handling

Module 16: Use transactions in queries

  • Understand database transactions
  • Implement transactions in T-SQL

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Market Intelligence Analyst

Demographer

Education Research Analyst

Mathematical Statistician

Psychometric Consultant

Quantitative Methodologist

Explore Related Training Courses

Related products

  • Data & Analytics

    PL-900T00 Microsoft Power Platform Fundamentals
    Microsoft Technical
    Beginner
    Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.
    1 Day(s)
    $295 - $1,295
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Business Intelligence

    Power BI for Data-driven Decision Makers
    Microsoft Technical
    Intermediate
    As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and…
    1 Day(s)
    $395
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    SQL Querying Fundamentals – Part 1
    Microsoft Technical
    Beginner
    In this course, students will compose SQL queries to retrieve desired information from a database.
    1 Day(s)
    $695
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    SQL Querying Fundamentals – Part 2
    Microsoft Technical
    Intermediate
    In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry…
    1 Day(s)
    $695
    Virtual Classroom
    Live, Instructor-Led (ILT)

What Our Students Are Saying

IT Certification Training Course Reviews