Course Description

How do you transform complex tables into clean, analysis-ready datasets? This training course teaches you how to write analytical queries using Transact-SQL (T-SQL) for business intelligence (BI) workflows. You’ll learn to manipulate columns, combine tables, aggregate results, and encapsulate logic in reusable views and procedures. With a focus on BI scenarios, the course prepares you to deliver clean, structured datasets to tools like Power BI, Excel, SSRS, and RStudio.

What you will learn

Module 1: Introduction to T-SQL for Business Intelligence SQL programming approaches: transactional vs analytical The database engine and SSMS Introduction to SELECT queries Using the CarDeal sample database Lab: Intro to T-SQL for BI Module 2: SELECT Expressions, WHERE, and ORDER BY Column expressions, data types, and built-in functions Column/table aliases and conversions Using WHERE and ORDER BY clauses Lab: Write filtering and sorting queries Module 3: JOIN Operators and Combining Tables Primary/foreign key relationships CROSS JOIN, INNER JOIN, OUTER JOIN variations Multi-table joins and nested joins Combining JOINs with WHERE and ORDER BY Lab: Write multi-table SELECT queries Module 4: Aggregating with GROUP BY Defining aggregation level and granularity COUNT, SUM, AVG, and other aggregate functions GROUP BY and HAVING usage Lab: Write grouped and aggregated queries Module 5: Subqueries, Derived Tables, and CTEs Writing correlated and non-correlated subqueries Using derived tables in FROM clauses Structuring logic with common table expressions (CTEs) Lab: Create reusable query logic Module 6: Encapsulating Data Retrieval Logic Creating and using views Table-valued functions and stored procedures Creating read-access objects for analytical clients Lab: Build encapsulated SQL logic Module 7: Getting Your Dataset to the Client Connecting SQL Server to Excel, Power BI, and RStudio Exporting with SSMS, bcp utility, and Import/Export Wizard Best practices for client-ready data delivery Lab: Export datasets and connect to BI tools

Course: 55232 Writing Analytical Queries for Business Intelligence

$1,895.00
View All Dates

Looking for Group eLearning Options?

Get your team access to 4,000+ top courses anytime, anywhere.

Request On-Site Training

Upcoming Dates

$1,895.00
$1,895.00
$1,895.00

Course Dates

Location Date & Time Duration Course Type
  • CL Classroom Live - Traditional live classroom with in-person instructor.
  • CV Classroom Virtual - Attend this live instructor-led event remotely from the indicated tech facility.
  • VL Virtual Live - Attend this live instructor-led event remotely from anywhere.
Price  
Show Events

Cancelation Policy

If you cannot attend an event, you may send someone else in your place. If that isn’t an option for you, cancellations received up to five working days before the event are refundable, minus a registration service charge ($10 for one-day events; $25 for multiple-day events). After that, cancellations are subject to the entire seminar fee, which you may apply toward a future seminar. Please note that if you don’t cancel and don’t attend, you are still responsible for payment.