70-461 Training

Free SQL Server Training Videos

by SteveStedman
September 24, 2015September 23, 2015
70-461 Training, Classes

Over the last year, I have published many videos to YouTube with Free SQL Server Training. You can find these on my YouTube Channel at… Read More »Free SQL Server Training Videos

TSQL Training: JOINs

by SteveStedman
March 26, 2015September 2, 2021
70-461 Training, JOIN Types, TSQL

>>> Try our JOIN Types Course Today! Today’s training will be on JOINs. Here is the outline for the training. Basic SELECT INNER JOIN LEFT… Read More »TSQL Training: JOINs

Using The TSQL EOMONTH Function

by SteveStedman
March 26, 2015March 22, 2015
70-461 Training, TSQL 2012

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL EOMONTH Function

Using The TSQL DATEADD Function

by SteveStedman
March 25, 2015July 17, 2015
70-461 Training, TSQL

Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL DATEADD Function

Using The TSQL DATEDIFF Function

by SteveStedman
March 24, 2015November 26, 2024
70-461 Training, TSQL

Understanding the transact sql (T-SQL) DATEDIFF Function: A Comprehensive Guide In this video, we dive deep into the DATEDIFF function in T-SQL, a powerful and… Read More »Using The TSQL DATEDIFF Function

Using The TSQL DATEPART Function

by SteveStedman
March 23, 2015March 22, 2015
70-461 Training, TSQL

Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL DATEPART Function

Using the TSQL GetDate Function

by SteveStedman
March 22, 2015
70-461 Training, TSQL

Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally… Read More »Using the TSQL GetDate Function

Using the TSQL CASE Statement

by SteveStedman
March 22, 2015March 20, 2015
70-461 Training

Here is a quick video tutorial on how to use the T-SQL CASE function on SQL Server 2012, SQL Server 2014 0r newer. This was originally… Read More »Using the TSQL CASE Statement

TSQL OUTER JOINS (LEFT and RIGHT)

by SteveStedman
March 21, 2015September 2, 2021
70-461 Training

>>> Try our JOIN Types Course Today! After learning the INNER JOIN when querying SQL Server, the LEFT OUTER JOIN and RIGHT OUTER JOIN are often… Read More »TSQL OUTER JOINS (LEFT and RIGHT)

Using the TSQL CHOOSE Function

by SteveStedman
March 21, 2015March 20, 2015
70-461 Training

Here is a short video tutorial that shows how to use the CHOOSE function in T-SQL on SQL Server 2012, SQL Server 2014 or Newer. This… Read More »Using the TSQL CHOOSE Function