автор: SOURAV K•
29 янв. 2022 г.
автор: Evgeniya T•
11 июня 2022 г.
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.