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

Home > Videos > SQL Server

Videos: SQL Server

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

0 184 0

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 … Continue reading How to use Common Table Expression (CTE) in SQL Server to break down problems into multiple steps

SQL Server Videos

What is a Database by SQL Server instructor Peter Avila

0 28 3

In this video, SQL Server instructor Peter Avila presents a simple explanation to what a database is and how to use them. There are a few terms for SQL Server administrators to understand as they pertain to databases. Miniworld: An aspect of the real world. Anything from which a database can be made from. Data: … Continue reading What is a Database by SQL Server instructor Peter Avila

SQL Server – Understanding Data Type Functions Cast and Convert

0 28 1

In this SQL Server training video, instructor Peter Avila discussed and demonstrated the difference between Cast and Convers in data types in SQL Server.   For instructor-led SQL Server training, see our course schedule. Microsoft SQL Server Training Classes

The Difference Between Joins in SQL Server (Inner, Outer, Left and Right Joins)

0 202 0

The Difference Between Joins in SQL Server (Inner, Outer, Left and Right Joins) In this video, SQL Server instructor Peter Avila answers one of the most common questions he receives while teaching; “what’s the difference between inner joins and outer joins?”   For instructor-led SQL Server training, see our course schedule. Microsoft SQL Server Training … Continue reading The Difference Between Joins in SQL Server (Inner, Outer, Left and Right Joins)

Workshops / Webinars

Project Management (PMP) for Executives – Introduction

1 69 0

Introduction Project Management (PMP) for Executives is a 9 part video training series developed by Steve Fullmer, PMP, MBA, MCT/CTT+, CDP.  Steven has a global reputation as a project manager, chief technology officer, and computer systems innovator. He has authored more than 100 articles and a dozen courses in the fields of project management, productivity, business … Continue reading Project Management (PMP) for Executives – Introduction

Project Management (PMP) Leadership Skills in the 21st Century … Do you Know Your History? – November 10, 2017

0 88 2

The PMI Leadership triangle touts our need to develop our knowledge and application of leadership. Do you understand the leadership models of the 20th century? The 21st Century? Understanding your predecessors can assist to set your future course. On the matter of history, Mark Twain’s quote “History doesn’t repeat itself, but it does rhyme” is … Continue reading Project Management (PMP) Leadership Skills in the 21st Century … Do you Know Your History? – November 10, 2017

Principles of Decision Tree Design and Analysis in Project Management (PMP)

0 51 0

In this Project Management Professional (PMP) training video, learn how about Decision Trees and how to solve them with Risk Analysis. Existentialism conveys themes like the importance of choice, contingencies, and extreme situations.  How do you choose when the decision is hard? (If the decision is easy, you just choose.) When the decision is hard, we … Continue reading Principles of Decision Tree Design and Analysis in Project Management (PMP)

Understand the Mind to Become a Better Project Manager – February 18, 2015

0 88 1

Our minds all work alike, at least biologically. Yet we are a diverse species with different motivations, opinions, perspectives, and directions. Do you understand how and why the human mind works? What makes you a great project manager? In this recording of our PMP training webinar from February 18, 2015, Steve Fullmer covers some of … Continue reading Understand the Mind to Become a Better Project Manager – February 18, 2015

Windows 10 Security – What’s New and Improved? – December 3, 2015

0 94 1

In this recording of our Windows 10 webinar from December 3, 2015 training,  security expert Mike Danseglio presents the enhanced security features of SmartScreen, Defender and BitLocker in Windows 10 and new features such as Biometric Identification, Microsoft Passport, Device Guard and more.

Windows 10 Managing, Deploying and Configuring – December 2, 2015

0 434 1

In this recorded Windows 10 training webinar from December 2, 2015, Windows Server instructor Rick Trader presents the deployment and management of Windows 10 Enterprise and the new Provisioning capability in Windows 10. Learn how to manage Windows 10 deployments using System Center Configuration Manager, Mobile Device Management and Intune. Also included in his presentation … Continue reading Windows 10 Managing, Deploying and Configuring – December 2, 2015

Videos You May Like

Configuring Windows Mobility Center and How to Turn it On and Off

1 960 1

Video transcription Steve Fullmer: In our Windows training courses, we often share information about the Windows 8.1 Mobility Center. Mobility Center was introduced for mobile and laptop devices in Windows 7. It’s present and somewhat enhanced in Windows 8. Since we don’t have mobile devices in our classrooms, I decided to take a little bit … Continue reading Configuring Windows Mobility Center and How to Turn it On and Off

How to Configure Navigation in SharePoint Publishing Sites

0 1154 3

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – Using Navigation Controls in a Publishing Site in SharePoint Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – » How to Configure Navigation in … Continue reading How to Configure Navigation in SharePoint Publishing Sites

Windows 10 Features and Navigation – December 1, 2015

0 114 1

In this recorded Windows 10 webinar from December 1,2015, Windows Instructor Steve Fullmer presents the navigation and some of the new features associated with Windows 10 including Sysinternals Tools for Windows Client, Windows core concepts, exploring Process Explorer as well as some of the features that are not yet ready for prime time but will … Continue reading Windows 10 Features and Navigation – December 1, 2015