Aaron Christopher hell this is my first time using this software and I don't know what I'm doing however I think this video is going to be extremely helpful # it's game time 🙏🏾
Wow, this is an amazing video! Been learning SQL queries and syntax for a while now, but never really learnt about database creation and design. You've really helped me put things together. Thanks again.
You are a life savior!!!! I was trying to finish my assignment for one of my master program class, and i got stuck... You are a GOD SENT! Thank you soooo much for your time!!!
Thanks. It helped my productivity raise a ton. i'm new to SQL Server Management Studio. I'm rather used to MySQL Workbench. I learnt I was doing it wrong and I had a feeling it was so, hence me watching this video. Now I got confirmation of my assumption and a solution to apply. I want to be able to send this DB script by this evening.
you are a life saver, my online exam starts in 2 hrs, emailed my tutor, he hasn't got back to me, your video my friend is spot on, cleard all my doubts
Thank you so much for this video! I couldn't understand how to use this when trying to create one for homework and you saved my grade!! I am subscribed now!
Brian,The diagram saved correctly. When I refreshed the "Patient" table. The Doctor column was supposed to change to a foreign key. Didn't happen for me... You have any idea why? Thanks
This video is a glorious golden nugget of awesomeness. Have you thought about reuploading with better audio? The info is so good, but the audio is very bad.
Hey Brian I am new for MSSQL 2017, I didn't see database diagram folder which should be just after database and before TABLE can you help me out Thanks in advance.
When I try to create new database, I get an error 5105: "An exception occurred while executing a Transact-SQL statement or batch." However, when I wrote an SQL Query for creating a database and executed it, it worked. And much bigger problem, when I try to add table, I get a warning "This backend version is not supported to design database diagrams or tables." When I create table by SQL Query, there's no problems with executing the query, but I cannot see table in tables list.
When creating the database diagrams. It says the following data type properties of column dbo.Doctor.DoctorKey do not match those of dbo.Patient.DoctorKey. I had an error earlier because I put nvarchar instead of nchar for Patient, but i got that fixed. Now it’s telling me this. But my data type is correct. It does say length, but they are both nchar(15) for DoctorKey. Any idea what the issue is?
I must of missed an earlier video - what book is he referring to in this video? Also is there a list of videos to follow this from beginning to end? Thanks
MS SQL Management Studio crashes when I try and open my database diagram. DOES ANYONE ELSE HAVE THIS? DO YOU KNOW HOW TO FIX THIS ISSUE? Thank you very much.
You dont need to run script or modify script to edit any table. Just modify it and change the value. First be sure to uncheck the "prevent saving changes that require table recreation" option. Go to Tools > Options > Designers > Table and Database and uncheck the last option.
Thank you sir and this video really helped me to learn Relational Database. I would like to ask you a question. What is the relation between this method and entity framework? Can we apply this relational database in entity framework? I was always afraid to learn entity framework because it seems very hard to me:/ Is it that difficult or easy and valuable to learn? Thanks in advance and have a nice day!
The data provided by the lab manual for this exercise used values for the Patient_Key and Doctor_Key that included dashes. For example, Patient_Key 1-24, or doctor_key 1-30. An integer would not be able to store the dash "-" character. If the ID's were only integers, than I would have used integer. In many cases, when we are designing new databases, it has to support existing fields/values from legacy systems, or natural keys. To see more examples of this, take a look at my videos on creating a MySql/MariaDB database for the Department of Education College Scorecard data from data.gov: th-cam.com/play/PL6XklZATqYx-6BDhP01cdfdv1m35Hn68G.html
8:37 you just have to change setting , go to Tools -> options -> Design -> uncheck the "prevent saving changes that require table recreation" and then you don't have to write that script
hi canu u please tell me how to design a database to store Retail Data for a Sales Business.CASE STUDY FOR DATABASE DESIGN AND RELATIONSHIP UNDERSTANDING please
Thank you sir :) After 1 hour wondering why I couldn't save the database diagram, I tried this method and it finally worked! A very helpful comment indeed.
do you have another video explaining this where I can actually hear you?? volume all the way up on the CPU and TH-cam and it sounds like you're in the next room with the door shut with a sock in your mouth. No offense, I'm just really confused about this and it's aggravating!
si j peux savoir des requets qui permet de faire union et jointure , I live in Francophone contry in Africa , I don't speak english ,mais si vous pouvez faire en francais
go and learn english. There is no time for translation here. SQL statements are in english call it structured english query language if you care so learning english is an obligation
Yup... All the time! The GUI tools work pretty well, but there are times you have to use just SQL, and its obviously very important to understand the code if you are looking at SQL CREATE TABLE scripts.
Thanks for trying, but fix your sound. Even though this is more intelligible than the five demos above you in the search results, it's still next to impossible to follow due to the audio.
can't link them... ERORS, cant populate my table..errors.... can't edit my fields because you guess it.. errors that stupid "save as text or cancel pop up ... omg fuck this bullshit i rather pull my neils than to work with this anti-logic UI crap, but I need a passing grade so thanks for the tutorial.
I learned more from this video than I did in my 5 week SQL Database Management class. THANK YOU
Aaron Christopher hell this is my first time using this software and I don't know what I'm doing however I think this video is going to be extremely helpful # it's game time 🙏🏾
lol same here
Classes make me sleep and bored.
same here ... attending university classes is useless !
Wow, this is an amazing video! Been learning SQL queries and syntax for a while now, but never really learnt about database creation and design. You've really helped me put things together. Thanks again.
You are a life savior!!!! I was trying to finish my assignment for one of my master program class, and i got stuck... You are a GOD SENT! Thank you soooo much for your time!!!
Thanks. It helped my productivity raise a ton. i'm new to SQL Server Management Studio. I'm rather used to MySQL Workbench. I learnt I was doing it wrong and I had a feeling it was so, hence me watching this video. Now I got confirmation of my assumption and a solution to apply. I want to be able to send this DB script by this evening.
You are awesome! I learned how to successfully do a database in 30mins and I have learned nothing from 3 years of school. Thank you so much😊
you are a life saver, my online exam starts in 2 hrs, emailed my tutor, he hasn't got back to me, your video my friend is spot on, cleard all my doubts
Thank you so much for this video! I couldn't understand how to use this when trying to create one for homework and you saved my grade!! I am subscribed now!
Very Well explained. Definitely it helped your students. And it also helps many other student. Thanks a lot.
Fantastic SQL tutorial! Thank you!
Very helpful and easier to understand. Thank you.
This looks like it has some good content. Sadly, I can't hear it.
Thank you for sharing. Great Job!
Thanks Brian! Good turtorial..!!!!
wow Brian this is what i have been looking for since!
I hope i will continue to learn from you thanks a lot im a information technology student this is my lesson information management
thank you ! super easy to follow as a beginner !
Your a great educator .
Thanks for whispering the whole way through the tutorial dude....REALLY helpful!!!! >:(
SAVED MEEE!! So clear!
Please increase the sound volume and thanks for the incredible video!
Thanks for the video..Really helps me.
Very nice & Good
Brian,The diagram saved correctly. When I refreshed the "Patient" table. The Doctor column was supposed to change to a foreign key. Didn't happen for me... You have any idea why? Thanks
very helpful Thanks !!
This video is a glorious golden nugget of awesomeness. Have you thought about reuploading with better audio? The info is so good, but the audio is very bad.
Hey Brian I am new for MSSQL 2017, I didn't see database diagram folder which should be just after database and before TABLE can you help me out Thanks in advance.
When I try to create new database, I get an error 5105: "An exception occurred while executing a Transact-SQL statement or batch." However, when I wrote an SQL Query for creating a database and executed it, it worked. And much bigger problem, when I try to add table, I get a warning "This backend version is not supported to design database diagrams or tables." When I create table by SQL Query, there's no problems with executing the query, but I cannot see table in tables list.
When creating the database diagrams. It says the following data type properties of column dbo.Doctor.DoctorKey do not match those of dbo.Patient.DoctorKey. I had an error earlier because I put nvarchar instead of nchar for Patient, but i got that fixed. Now it’s telling me this. But my data type is correct. It does say length, but they are both nchar(15) for DoctorKey. Any idea what the issue is?
I must of missed an earlier video - what book is he referring to in this video? Also is there a list of videos to follow this from beginning to end? Thanks
Thanks Brian
where did the create table come from on the new query?
I need headphones to hear this properly. Please fix the sound professor.
\/what a great video. Kindly improve in your sound next time. Thank you.
MS SQL Management Studio crashes when I try and open my database diagram. DOES ANYONE ELSE HAVE THIS? DO YOU KNOW HOW TO FIX THIS ISSUE? Thank you very much.
Good course for beginners. Thanks a lot Brian. Buy a better microphone and make some courses on Udemy
This is an old video... My latest setup is using Maono mike with an iPhone 6S as the camera. Works a lot better!
Even after the update, the database diagram still won't open. Instead, the program will crash without an error message.
PLEASE MAY SOMEONE HELP!?
You dont need to run script or modify script to edit any table. Just modify it and change the value. First be sure to uncheck the "prevent saving changes that require table recreation" option. Go to Tools > Options > Designers > Table and Database and uncheck the last option.
Thank you sir and this video really helped me to learn Relational Database. I would like to ask you a question. What is the relation between this method and entity framework? Can we apply this relational database in entity framework? I was always afraid to learn entity framework because it seems very hard to me:/ Is it that difficult or easy and valuable to learn? Thanks in advance and have a nice day!
I suggest the voice over the microphone was higher enough to hear you! Thank u :)
Stay awesome
Can you fix the sound a bit? Please
Hello, this is a great video. You are helping me with a project. What is the book you are referring to?
Hi
the video was perfect . thank you
i just wish your voice over the microphone was higher
very easier and helpfull!
i'm looking for database for hospital management system.can you help me??
Good class but please use a better Mic as it is really hard to hear.
having a same name for primary key in three tables is not a good idea , as it creates lot of problems when you join tables and do some nested queries.
Hi brian, can you tell me why did you chose string(nchar) as datatypes for the keys instead of integer(int).
The data provided by the lab manual for this exercise used values for the Patient_Key and Doctor_Key that included dashes. For example, Patient_Key 1-24, or doctor_key 1-30. An integer would not be able to store the dash "-" character.
If the ID's were only integers, than I would have used integer. In many cases, when we are designing new databases, it has to support existing fields/values from legacy systems, or natural keys. To see more examples of this, take a look at my videos on creating a MySql/MariaDB database for the Department of Education College Scorecard data from data.gov: th-cam.com/play/PL6XklZATqYx-6BDhP01cdfdv1m35Hn68G.html
@@BrianGreenNJthank you 😊
8:37 you just have to change setting , go to Tools -> options -> Design -> uncheck the "prevent saving changes that require table recreation" and then you don't have to write that script
hi canu u please tell me how to design a database to store Retail Data for a Sales Business.CASE STUDY FOR DATABASE DESIGN AND RELATIONSHIP UNDERSTANDING please
Thank you sir :) After 1 hour wondering why I couldn't save the database diagram, I tried this method and it finally worked! A very helpful comment indeed.
That moment when you're Lead DB administrator and you have to watch this to enforce simple things so that people don't fuck up data integrity.
where is the assosiation betwiin two table??? or its just foreign key
In the physical design, an association is achieved through foreign keys.
do you have another video explaining this where I can actually hear you?? volume all the way up on the CPU and TH-cam and it sounds like you're in the next room with the door shut with a sock in your mouth. No offense, I'm just really confused about this and it's aggravating!
I downloaded SSMS 18 and created LocalDB file. I have no any Database Diagram folder (in Object Explorer) at all.
same problem, has you solved it yet?
yes, you need to install previous version of SSMS. This feature was deprecated in SSMS 18.
@@ivankukushkin9923 thank you
Audio is soo bad!. Could you please fix it sir!? Thank you in advance!
Audio's really bad.. would have been great video
hard to hear you
it's very low...... i can't hear even with headphones 😔
Mr ur sound is very low can U fixed thank U.
can't hear a thing
si j peux savoir des requets qui permet de faire union et jointure , I live in Francophone contry in Africa , I don't speak english ,mais si vous pouvez faire en francais
go and learn english. There is no time for translation here. SQL statements are in english call it structured english query language if you care so learning english is an obligation
its so quiet 😿
Please don't hide your mic under your keyboard in the next video.
Not audible
Do people really create sql table by writing it?
Yup... All the time! The GUI tools work pretty well, but there are times you have to use just SQL, and its obviously very important to understand the code if you are looking at SQL CREATE TABLE scripts.
@@BrianGreenNJ Ooo... thanks for explaining.
Your students are spoiled :-)
volume is very low
volume is too low
Thanks for trying, but fix your sound. Even though this is more intelligible than the five demos above you in the search results, it's still next to impossible to follow due to the audio.
very hard to listen.
Learn how to use a DB or VU meter to properly set VOLUME LEVELS! You *NEVER* set it by ear using headphones, you use a METER!
can't link them... ERORS, cant populate my table..errors.... can't edit my fields because you guess it.. errors that stupid "save as text or cancel pop up ... omg fuck this bullshit i rather pull my neils than to work with this anti-logic UI crap, but I need a passing grade so thanks for the tutorial.
Poor audio quality.
sound system is worst
abysmal audio
Terrible audio..
Speak up!!!!!!!!!!!!!1
Honza B turn up your volume. Sheesh.