Duration: 25:04 min
Summary: Modern database models contains many tables that are related through relationships. Any professional that work with databases must know how to work with more than one table in a SELECT statement. Therefore, this video explain how to use more than one table on the SELECT statetment via aliases and how to perform simple joins in the tables of the sample HR schema provided by Oracle. The examples include equijoins, non-equijoins, right and left outer joins, self joins, and ANSI joins. All the statements are explained and described according to the rows they return based on the data model of the HR schema represented in an Entity Relationship (ER) diagram.