Reading 08

Read

Complete SQLBolt (Intro, Lessons 1-4, 13-18)

• SQL commands are case insensitive and the layout is very loose so it's helpful to employ formatting to help with legibility and extensibility
• inner join or join is processes matches from two tables that have same column, can use ON to make two columns equivilant ON movies.id = boxoffice.movie_id
• left join includes rows from A even if not in B
• right join includes from B even if not in A
• full join include rows from both even if no match
• handling null values needs to be considered

Practice SQL on W3 Schools - This resource has sample databases you can use to practice writing SQL queries.

Reference

A Primer on SQL - Click the blue Download button SQL Cheat Sheet