Database Project for MS SQL Server
ฝัง
- เผยแพร่เมื่อ 19 พ.ค. 2016
- This project uses the Westlake Database project. It adds the tables needed to patient visits / symptoms, adds stored procedures, triggers and indexes, and asks the student to create views using query skills learned previously.
The importance of database security to prevent SQL injection attacks is also demonstrated, and mitigated through the use of stored procedures. In addition, indexes are discussed and demonstrated.
Thank you for your excellent and brief video. I covered a lot of things which I needed to know very simple and very practical.
I appreciate if you create more videos.
Thanks again
Namastey Brian,
Your videos are significantly helpful. Please upload more videos that enhance the skill of data engineer and also let me know how can we improve our skills to command no SQL /Hadoop/Bigdata.
Thank you very much and stay blessed.
Thank you so much sir!
Thank you! this is really helpful
wonderful
this project is for dba admin or developer
can you please tell me the relation of tables like one to one ,one to many , many to one i'm waitaing for your response asap!
Sir i like your project but sir please create point of sale project in sql server management studio
can you please post this php code?
How do I know what the foreign key is for all the tables other then the Patient and PatientVisitSymptom tables? I wrote the code and got an error message. But don't know what all the foreign keys are
th-cam.com/video/H7uGGg1BQ2Y/w-d-xo.html
Can you please provide the overview of this project also...??
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Patient_Doctor". The conflict occurred in database "ClinicDoctor", table "dbo.Doctor", column 'DoctorKey'.
The statement has been terminated.
Danciu Mihai you need to set the enforcement foreign key as no
What are the foreign key for all the tables other then Patient and PatientVisitSymptoms table?
th-cam.com/video/H7uGGg1BQ2Y/w-d-xo.html
Can anyone help ??
I did it like this,
create trigger onUpdateDoctor
on doctor
after update
as
begin
set nocount on
update doctor set datemodified=getdate()
from doctor d -----------------------------------------------------------------------THIS CONFUSING ME
join inserted i on d.DoctorKey=i.DoctorKey ------------------------- PART IS
end
go
I stackoverflow ed the solution but couldnt find explanation.
in the beginning how did u make the database diagram?
Right click in Database diagram in left side and Click Create a diagram for the table you want.
can you please share the video of first video
can you please share the source code of the project for practice
where did he download the database from?
Pls Send the coding of this project
I am looking for a job as an SQL developer will the above project help Bryan.
Hello
@@manishag4218 hello
For Project: github.com/zeeshanallrounder/SQL