This page has 0 threads | Add post

Finding our videos useful? Please consider helping us to share more!

Training videos for learning SELECTING DATA IN SQL

We have 12 Selecting data in SQL videos listed below.

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

You might also like to consider booking a place on one of our online or classroom SQL courses, where you could meet the owls behind the videos!

This page has 0 threads

Add a new post

VIDEOS BY CATEGORY

SQL CATEGORIES

SELECTING DATA IN SQL VIDEOS

VIDEOS BY AUTHOR

Training videos for learning SELECTING DATA IN SQL

SQL Queries Part 1 - Writing basic queries

SQL Queries Part 2 - Sorting queries in SQL

SQL Queries Part 3 - Using Criteria in Queries

SQL Queries Part 4 - Creating Calculations in Queries

SQL Queries Part 5 - Using CASE Statements

SQL Queries Part 7 - Using Functions in Queries

SQL Queries Part 8 - Calculations with Text

SQL Queries Part 9 - Calculations with Dates

SQL Queries Part 6 - Using Joins in Queries

SQL Queries Part 10 - Grouping and Aggregating Data

SQL Queries Part 11 - Subqueries

SQL Queries Part 12 - Correlated Subqueries

Head office

London

Manchester