00:00 - Intro Videos
00:52 - Introduction (and Transformers)
02:07 - Actual Introduction (merge to get flat files)
03:15 - Overview of merge command and what it does
03:57 - DATA.x and DATA.y arguments
05:58 - by= argument
08:39 - by = when using composite key / combo of columns
10:10 - Add sort=FALSE to preserve ordering
11:15 - by = argument when tables have different column name
11:36 - Narrated example of using by
13:16 - all= argument (omitting it)
14:31 - all.x=TRUE
15:58 - all.y=TRUE
16:59 - all=TRUE
17:39 - Exit Video
