SQL JOINS – under 14 minutes

Leave a comment


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?

Java 8 tutorial 18 (Streams) – allMatch Stream method

Leave a comment


http://www.zaneacademy.com | allMatch Stream method (Lazy Evaluation + Short Circuit)

Java 8 tutorial 17 (Streams) – toList, toSet, & toCollection Collectors methods

Leave a comment


http://www.zaneacademy.com | toList, toSet, & toCollection Collectors methods + collect Stream method

Java 8 tutorial 16 (Streams) – groupingBy, partitioningBy, counting, & mapping Collectors methods

Leave a comment



http://www.zaneacademy.com | groupingBy, partitioningBy, counting, and mapping Collectors methods + collect Stream method

%d bloggers like this: