SQL SELF JOINS

Leave a comment


http://www.zaneacademy.com
| 00:30 When is SQL Self Joins used?
| 01:20 What is the relation between SQL JOINS and SQL CROSS JOINS?
| 02:10 What is an SQL Inner Join?
| 03:00 What is an SQL Self JOIN?
| 03:30 What is another way of writing SQL CROSS JOINS?
| 03:55 What is the default SQL JOIN Type?
| 04:20 What is an SQL LEFT Outer JOIN?

Advertisements

SQL JOINS w/ Derby Database

Leave a comment



http://www.zaneacademy.com
| 00:40 Does Derby Database supports SQL Full Outer Join?
| 00:50 What are various types of Inner Joins?
| 01:05 How to start and access Derby Database from the command prompt?
| 02:35 What is an SQL Cross JOIN?
| 03:10 What is an SQL Join?
| 03:30 What is another way of doing an SQL Cross Join?
| 03:50 What is the relationship between SQL Cross Join and SQL InnerJoin?
| 04:50 What is an SQL Join?
| 05:10 What is the default Join type?
| 05:30 What is an SQL Equi-Join?
| 06:00 What is an SQL Equi-Join w/ the USING Construct?
| 06:15 What is an SQL Natural Join?
| 06:30 What is an SQL Right Outer Join?
| 06:50 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:30 What is the relation between an sql inner join and an sql left join?
| 08:45 Does Derby Database support Full Join?
| 09:15 How to simulate a Full Outer Join w/ Derby Database?

MySQL SQL JOINS – under 10 minutes

Leave a comment



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?

UML: Association, Aggregation, Composition, Dependency, Generalization, and Realization

Leave a comment



Website + download source code @ http://www.zaneacademy.com
| 00:10 What are the most important relationships in a UML class diagram?
| 00:20 What are the different types of association relationships?
| 00:45 What is a dependency relationship in UML?
| 01:05 What is the difference between Generalization & Realization?
| 01:25 Which UML Class relationships are tightly coupled?
| 01:55 Which UML Class relationships are loosely coupled?
| 02:10 What is a Binary Association?
| 02:20 What is the difference between a bidirectional and a unidirectional association?
| 03:10 What is a Self Association?

| 03:25 What is an N-ary Association?
| 04:10 What is Aggregation?
| 04:50 What is Composition?
| 05:00 What is the difference between Composition and Association?
| 05:50 What is a Dependency UML Relationship?
| 06:35 What is a Generalization UML Relationship?
| 08:13 What is Subtyping Polymorphism?
| 09:18 What is a UML Realization Relationship?

%d bloggers like this: