Last time, we looked at Databases and learnt about the fundamental operations in SQL. Today, we look further, into some of the more in-depth operations that involve bringing multiple tables together!

= Resources =
A Database Crash Course (SQL Basics): https://www.youtube.com/watch?v=0hKmmh_4t7w

Download SqliteBrowser: https://sqlitebrowser.org/

Download the database file and code used in the video: https://drive.google.com/open?id=1DhPQhZidFmPReV8HDzmLGSz1lBCg_gjT

= Contents =
00:00 Introduction
00:47 Recap: Selecting from Multiple Tables
01:53 Contents Page
02:45 Introduction: Multiple Queries
03:45 Description of Database
04:36 Start of Multiple Queries Discussion
06:20 UNION Operation
07:15 UNION ALL Operation
07:57 INTERSECT Operation
08:45 EXCEPT Operation
09:29 Introduction to Joins
10:28 Discussion of Data
11:16 Simple Method (Incomplete answer)
12:05 Discussion of why this method fails
13:09 LEFT JOIN (Incomplete answer)
13:52 How LEFT JOINs work
15:05 RIGHT JOIN (Incomplete answer)
15:31 Working Around SQLite's RIGHT JOIN Restriction
17:03 FULL JOIN
17:32 Working Around SQLite's FULL JOIN Restriction
18:29 How the Workaround Works
20:39 Introduction to Nested Queries
21:19 Problem Description


= 0612 TV =
0612 TV, a sub-project of NERDfirst.net, is an educational YouTube channel. Started in 2008, we have now covered a wide range of topics, from areas such as Programming, Algorithms and Computing Theories, Computer Graphics, Photography, and Specialized Guides for using software such as FFMPEG, Deshaker, GIMP and more!

Enjoy your stay, and don't hesitate to drop me a comment or a personal message to my inbox =) If you like my work, don't forget to subscribe!

Like what you see? Buy me a coffee → http://www.nerdfirst.net/donate/

0612 TV Official Writeup: http://nerdfirst.net/0612tv
More about me: http://about.me/lcc0612
Official Twitter: http://twitter.com/0612tv

= NERDfirst =
NERDfirst is a project allowing me to go above and beyond YouTube videos into areas like app and game development. It will also contain the official 0612 TV blog and other resources.

Watch this space, and keep your eyes peeled on this channel for more updates! http://nerdfirst.net/

-----

Disclaimer: Please note that any information is provided on this channel in good faith, but I cannot guarantee 100% accuracy / correctness on all content. Contributors to this channel are not to be held responsible for any possible outcomes from your use of the information.