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 the following link: https://www.youtube.com/steveStedman   Most of the focus has been around training people for the 70-461 exam certification. Full Length Free SQL Server Training Videos Some of these are full length at around an …

Free SQL Server Training Videos Read more »

>>> 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 OUTER JOIN —RIGHT OUTER JOIN —LEFT OUTER JOIN with exclusion —RIGHT OUTER JOIN with exclusion —SEMI JOIN —ANTI SEMI JOIN —CROSS JOIN —FULL OUTER JOIN —FULL OUTER JOIN with exclusion —CROSS APPLY —OUTER APPLY —Multiple …

TSQL Training: JOINs Read more »

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 for the 70-461 certification exam. The EOMONTH function returns the last day of a given month, or a future or past month by using the second parameter of offset. EOMONTH was introduced in SQL Server …

Using The TSQL EOMONTH Function Read more »

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 for the 70-461 certification exam. And here is the sample code to go with the DATEADD video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation

Here is a quick video training on how to use the T-SQL DATEDIFF function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the DATEDIFF video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation

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 for the 70-461 certification exam. And here is the sample code to go with the video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation

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 part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes with the video. See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 …

Using the TSQL GetDate Function Read more »

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 part of my free SQL query training for the 70-461 certification exam. Here is the sample or demo code from the video tutorial. More Info: Additional Training on my YouTube Channel Free SQL Query Training …

Using the TSQL CASE Statement Read more »

>>> 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 what people attempt to learn next. The reason that I say attempt is that most people don’t get OUTER JOINs right the first time they learn it. This becomes very clear when interviewing developers and …

TSQL OUTER JOINS (LEFT and RIGHT) Read more »

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 was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes along with the CHOOSE function training. This sample code has been tested and confirmed …

Using the TSQL CHOOSE Function Read more »