SQL Union and Union All Operators – Tutorial w/ Derby Database

Leave a comment


  • http://www.zaneacademy.com
  • 00:00 What is an example of using the Union and union all operators in a derby database?
  • 04:15 What is the SQL UNION Operator?
  • 05:10 What is an example of the SQL UNION Operator?
  • 07:25 What is the SQL UNION ALL Operator?
  • 07:38 What is the difference between the SQL Union and Union All operators?
  • 08:00 What is an example of the SQL UNION All Operator?

SQL [3/5] INNER JOIN – Tutorial

Leave a comment


  • http://www.zaneacademy.com
  • 00:00 What is an SQL Inner Join?
  • 00:38 What is the syntax of SQL Inner Joins?
  • 01:00 What is another name of an SQL Inner Join?
  • 01:45 What is the default SQL Inner Join?
  • 02:00 What is one way to automate finding the results of SQL Inner Joins?

SQL [4/5] – Equi-join (INNER JOIN)

Leave a comment


  • http://www.zaneacademy.com
  • 00:00 What is an SQL Equi-join?
  • 00:36 What is the syntax of SQL Equi-joins?
  • 01:30 What is an Equi-join with the USING predicate?
  • 02:50 What is a Natural Join?
  • 03:30 How is a Natural Join related to an Inner Join?
  • 04:20 What is a potential problem with Natural Joins?

SQL [2/5] – CROSS JOIN

Leave a comment


  • http://www.zaneacademy.com
  • 00:00 What is the syntax of SQL Cross Join?
  • 00:37 What are SQL Cross Joins?
  • 01:40 What is a detailed example of an SQL Cross Join?

SQL [1/5] – JOIN

Leave a comment


  • http://www.zaneacademy.com
  • 00:00 What are SQL Joins?
  • 00:30 How are records coming from different tables combined using SQL Joins?
  • 01:40 What are the various types of SQL Joins?
  • 02:00 What SQL Joins are subtypes of Inner Joins?

SQL [5/5] – OUTER JOINS

1 Comment


  • http://www.zaneacademy.com
  • 00:00 What is a Full Outer Join?
  • 00:50 What is another name for a Full Outer Join?
  • 03:00 How is a Full Outer Join related to an Inner Join?
  • 05:45 What is a Right Outer Join?
  • 06:30 What is another name of a Right Outer Join?
  • 07:10 How is a Right Outer Join related to an Inner Join?
  • 09:20 What is a Left Outer Join?
  • 09:50 What is another name of a Left Outer Join?
  • 10:15 How is a Left Outer Join related to an Inner Join?
  • 10:50 Do we need both The Left & The Right Outer Joins? Why?

%d bloggers like this: