SQL Joins and Subqueries | SQL multiple table queries | Apex Oracle

In this video you will learn:
the process of querying multiped tables using SQL joins and Subqueries.
Inner join, left join, right join, full join, equijoin, union, intersect.

Other lectures:
****** Video 1: CREATE TABLE:    • SQL Database Video 1: Create tables | Apex...  
****** Video 2: INSERT INTO:    • SQL Database Video 2: Insert Rows INTO Tab...  
****** Video 3: ALTER TABLE:    • SQL Database Video 4:  UPDATE Table with A...  
****** Video 4: UPDATE TABLE:    • SQL Database Video 4:  UPDATE Table with A...  
****** Video 5: SELECT FROM TABLE :    • SQL Database Video 5:  SELECT  FROM table ...  
****** Video 6: ORDER BY :    • SQL Database Video 6: ORDER BY to sort row...  
****** Video 7: AGGREGATE FUNCTIONS:    • SQL Database Video 7:  SQL AGGREGATE FUNCT...  
****** Video 8: STRING FUNCTIONS:   • SQL Database Video 8:  SQL STRING FUNCTION...  

CREATE DATABASE CODE:
-- Step1: CREATE all tables one by one in this order
CREATE TABLE Department_T (
Department_No NUMBER (2) PRIMARY KEY,
Department_Name VARCHAR(15)
);
CREATE TABLE Employee_T(
Employee_No NUMBER (6) PRIMARY KEY,
Employee_Name VARCHAR(20),
Department_No NUMBER (2) REFERENCES Department_T (Department_No)
);
CREATE TABLE Project_T(
Project_Code NUMBER (3) PRIMARY KEY,
Project_Title VARCHAR (25),
Project_Manager VARCHAR (20),
Project_Budget DECIMAL (8,2)
);
CREATE TABLE Participation_T (
Employee_No NUMBER (6) REFERENCES Employee_T(Employee_No),
Project_Code NUMBER (3) REFERENCES Project_T(Project_Code),
Hourly_Rate DECIMAL (6,4),
PRIMARY KEY (Employee_No, Project_Code)
);
-- Step2: INSERT DATA INTO tables one by one in this order

INSERT CODE HERE in description :    • SQL Database Video 7:  SQL AGGREGATE FUNCT...