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