I didn't test it but is seems this should work and is a bit simpler:

SELECT s.* FROM Students s

LEFT JOIN StudentExam se

ON s.StID=se.StID

WHERE ISNULL(se.ExamName,'') <> 'SQL Server'

This way any NULLs would be replaced with '' and therefore would not include 'SQL Server'.

Eva