Hands-on SQL practice tasks and database operations performed during NAVTTC training sessions and personal learning. The examples cover various database concepts such as DDL, DML, sequences, ...
-- parent table: without cascade, cannot delete or update parent row: foreign key constraint fail when that value is present in child table DELETE FROM departments WHERE dept_no = 2; ...