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: https://youtu.be/wCrbVA8-ru0
****** Video 2: INSERT INTO: https://youtu.be/mB7GMnBSDfg
****** Video 3: ALTER TABLE: https://youtu.be/ZExBH6zITNQ
****** Video 4: UPDATE TABLE: https://youtu.be/ZExBH6zITNQ
****** Video 5: SELECT FROM TABLE : https://youtu.be/iyebZEMCLxE
****** Video 6: ORDER BY : https://youtu.be/3CK-6hAsoPU
****** Video 7: AGGREGATE FUNCTIONS: https://youtu.be/Ce4Hf9HjKQU
****** Video 8: STRING FUNCTIONS:https://youtu.be/5G8pQGp5Tow

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 : https://youtu.be/Ce4Hf9HjKQU