HomeAboutTraining CoursesFAQ
العربيةmohd@sbeeh.com+962 77 984 65 64
SBEEH Software Academy

Instructor-led IT training delivered by Microsoft Certified Trainers (MCT) — in Amman, Jordan, and across the GCC.

Explore

  • About Us
  • IT Training Courses
  • Verify a Certificate
  • FAQ

Get in Touch

  • +962-779846564
  • mohd@sbeeh.com
  • Amman, Jordan

SBEEH Software delivers software development services, advanced technologies implementation, business process automation, IT consulting, and professional IT training led by Microsoft Certified Trainers (MCT) for organizations across Jordan, Saudi Arabia, UAE, Qatar, Kuwait, Bahrain & Oman.

© SBEEH Software. All rights reserved. 2026.

Back to Training Courses
Querying and Managing Data with Transact-SQL
DatabaseBeginnerFace to Face / Online

Querying and Managing Data with Transact-SQL

Querying and Managing Data with Transact-SQL is a beginner Database course delivered in person and online by SBEEH Software Academy in Amman, Jordan.

2 Days (16 Hours)

Last updated August 16, 2026

This focused 2-day, beginner-level course teaches the T-SQL querying skills needed to work confidently with Microsoft SQL Server data — the essential first step before any deeper database development, administration, business intelligence, or reporting training. The course is deliberately scoped to querying and managing data (not schema design or programming objects), making it the fastest path to real, useful SQL skills for people who need to extract and work with data, not build database applications.

Participants learn to retrieve data with SELECT statements, filter and sort results, join data across multiple related tables, group and summarize data with aggregate functions, and safely insert, update, and delete data — the core operations behind virtually every report, dashboard, or data extract an organization produces.

This course is designed for business analysts, report writers, IT support staff, and anyone who needs to query a SQL Server database directly rather than relying entirely on someone else to write reports for them. It is also the recommended starting point before the SQL Server Database Development, Power BI, or SSIS courses for participants with no prior SQL background.
Official reference: Microsoft Learn: SQL Server documentation

Day 1: Retrieving and Filtering Data

Main Topics:

  • SELECT statement fundamentals
  • Filtering with WHERE
  • Sorting with ORDER BY
  • Working with NULL values

Detailed Subtopics:

  • Selecting and aliasing columns
  • Comparison and logical operators (AND, OR, IN, BETWEEN, LIKE)
  • Handling NULLs correctly with IS NULL / IS NOT NULL
  • TOP and OFFSET/FETCH for limiting results

Hands-On Lab: Write a series of progressively more complex SELECT queries against a sample sales database to answer specific business questions (e.g., top 10 customers by region).

Real-World Scenario: A sales manager keeps emailing ad hoc data requests to IT that could be answered directly with a query instead of a multi-day report request.

Learning Outcome: Participants can independently write correct, filtered, and sorted SELECT queries to answer real business questions.

Day 2: Joining Tables, Aggregating, and Managing Data

Main Topics:

  • Joining multiple tables (INNER, LEFT)
  • GROUP BY and aggregate functions
  • HAVING vs. WHERE
  • INSERT, UPDATE, and DELETE statements

Detailed Subtopics:

  • Understanding table relationships through joins
  • COUNT, SUM, AVG, MIN, MAX
  • Filtering grouped results with HAVING
  • Safely modifying data with WHERE clauses and transactions

Hands-On Lab: Write joined, grouped queries producing a summary report (e.g., total sales by product category and month), then safely insert, update, and delete sample records using transactions.

Real-World Scenario: Finance needs a monthly summary report combining data from separate orders, products, and customers tables, and occasionally needs to correct individual records directly.

Learning Outcome: Participants can join related tables, produce grouped summary reports, and safely modify data without risking unintended changes.

Frequently Asked Questions

Additional Notes


Who Is This For?

This course is for anyone who needs to query and work with SQL Server data directly, regardless of technical background.

  • Business analysts and report writers who need to self-serve data requests
  • IT support and helpdesk staff who query databases as part of troubleshooting
  • Beginners preparing for further SQL Server, Power BI, or SSIS training
  • Non-developer professionals (finance, operations, marketing) who work with company data

Prerequisites

No prior SQL or programming experience is required.

  • No prior SQL or database experience required
  • Basic computer literacy and comfort using Excel-like data concepts is helpful
  • No programming background required
  • SQL Server Management Studio and a sample database provided in the training environment

What certificate do I get after this course?

Upon successful completion of the training, participants will receive an official Certificate of Completion.


Certificate of Completion
Photo Gallery

Moments From This Training

A look at our training sessions — hands-on training sessions with professionals across Jordan and the GCC.

Interested in this training?

Reach out and we'll help you plan the right training for your team.

Back to all courses