SQL

MySQL SQL JOINS – under 10 minutes



http://www.zaneacademy.com
| 00:40 Does MYSQL supports SQL Full Outer Join?
| 01:00 What are various types of Inner Joins?
| 01:30 How to start and access MySQL from the command prompt?
| 02:35 How to Join 2 tables in SQL?
| 03:10 What is an SQL Join?
| 04:00 What is an SQL Cross Join?
| 05:00 What is the difference between an SQL Join and an SQL Inner Join?
| 05:40 What is an SQL Equi-Join?
| 06:05 What is an SQL Equi-Join w/ the USING construct?
| 06:28 What is an SQL Natural Join?
| 06:50 What is an SQL Right Outer Join?
| 07:00 What is an SQL Right Join?
| 07:15 What is the relation between an sql inner join and an sql right join?
| 07:42 What is an sql left outer join?
| 07:52 What is an sql left join?
| 08:02 What is the relation between an sql inner join and an sql left join?
| 08:25 Does MySQL supports Full Join?
| 08:45 How to do a Full Outer Join w/ MySQL?

Advertisements
SQL

SQL JOINS – under 14 minutes


website + download source code @ http://www.zaneacademy.com
| 00:10 What are SQL Joins?
| 00:30 How to combine records from different tables w/ SQL Joins?
| 02:00 What are the different SQL Join Types?
| 02:20 What SQL Joins are subtypes of Inner Joins?
| 02:40 What are SQL Cross Joins?
| 02:50 What is a detailed example of an SQL Cross Join?
| 04:10 What are SQL Inner Joins?
| 04:20 What is the default join type?
| 04:30 What is another name of an SQL Inner Join?
| 05:00 What is one way to automate finding results of SQL Joins?
| 06:30 What is an SQL Equi-join?
| 07:03 What is an Equi-join with the USING predicate?
| 07:40 What is a Natural Join?
| 07:50 What is a potential problem with Natural Joins?
| 08:10 What is a Full Outer Join?
| 09:00 How is a Full Outer Join related to an Inner Join?
| 10:00 What is another name of a Full Outer Join?
| 10:45 What is a Right Outer Join?
| 11:00 How is a Right Outer Join related to an Inner Join?
| 11:30 What is another name of a Right Outer Join?
| 11:55 What is a Left Outer Join?
| 12:10 How is a Left Outer Join related to an Inner Join?
| 12:40 What is another name of a Left Outer Join?
| 12:55 Do we need both The Left & The Right Outer Joins? Why?

SQL

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


  • 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?