Chevron Left
Volver a Hospital management database using SQL server

Opiniones y comentarios de aprendices correspondientes a Hospital management database using SQL server por parte de Coursera Project Network

Acerca del Curso

In this 1-hour long project-based course, you will be able to efficiently manage databases using SQL server. In this project, you will be able to work on different databases by using an existing database or creating your own database from scratch. Moreover, you will be able to create, alter and drop tables, identify the difference between Data Definition Language (DDL) and Data Manipulation Language (DML) and finally, insert, update and delete rows in the database. Along the way, you will be applying and practicing the basic features of the database and SQL commands, as well as using DDL, DML, Query statement, Functions, Ordering, Comparison, and Logical condition to use in your work as a software engineer or web developer. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions....
Filtrar por:

1 - 2 de 2 revisiones para Hospital management database using SQL server

por SOURAV K

29 de ene. de 2022

Besat

por Evgeniya T

11 de jun. de 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.