Advanced CTEs Slides and Sample Queries

My second presentation at SQL Saturday in Portland Oregon is Advanced Common Table Expressions.

Here is the outline for the session.

1. Hierarchical Recursive CTEs
2. Manipulating Data
3. Common Use Cases
4. CTE Performance Considerations

Download the presentation and samples here:  Advanced CTEs.zip

See Also:

Introduction to CTEs presentation

Introduction to CTEs Slides and Sample Queries

Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session:

Introduction

Here is the abstract:

Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. The class is designed for people who haven’t used CTE’s before, or for those who want to learn the basics of CTEs including data paging. This session pairs well with the Advanced Common Table Expressions session.

This session will include the following topics:

  • Introduction to Memory Tables and CTEs
  • Simple CTE
  • CTE Instead of a Derived Table
  • Multiple CTE in a Query
  • Data Paging
  • CTEs in Stored Procedures, Functions and Views
  • Introduction To Recursive CTEs

At 10:45 I will be giving the Advanced Common Table Expressions Session.

Download the presentation here:  Introduction to CTEs.zip

Related Posts:

SQL Saturday #265 in Portland Oregon

I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013.

This will be my second time attending SQL Saturday in Portland, and it is looking to be a great event. There are some great speakers on the line up that I am looking forward to learning from.

I will be presenting 2 sessions on Common Table Expressions.

Common Table Expressions – Introduction

Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. The class is designed for people who haven’t used CTE’s before, or for those who want to learn the basics of CTEs including data paging. This session pairs well with the Advanced Common Table Expressions

Common Table Expressions – Advanced

You have been introduced to Common Table Expression, you understand the ;WITH syntax, but you want to know more. Learn how to recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE and DELETE data from CTEs. Some of the common use cases for CTEs will be covered including finding holes in patterns, finding and removing duplicate data, string parsing, and more. See how CTEs compare to SQL Server 2012 offset and fetch paging techniques. Get an in depth understanding of the performance behind a common table expression. Understand when the CTE is the right solution, and the wrong solution to use. Finally we will take a look at some classic recursive algorithms and how they can be implemented with CTEs. This session pairs well with the Introduction to Common Table Expressions session.

Advanced CTEs Slides and Samples

Today I presented on Advanced CTEs at SQL Saturday Denver.
sqlsat190_speaking

Here are my slides and sample code for download: Advanced CTEs Denver

Thanks to everyone who attended, I hope you enjoyed the presentation.

Don’t forget to try out the Database Health Reports.  Here is what some people are saying about it:  Raving Fans

In Denver for SQL Saturday

I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions.  This presentation should be a lot of fun.  I will be covering all the advanced and fun CTE features that I haven’t had time to fit into my introduction to CTE session in the past.

sqlsat190_speaking

Here is the outline of the session:

1.Recursive CTEs.
2.Hierarchical CTEs.
3.Manipulating Data.
4.Common Use Cases.
5.CTE Performance Considerations.
I will also be giving away a couple signed copies of my book on Common Table Expressions book.
Paperback Kindle
See you there!

I’m Speaking at SQL Saturday #190 in Denver

sqlsat190_speaking

 

One of my sessions was accepted for SQL Saturday #190 in Denver this year.

Please come see my CTE presentation.

Common Table Expressions – Introduction

Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. The class is designed for people who haven’t used CTE’s before, or for those who want to learn the basics of CTEs including data paging. This session pairs well with the Advanced Common Table Expressions session.