Month: November 2020

AVG Function

Official Average Function Documentation The AVG function is an aggregate function which operates on a group of values and returns the average of that group. This video will take you from the simplest example though to partitioning the data. Topics covered include Definition Simplest Form Grouped Example ALL | Distinct Partitioning (Please report any errors…

Read the full article

SSMS – Installation

Official SSMS Documentation SQL Server Management Studio (SSMS) is the tool we use to manage, maintain and query against a SQL Server Instance. This video will guide you through the SSMS installation process. Topics covered include What is SSMS Downloading SSMS Installation What’s Been Installed SSMS First Run (Please report any errors or omissions with…

Read the full article