70-461 Training

Using the TSQL COALESCE Function

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

Here is a short video tutorial that shows how to use the COALESCE function in T-SQL on SQL Server. This was originally part of my… Read More »Using the TSQL COALESCE Function

Using the TSQL IIF Function

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

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

TSQL INNER JOIN

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

>>> Try our JOIN Types Course Today! The INNER JOIN has to be the most common JOIN type in SQL Server. This is where we… Read More »TSQL INNER JOIN

SQL Training – Functions (70-461)

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

In this presentation we will be training on TSQL Functions, there will be three sections. Date and Time Functions Logical Functions User Defined Functions Here… Read More »SQL Training – Functions (70-461)

Simple Introduction to TSQL Cursors

by SteveStedman
March 13, 2015December 13, 2022
70-461 Training

A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a… Read More »Simple Introduction to TSQL Cursors

Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)

by SteveStedman
March 13, 2015July 11, 2015
70-461 Training

On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461… Read More »Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)

Today’s Live Training: Using Cursors and TSQL String Functions

by SteveStedman
March 12, 2015March 12, 2015
70-461 Training

Here is the outline: Using Cursors Using String Functions Here is the link to the Google On Air Broadcast where you can watch for free.… Read More »Today’s Live Training: Using Cursors and TSQL String Functions

Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD

by SteveStedman
March 11, 2015December 3, 2024
70-461 Training, TSQL

Here is our simple cursor example showing both FAST_FORWARD and FORWARD_ONLY cursors. A FAST_FORWARD cursor in SQL Server is a type of forward-only, read-only cursor… Read More »Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD

TSQL OUTPUT Clause With UPDATE Statements

by SteveStedman
February 18, 2015March 11, 2015
1 Comment
70-461 Training, TSQL

Earlier in the week I added a blog entry on using the OUTPUT Clause on INSERT Statements, today I will expand it by exploring the use of… Read More »TSQL OUTPUT Clause With UPDATE Statements

TSQL Queries – Using NTILE

by SteveStedman
February 7, 2015February 6, 2015
70-461 Training

NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare… Read More »TSQL Queries – Using NTILE