Back-To-School Deals - hours only!Up to 80% off on all courses and bundles.-Close

Description

Common Table Expressions (CTEs), often simply called WITH clauses, are essentially just named subqueries. They are a fairly new feature of T-SQL; with CTEs, you can break a long query into smaller chunks, which makes it more readable. Unlike T-SQL subqueries, CTEs can be recursive, allowing the traversal of hierarchical models of enormous depth.

About the Common Table Expressions in T-SQL Course
This course will cover simple CTEs, nested CTEs, and recursive CTEs. You will learn how to manage your T-SQL queries with CTEs, how and when to nest CTEs, and how to use recursive CTEs to move through hierarchical data models.

This course is intended for intermediate users. We assume the user knows the basics of T-SQL, including:

  • How to select from a single table, including writing complex WHERE conditions
  • How to JOIN tables
  • How GROUP BY and HAVING work
  • How T-SQL subqueries work

What Are the Requirements?

  • A web browser
  • Knowledge of basic SQL, including JOINs and GROUP BY clauses

What Am I Going To Get from This T-SQL Course?

You will discover how to:
  • Understand and use basic Common Table Expressions
  • Split long T-SQL queries with simple and nested CTEs
  • Deploy recursive CTEs
  • Write recursive CTEs that traverse a hierarchical data model

Who Should Take This Course?

  • Beginning database analysts
  • Developers who want to keep their knowledge of T-SQL current
  • Students taking classes in relational databases
  • Anyone who wants to learn Common Table Expressions in T-SQL
    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

    Bundle price $199

    39 hours left at this price!

    60%
    off

    Reg. price
    $240

    MS SQL Server Kit

    Includes 6 courses SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server

    Bundle price $95

    39 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 112 exercises done

    1. Intro Quiz

    Test your knowledge of T-SQL

    More details Less
    Start now

    0% completed 0 of 10 exercises done

    2. CTE syntax

    Your first encounter with Common Table Expressions

    More details Less
    Start now

    0% completed 0 of 17 exercises done

    3. Nested CTEs

    You'll learn how to use nested CTEs

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    4. Recursive CTEs

    You'll learn what recursion is and how to use it in T-SQL queries

    More details Less
    Start now

    0% completed 0 of 38 exercises done

    5. CTEs with INSERT, DELETE, and UPDATE

    You'll learn how to use INSERT, DELETE, and UPDATE statements with CTEs

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    6. Final Quiz

    Test your knowledge in this final quiz

    More details Less
    Start now

    0% completed 0 of 14 exercises done

    Reviews

    Average rating

    5/5100.0 (2)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0