More results...

Generic filters
Filter by Brands/Technologies

55232 Writing Analytical Queries for Business Intelligence

On‑Demand: $595 | Instructor‑Led: $1,895 | Duration: 3 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
3/18/2026 3/20/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$1,895
7/8/2026 7/10/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$1,895
START DATE : 3/18/2026
END DATE : 3/20/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $1,895
START DATE : 7/8/2026
END DATE : 7/10/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $1,895

Course Highlights

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

55232 Writing Analytical Queries for Business Intelligence Course Outline

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

Who Should Attend this Course?

This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools.

PREREQUISITES

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.

1 – INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE

  • Two Approaches to SQL Programming
  • TSQL Data Retrieval in an Analytics / Business Intelligence Environment
  • The Database Engine
  • SQL Server Management Studio and the CarDeal Sample Database
  • Identifying Variables in Tables
  • SQL is a Declarative Language
  • Introduction to the SELECT Query
  • Lab 1: Introduction to TSQL for Business Intelligence

2 – TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY

  • Turning Columns into Variables for Analysis
  • Column Expressions, Data Types, and Built-in Functions
  • Column aliases
  • Data type conversions
  • Built-in Scalar Functions
  • Table Aliases
  • The WHERE clause
  • ORDER BY
  • Lab 1: Write queries

3 – COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS

  • Primary Keys, Foreign Keys, and Joins
  • Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product
  • Understanding Joins, Part 2: The INNER JOIN
  • Understanding Joins, Part 3: The OUTER JOINS
  • Understanding Joins, Part 4: Joining more than two tables
  • Understanding Joins, Part 5: Combining INNER and OUTER JOINs
  • Combining JOIN Operations with WHERE and ORDER BY
  • Lab 1: Write SELECT queries

4 – CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY

  • Identifying required aggregation level and granularity
  • Aggregate Functions
  • GROUP BY
  • HAVING
  • Order of operations in SELECT queries
  • Lab 1: Write queries

5 – SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS

  • Non-correlated and correlated subqueries
  • Derived tables
  • Common table expressions
  • Lab 1: Write queries

6 – ENCAPSULATING DATA RETRIEVAL LOGIC

  • Views
  • Table-valued functions
  • Stored procedures
  • Creating objects for read-access users
  • Creating database accounts for analytical client tools
  • Lab 1: Encapsulating Data Retrieval Logic

7 – GETTING YOUR DATASET TO THE CLIENT

  • Connecting to SQL Server and Submitting Queries from Client Tools
  • Connecting and running SELECT queries from:
  • Excel
  • PowerBI
  • RStudio
  • Exporting datasets to files using
  • Results pane from SSMS
  • The bcp utility
  • The Import/Export Wizard
  • Lab 1: Getting Your Dataset to the Client

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