YouTube on MSN

SQL tricks with billionaires data

Intermediate SQL tutorial demonstrating REGEXP for advanced filtering, IF & CASE statements to create categories, SUBQUERIES for complex analysis, and JOINS for combining multiple tables — all shown ...
techtarget

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this excerpt from SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, John L. Viescas and Michael J. Hernandez discuss the LEFT OUTER JOIN vs. the RIGHT OUTER JOIN and offer ...