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 536 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

Agile Methodology in Project Management

0 184 0

In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management

Creating Users and Managing Passwords in Microsoft Office 365

0 795 4

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

Using Navigation Controls in a Collaboration Site in SharePoint

0 361 1

In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint

Write a Comment

Share your thoughts...

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