SQL video tutorials

As well as a series of 30 or so videos showing you how to program in SQL (from writing simple queries through to creating complicated stored procedures), we've also got videos on how to install and use SQL Server 2016.

Category Description Videos
Selecting data in SQL Basic SQL teaching (roughly equivalent to the topics on our Introduction to SQL course). 12
Advanced SQL (programming) Creating stored procedures and user-defined functions, using variables, working with temporary tables and table variables, and all aspects of SQL programming (roughly equivalent to the contents of our Advanced SQL course). 18
SQL Server 2016 Videos on how to perform some useful system maintenance and admin tasks for SQL Server 2016. 9
SQL Server 2017 Videos on how to get started with SQL Server 2017 so that you can follow along with some of our other video series. 3

Just click on any of the links above to see a complete listing for that category of SQL videos. If you prefer learning in an interactive way, you can see all of our classroom and online SQL courses here (and get to meet the owls behind the videos!).

This page has 1 thread Add post
05 Sep 21 at 01:47

Hello Andrews,

Please I have been following your sql tutorials on YouTube and I appreciate your unique teaching program.

I have a problem and hope you can assist me. Here is my problem;

I have an Event table with these columns;

EventID EventDate            W1      W2      W3     W4    W5    M1    M2    M3    M4     M5

1            20-1-1962              1        2         3          4        5       6       7      8        9       10

2            21-1-1962              3       8          31       40       21    42      25    1        11      5

3            22-1-1962             14      21        41       56       1      42      32    31      5       67

 

Problem: 1. Where W1=1 in an Event, Select the next one event and previous one event. Event to select could be anything 2,3,4 or any specified envent

that is if a column in an event contain a specified number, select the previous event and the next specified event.

Problem 2. How do I iterate through the entire database and select these events and have it stored as a procedure?

Isaac