Finding missing names in another table

It is necessary to compose an SQL query that outputs all values from the name column of table A not found in the Name column of table B. The query should correctly handle case differences (if the comparison is case-sensitive) and return only unique names without duplicates.