Hello Sumit. Thank you for providing valuable course in tough times. I've followed few channels for SQL and it's always confusing because lot of other flavours of SQL are mixed with it. Hopefully I'll find out complete SQL course and be able to write easy to intermediate queries required for Data Analyst. Thank you again and very good luck to all the viewer's and subscribers of this course 👍🙏🙂
It is rare to find such easy and descriptive session .My suggestion is to go through complete playlist practice along side . It will take some time but trust it will worth it. I am one of student of Sumit sir's big data program. The way he explain the concept is just phenomenal. Thanks Sumit sir :)
sir when primary key is set auto-increment for id and we have a unique key for name ..why for each wrong value for unique key ..the primary key auto increment it self? like my id=1 if i give unique key two times wrong .then 3rd time i gave correct value as per unique key..now my id=4..why not id=2 or 3 because value was not inserted in db and they were wrong as per unique key.
Sir can u give real life scenarios in which only Primary Key can/should be used and in situations where only Unique Key can/should be used? and thanks for the video 👍👍💖💖
Hey there, kudos to your great efforts. I have a simple enquiry as an newbie sql learner. Why cant i have more than one primary key in a single table? Thanks for taking care of this.
Basically its like a roll number of a student.. you can have multiple keys which can uniquely identify records, bt those keys will be candidate key.. one key among them will be chosen as primary key for the table.. And yes, a table xan only have one and only primary key.. they key can be combo of multiple columns, but ony one primary key can exist
When you use auto increment the structure of a table was showing thats the primary key is also active but you are using auto increment how both of them can be use at the same time.
Sir, based on below screen shot here if ID is unique key, then does that mean records 2 and 3 are different, since Null means (we do not know the value) hence records 2 and 3 are distinct? even though they look same, but the records are unique Please advise..
Hello Sir, Good day. Sir , You mentioned about in session 1 you will provide this notepad where you are writing . But this is the 3rd video but i am not able to find any link related about this note. if you will provide it will very helpful for us.. Thank you Sir:)
While explaining about unique key , As you said we can have one primary key But in composite primary key you used two columns as primary key i.e PRIMARY KEY (ID, NAME) Then how it is possible ? THEN
yes we can have it , but no meaning to do as we do it for primary key just to ensure if we have duplicate records then also we can distingiush between them.
Insert the first record with id 1101 explicitly eg: INSERT INTO employee(id, fn, ln, age) VALUES (1101, '.....', ....... ); Then insert normally, no need to specify id in columns, it will auto-increment. eg: INSERT INTO employee(fn, ln, age) VALUES ..... ;
when I create table in this format and then describe the table it shows id as primary key although I have specified it as UNIQUE KEY, if you could please tell the reason behind this.. create table employee ( id int UNIQUE KEY AUTO_INCREMENT, firstname varchar(20), lastname varchar(20), age int NOT NULL );
Hi Sir, Thank you very much for this video, I have a question here which others might have as well: Primary key (FirstName,LastName) is this same as FirstName varchar(20) Primary Key, LastName Varchar(20) PrimaryKey, will the sql editor accept the second statement? Since you said there is only one Primary key but we can have combination of 2 columns as Primary Key? Looking at the schema if there are more than 1 column with Primary key, should we say that Primary key was imposed on the combination of those columns?
hey they are not same PRIMARY KEY(...) will work but second one will not work you can try maybe because if we give it for seperate columns, then this statement will be wrong like we can have only one primary key
I am a working professional and loved your teaching methodology. Is there a way to get the running notes you are creating during the videos? @Trendytech Insights
Hi Sumit sir, I cannot connect to your LinkedIn account. Please provide a link so that I can connect to you. I need some help so want to get in touch with you. Thanks in advance!
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql4
I have been working as a QA automation engineer. would like to update my skill/competency. which course do you suggest for me sir?
😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
I have watched a lot off tutorial on udemy and youtube no one teach like you sir. Your teaching is simple and understandable thanx a lot sir ❤❤
waiting for the completion of basics and upcoming advanced concepts of sql sumit sir....excellent work n gift for working professionals.
Thank you Nikhil for those kind words. Motivates me to create more :)
@@sumitmittal07 🙏
Beyond the ordinary..No words to describe your teaching..it is flawless..
humbled 😀
Hello Sumit. Thank you for providing valuable course in tough times. I've followed few channels for SQL and it's always confusing because lot of other flavours of SQL are mixed with it. Hopefully I'll find out complete SQL course and be able to write easy to intermediate queries required for Data Analyst. Thank you again and very good luck to all the viewer's and subscribers of this course 👍🙏🙂
Amazing SQL videos.. finally i have found good channel for SQL
Glad to hear that!
It is rare to find such easy and descriptive session .My suggestion is to go through complete playlist practice along side . It will take some time but trust it will worth it.
I am one of student of Sumit sir's big data program. The way he explain the concept is just phenomenal.
Thanks Sumit sir :)
Sumit Sir makes everything simple, he is a true magician.
Thank you so much Sir for the SQL couse, I am loving it! ❤️
Pleased that you are liking the SQL series :)
It is really a very good course. I am learning SQL from your videos and I am loving it. Thank you.
Well described, My 2nd Day of this learning session.
Really appreciate your way of teaching sir . Clarity is on next level . Many thanks for your complete SQL play list .
Wonderful lession sir ...looking forward to go deeper into SQL🙂
Keep following, you will master SQL the right way :)
so far the session are upto point, very easy to understand - good work sumit sir 👏
This is the way of teaching
Spark-Sumit Forever😁
Hi Sir, an amazing journey, I am starting it to sharpen my skills in SQL, without you it wouldn't have possible. Hats of for you Sir.
Excellent teaching Sumit Sir.
Happy to know that you are enjoying my teaching :)
Sir, your way of teaching is amazing.
Amazing Lecture
Amazing ❤🔥
thank you for the quality course SUMIT SIR
Excited for 4th Video
You are doing an excellent work sir. Keep it up.
Thankyou Sumit Sir ! Nice tutorials 🙂
Thank you sir🙌
Most welcome
13:45 autoincrement is irrespective of primary key right ? good candidate i didnt get
🤔
Thanks sumit ! Good job 👍
Sir kar diya subscribe :)
Thank you so much sir
Great video SIr!
@Sumit Sir: If you can share the commands & class notes in the description section that would be really great.
You are the best
Thx
sir when primary key is set auto-increment for id and we have a unique key for name ..why for each wrong value for unique key ..the primary key auto increment it self? like my id=1 if i give unique key two times wrong .then 3rd time i gave correct value as per unique key..now my id=4..why not id=2 or 3 because value was not inserted in db and they were wrong as per unique key.
Hey Sumit can you pls procedures, views, and triggers
Sir can u give real life scenarios in which only Primary Key can/should be used and in situations where only Unique Key can/should be used? and thanks for the video 👍👍💖💖
Sir can you also please do the videos of plsql course please
excellent
Hello sir.....do we have a concept of composite unique key??
Hi Sumit sir, can you please help with the names of other DB's where multiple null values are not allowed for Unique Key constraint?
Sir Can we get your notes for sql series it is reallly very helpful
Hey there, kudos to your great efforts.
I have a simple enquiry as an newbie sql learner.
Why cant i have more than one primary key in a single table?
Thanks for taking care of this.
Basically its like a roll number of a student.. you can have multiple keys which can uniquely identify records, bt those keys will be candidate key.. one key among them will be chosen as primary key for the table.. And yes, a table xan only have one and only primary key.. they key can be combo of multiple columns, but ony one primary key can exist
sir combination of unique keys means the same thing as putting the unique key in from of column name?
Fall in love with learning SQL
Dont waste money on paid lectures. Trust me , this sql series is better than almost 99.9% of paid lectures.
spr
If we make the unique key as not null as well, will it behave like primary key?
Hi Sumit sir,
From where I can download notes for these seasions
When you use auto increment the structure of a table was showing thats the primary key is also active but you are using auto increment how both of them can be use at the same time.
Sir, based on below screen shot
here if ID is unique key, then does that mean records 2 and 3 are different, since Null means (we do not know the value) hence records 2 and 3 are distinct? even though they look same, but the records are unique
Please advise..
Hello Sir, Good day. Sir , You mentioned about in session 1 you will provide this notepad where you are writing . But this is the 3rd video but i am not able to find any link related about this note.
if you will provide it will very helpful for us..
Thank you Sir:)
Hi Sumit, i have started this course can you please tell shortcut to paste the code from notepad to the groomIDE workspace as ctrl+V does not work.
While explaining about unique key ,
As you said we can have one primary key
But in composite primary key you used two columns as primary key i.e
PRIMARY KEY (ID, NAME)
Then how it is possible ?
THEN
where i can find this notes
Hello Sir, Can we auto-increment Unique Keys?
yes we can have it , but no meaning to do as we do it for primary key just to ensure if we have duplicate records then also we can distingiush between them.
If unique key allow NULL values but if table definition has NOT NULL constraint then would NULL be accepted??
What is a real life example where a unique key can be used?
bt u added two primary keys in the table ? when u said we can add only 1
Sir, Auto_increment dint work alone, i had to add Primary Key to it
Why u r dropping table, can't we use alter /update table?
We can definitely use alter as seen in session 4... However Update is to update the record but not the structure.
For Auto Increment key Default it would take 1,2,.... For 1101,1102,.... how can we get this ID's in auto increment. Sumit Sir Could pls tell us ?
Insert the first record with id 1101 explicitly eg: INSERT INTO employee(id, fn, ln, age) VALUES (1101, '.....', ....... );
Then insert normally, no need to specify id in columns, it will auto-increment. eg: INSERT INTO employee(fn, ln, age) VALUES ..... ;
Where is the notepad document sir
Sumit sir ye document provide kardo please
when I create table in this format and then describe the table it shows id as primary key although I have specified it as UNIQUE KEY, if you could please tell the reason behind this..
create table employee
(
id int UNIQUE KEY AUTO_INCREMENT,
firstname varchar(20),
lastname varchar(20),
age int NOT NULL
);
if this happened because of the auto increment then what if want to use auto increment with unique key.
@@swarajkumar9550 create table employee (
id int AUTO_INCREMENT,
firstname varchar(20),
lastname varchar(20),
age int NOT NULL,
UNIQUE KEY (id)
);
Hi Sir,
Thank you very much for this video, I have a question here which others might have as well:
Primary key (FirstName,LastName) is this same as FirstName varchar(20) Primary Key,
LastName Varchar(20) PrimaryKey, will the sql editor accept the second statement? Since you said there is only one Primary key but we can have combination of 2 columns as Primary Key? Looking at the schema if there are more than 1 column with Primary key, should we say that Primary key was imposed on the combination of those columns?
Hi Aditya , have you got the answer for it, if please can you replay it! thanks
hey they are not same PRIMARY KEY(...) will work but second one will not work you can try maybe because if we give it for seperate columns, then this statement will be wrong like we can have only one primary key
I am a working professional and loved your teaching methodology. Is there a way to get the running notes you are creating during the videos? @Trendytech Insights
Hi Sumit sir, I cannot connect to your LinkedIn account. Please provide a link so that I can connect to you. I need some help so want to get in touch with you. Thanks in advance!