55232 Writing Analytical Queries for Business Intelligence

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

Course Details

Price:

$1,895.00

Days:

Location:

Course Overview

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code.

Setting learning of information examination and business knowledge situations. For instance, a comprehension of a business-related business knowledge venture or need. Fundamental information of the Windows working framework and its center usefulness, including document framework route. Essential comprehension of the reason for social database administration frameworks, for example, SQL Server.

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

Class Dates & Times


01/06/2027 - 01/08/2027 Virtual 09:00:00 to 17:00:00 EST Enroll Now $1,895.00
07/08/2026 - 07/10/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $1,895.00
09/16/2026 - 09/18/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $1,895.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →