Programming Microsoft. SQL Server 2022 aggregate functions.

Format:

Video

Contributor:

Bobak, Angelo R., instructor.

Apress (Firm), publisher.

Language:

English

Subjects (All):

Client/server computing.

Database management.

SQL server.

Physical Description:

1 online resource (1 video file (1 hr., 16 min.)) : sound, color.

Edition:

[First edition].

Place of Publication:

[New York, New York] : Apress, [2025]

Summary:

This video, the first of a four part series, explains a category of data analysis functions that are provided by Microsoft SQL Server 2022 (and earlier) called aggregate functions. The student will learn what each function does, how to create a complex query using the function and how to use the data results in a Microsoft Excel spreadsheet to create graphs and reports for further analysis. This video concentrates on the aggregate window functions. It is a follow up to the author's Apress book, The SQL Server BI Toolkit, and can be used with the book or stand alone to achieve the learning goals. The objective of each section is to introduce the SQL Server window function, learn how to use it in a query using SQL Server Management Studio and generate results that can be copied to a Microsoft Excel spreadsheet for further analysis.

Notes:

OCLC-licensed vendor bibliographic record.

OCLC:

1491236609

Publisher Number:

979868808623