How to use Common Table Expression (CTE) in SQL Server to break down problems into multiple steps

Home > Videos > SQL Server > How to use Common Table Expression (CTE) in SQL Server to break down problems into multiple steps

How to use Common Table Expression (CTE) in SQL Server to break down problems into multiple steps

Like This Video 0 593 Peter Avila
Added by March 18, 2019

In this SQL Server training video, instructor Peter Avila demonstrates how to utilize common table expressions (CTEs) to progressively convert one data structure to another. Using a real world example, Peter introduces a common problem in which the structure of the desired output and the structure of the data in the database are so different that the output cannot be obtained by a single transformation of the data from the database. Using a chain of CTEs, Peter shows how to break down the problem into smaller transformations and perform them step by step to obtain the desired structure in the output.

 

Videos You May Like

A Simple Introduction to Cisco CML2

0 3912 0

Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2

Cable Testers and How to Use them in Network Environments

0 741 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments

Data Models in Business Analysis

0 200 0

This video is from our PMI-PBA Business Analysis for IT Analysts and Project Managers (PMI-PBA)® Certification now available at Interface Technical Training. Also see Steve’s PMP Project Management Certification Course: Project Management Professional (PMP®) Certification Video Training PMBOK® 6th Edition  Video Transcription: Data Models are part of the elicitation analysis in PMI-PBA. This is the way … Continue reading Data Models in Business Analysis

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.