Wise Owl - SQL training videos (page 1 of 2)

Showing videos 1-20 (out of 30)

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 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 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 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 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 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.

SQL Programming Part 1 - Stored Procedure Basics

Posted by Andrew Gould on 19 November 2012

If you ever find yourself writing the same SQL query over and over again, a Stored Procedure could be just the time-saving tool you're looking for. This video introduces you to the concept of stored procedures and will show you how to create, execute and modify these useful elements of SQL Server.

SQL Programming Part 2 - Stored Procedure Parameters

Posted by Andrew Gould on 20 November 2012

Stored Procedures are extremely useful tools in SQL Server, and they become even more powerful when you use parameters to pass information to them. This video teaches you how to define a list of parameters for a stored procedure and how to call a parameterised procedure and pass information to it. You'll also learn how to create optional parameters with default values, how to handle NULLs passed to a procedure and, finally, how to use your procedure in other applications such as Reporting Services.

SQL Programming Part 3 - Variables in SQL

Posted by Andrew Gould on 21 November 2012

Using variables allows you to give your SQL procedures a memory. You can store a value in a variable and then retrieve and reuse that value at any point later in the same procedure. This video teaches you how to declare variables, assign values to them and make use of those values in a query. You'll also see how to store the result of a SELECT statement in a variable, as well as how to accumulate the value of a variable. You'll see a couple of methods of displaying the value stored in a variable and we'll end with a quick overview of the global variables in SQL Server.

SQL Programming Part 4 - Output Parameters and Return Values

Posted by Andrew Gould on 28 November 2012

Output parameters and return values are two methods in SQL for getting information out of a stored procedure. This video teaches you how to use both methods, including how to define output parameters and set their values within a procedure, how to add a return statement to a stored procedure, and how to capture the output of a procedure when you execute it.

SQL Programming Part 5 - IF Statements in SQL

Posted by Andrew Gould on 03 December 2012

IF statements in SQL allow you to check if a condition has been met and, if so, to perform a sequence of actions. This video teaches you everything from the basic syntax of IF statements, including how to use the ELSE clause and perform multiple actions using a BEGIN and END block. We'll also teach you how to nest your IF statements, including a few useful tips on how to make your nested IFs readable!

SQL Programming Part 6 - WHILE Loops

Posted by Andrew Gould on 05 December 2012

In SQL Server there is only one type of loop: a WHILE loop. This video teaches you how to use them, from the basic syntax of the WHILE statement, through how to use a SELECT statement within a loop. We'll also cover how to use the BREAK command to exit from a loop, what to do when you inevitably find yourself in an endless loop and, finally, a quick introduction to using loops with cursors.

SQL Programming Part 7 - User Defined Functions

Posted by Andrew Gould on 31 January 2013

If you have a calculation that you frequently use in SQL queries you're probably bored of writing out the same code time after time. Why not try creating a user-defined function to save you the hassle! This video teaches you how to define your own custom functions, including how to use input parameters, how to alter a function after you've created it, and even how to use fancy programming techniques such as variables and IF statements to help structure complex sequences of calculations.

SQL Programming Part 8 - Temporary Tables

Posted by Andrew Gould on 06 February 2013

There are many techniques in SQL Server for working with temporary data: this video deals with Temporary Tables (you know, the ones that begin with a #). You'll learn how to create and remove temporary tables, where they live during their short lifespans, how to extend their scope by using global temp tables, and how you can use temporary tables within stored procedures.

This page has 0 threads Add post