more than perfect

Besat

The project is not as extensive as I hoped it would be. I expected more individual practice as well as variety of exercises. The sound of the video was rather bad, at times illegible. Instructor's English accent was difficult to understand at times which made following the videos a bit tedious.  Also, there was a mistake in one of the solutions in video 4 where the following search was presented: 

SELECT Patient_Name, Disease, Doctor_Name

FROM Patient, Doctor

WHERE Patient.Patient_ID = Doctor.Doctor_ID

The last WHERE condition returned incorrect information and the correct clause should have been:

WHERE  Patient.Doctor_ID = Doctor.Doctor_ID

I am also puzzled as to why the instructor didn't use an INNER JOIN query instead. In fact, I expected INNER and OUTER JOINS to practice with as these are very effective but difficult to grasp  when retrieving data from relational databases.