Blog

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 or omissions with this page either through email or via the contact page)

AdventureWorks – Installation

Official AdventureWorks Documentation

AdventureWorks is a sample database provided by Microsoft. It’s really useful to have a database to play with and this one is great to have on an instance as it comes preloaded with test data to experiment with.

This video will show you how to install the sample database via the Database restoration process, and get it ready for you to work with.

Topics covered include

  • Downloading The Sample Database Backup
  • Restoring Process
    • General Page
    • Files Page
    • Options Page
  • Perform The Database Restore

(Please report any errors or omissions with this page either through email or via the contact page)

SQL Server Developer Edition – Installation

SQL Editions and Supported Features Documentation

SQL Server Developer Edition is an edition of SQL Server specifically for developers to develop and test against. It’s a fully functional, free product that’s ideal for installation to our own hardware so we can create our own databases.

This video will show you how to install Developer Edition and get it ready for you to work with.

Topics covered include

  • Overview
  • Downloading The Installer
  • Installation Types
  • Post Installation Information
  • Whats Been Installed
  • Connection Testing

(Please report any errors or omissions with this page either through email or via the contact page)

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 this page either through email or via the contact page)

SELECT – The Select Clause

Official SELECT Clause Documentation

In this, the second of our series of videos looking at the Transact-SQL SELECT Statement, we’ll take a look at the SELECT clause.

Using examples we’ll get an understanding as to what we can achieve with the clause – topics covered include

  • Retrieving Data from defined ColumnNames, Functions and Calculations
  • ALL | DISTINCT
  • $Identity & $RowGUID
  • TOP (exp) | PERCENT | WITH TIES

(Please report any errors or omissions with this page either through email or via the contact page)