Weekly SQL Training – MERGE Statement and Recursive Queries

The free SQL Server Queries weekly training is being presented by Emergency Reporting. The training is being presented by Aaron Buma and myself. This week we are covering two topics, first the MERGE statement will be covered by Aaron, then I will present on Recursive Queries. There MERGE statement is one of those that I was not familiar enough with when I took the certification exam 2 years ago. The recursive queries section was touched on a bit during the CTE presentation, here I will go into much more detail with additional samples.

You can download the slides and TSQL sample code here:
MERGE-Statement-and-Recursive-Queries.zip

Here are the slides, located at slideshare:

And here is the video on my YouTube Channel:

 

This is a live broadcast that was available on Google On Air Broadcasts.

See Also:

Training Employees

Training Employees

A great conversation, not original, but something found on LinkedIn

For employee training, see our Free SQL Query Training program.

 

Using a Common Table Expression Instead of a Derived Table

Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the recording comes from my Free SQL Query Training course.

 

 

Other CTE Related Posts:

Next Week’s Free SQL Training: MERGE Statement and Recursive Queries

Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training provided by Emergency Reporting, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL Developers for the 70-461 certification exam.

Here is the basic abstract for the presentation:

This will be a free training provided by Steve Stedman and Aaron Buma at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be two topics, first on the MERGE Statement, then Recursive Queries.  This is provided free of charge to give back to the SQL community.

You can watch via Google On Air Hangouts at this link: https://plus.google.com/u/0/events/cma01e76ll4kfsaopdj6jue1gno

A week ago we touched slightly on recursive queries in the CTE presentation, in this session I will go into much more detail on the recursive queries.

 

For more information:

 

What is a Common Table Expression

I just a added a video to YouTube titled “What is a Common Table Expression”.  This video covers the extreme basics of what a CTE is on Microsoft SQL Server, and how to write that CTE in TSQL. Here is the video:


It’s a very short video with the basics of what a CTE is.  Take a look.

 

Other CTE Related Posts:

Weekly SQL Training – OUTPUT Clause and Derived Tables

The free SQL Server Queries weekly training is being presented by Emergency Reporting. The training is being presented by Aaron Buma and myself.

The name of the presentation started out as “OUTPUT Clause and Derived Tables“, however it evolved into “OUTPUT Clause
Correlated Subqueries and Subquery Extensions
” as we got further into it. Last week we covered some of the basics of Derived Tables or Subqueries, today we will go into more detail on Correlated Subqueries and Subquery Extensions.

Here is the presentation at SlideShare:

 

You can download the slides and sample code here:

OUTPUT Clause and Derived Tables.zip

The live broadcast is available through Google On Air Broadcasts at this link: https://plus.google.com/events/ctdmm6a8fe2hoc9sm5duosggn4o