Training videos for learning SELECTING DATA IN SQL

Selecting data in SQL - 12 videos

SQL Queries Part 1 - Writing basic queries

Posted by Andrew Gould on 02 March 2012

Learn how to write basic queries in Microsoft SQL Server. This video teaches you the absolute basics of the SELECT and FROM statements using SQL Server Management Studio, including how to use aliases to refer to fields.

SQL Queries Part 2 - Sorting queries in SQL

Posted by Andrew Gould on 02 March 2012

Learn how to sort the results of queries in Microsoft SQL Server. This video teaches you how to use the ORDER BY clause to change the order of your query results, including how to sort by multiple fields and how to select the top 10 items in a list.

SQL Queries Part 3 - Using Criteria in Queries

Posted by Andrew Gould on 30 April 2012

Learn how to add criteria to queries in Microsoft SQL Server. This video teaches you how to use the WHERE clause to affect the number of records returned by a query, including how to add criteria to columns containing numbers, text and dates.

SQL Queries Part 4 - Creating Calculations in Queries

Posted by Andrew Gould on 02 May 2012

Learn how to use calculations in queries in Microsoft SQL Server. This video teaches you how to create basic calculated columns using simple operators such as add, subtract, multiply and divide. You'll also see how to use calculated columns to sort the results of a query, and how to add criteria to calculated columns.

SQL Queries Part 5 - Using CASE Statements

Posted by Andrew Gould on 04 May 2012

Learn how to use CASE statements in queries in Microsoft SQL Server. This video teaches you how to test conditions using the CASE statement and provide different answers based on whether the conditions are met.

SQL Queries Part 7 - Using Functions in Queries

Posted by Andrew Gould on 30 May 2012

Learn the basics of using functions in Microsoft SQL Server queries. This video teaches you how to use functions to create calculated columns in a query, including where to find a list of available functions, how to work out which parameters you need to fill in using the help system, and how to combine functions in more elaborate calculations.

SQL Queries Part 8 - Calculations with Text

Posted by Andrew Gould on 21 June 2012

Learn how to perform calculations with text in Microsoft SQL Server queries. This video teaches you how to create calculated columns in a query involving text, including how to concatenate separate pieces of text into longer strings and how to use functions to split a longer piece of text into separate parts.

SQL Queries Part 9 - Calculations with Dates

Posted by Andrew Gould on 21 June 2012

Learn how to perform calculations with dates in Microsoft SQL Server queries. This video teaches you how to create calculated columns in a query involving dates, including how to format dates using the CONVERT function, how to use the DATENAME function to create your own custom date formats, and how to work out the amount of time that has passed between two dates. The final part of the video teaches you how to calculate age in years accurately in SQL Server.

SQL Queries Part 6 - Using Joins in Queries

Posted by Andrew Gould on 23 May 2012

Learn how to use joins in Microsoft SQL Server queries. This video teaches you how to include multiple tables in a query using INNER joins, how to find unmatched records using LEFT and RIGHT OUTER joins, and how to use FULL OUTER joins.

SQL Queries Part 10 - Grouping and Aggregating Data

Posted by Andrew Gould on 27 June 2012

Learn how to group data and calculate aggregate statistics in Microsoft SQL Server queries. This video teaches you how to use the GROUP BY clause in a query to organise your data into groups, including how to group by multiple columns in the same query. We'll also show you how to make use of the aggregate functions to calculate values such as the total and average of a range of numbers, including how to apply totals and subtotals using the ROLLUP keyword.

SQL Queries Part 11 - Subqueries

Posted by Andrew Gould on 20 August 2012

The idea of a subquery is pretty simple: it's just one query nested inside another. If that doesn't sound particularly useful then you should watch this video to find out why it is! You'll learn how to place a subquery in a SELECT list or a WHERE clause, how to add criteria to a subquery, and how to handle subqueries which return multiple values.

SQL Queries Part 12 - Correlated Subqueries

Posted by Andrew Gould on 31 October 2012

A correlated subquery is a subquery which depends on an outer query for its values. If that doesn't make much sense, this video attempts to explain exactly what that means. You'll see how to build simple correlated subqueries, including why it's necessary to use table aliases, along with an explanation of what happens when you execute the query.

This page has 0 threads Add post