VIDEOS BY CATEGORY▼
- VIDEOS HOME PAGE
- .NET (14)
- Business Intelligence (40)
- Integration Services (19)
- Macros and Programming (82)
- Microsoft Excel (69)
- Microsoft Office (91)
- Miscellaneous (1)
- Power BI (35)
- Python (31)
- Report Builder (107)
- Reporting Services (113)
- SQL (42)
- Visual Basic for Applications (215)
- Visual C# (14)
VIDEOS BY AUTHOR▼
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!).
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
Hi Isaac,
You can use the Lag and Lead methods to do this
https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/lead-transact-sql?view=sql-server-ver15
I hope it helps!