00:03 Understanding basic concepts of databases and database management systems 02:26 SQL is a query language for database operations 07:16 Case sensitivity and constraints in SQL 09:45 Foreign key linking and CRUD operations 14:42 Difference between Drop, Delete and Truncate in SQL 16:56 Understanding SQL commands and concepts 21:01 Using aggregate functions and joining tables in SQL 23:30 Understanding Inner Joins in SQL 27:51 Interest in Development Role 30:15 Teamwork is essential for success 34:37 Utilize online tutorials and organizational resources to learn quickly. 36:46 Effective communication and learning during the managerial and technical rounds. 41:15 Importance of technology interest and communication skills 43:19 Confidence and communication skills are crucial for interview performance. 47:15 Clear concepts in English for better communication Crafted by Pradeep Naagar
21:49 select count(*) and select count(field_name) difference is select count(*) will count null values but count(fieldname) will not count null values that is difference
00:03 Understanding basic concepts of databases and database management systems 02:26 SQL is a query language for database operations 07:16 Case sensitivity and constraints in SQL 09:45 Foreign key linking and CRUD operations 14:42 Difference between Drop, Delete and Truncate in SQL 16:56 Understanding SQL commands and concepts 21:01 Using aggregate functions and joining tables in SQL 23:30 Understanding Inner Joins in SQL 27:51 Interest in Development Role 30:15 Teamwork is essential for success 34:37 Utilize online tutorials and organizational resources to learn quickly. 36:46 Effective communication and learning during the managerial and technical rounds. 41:15 Importance of technology interest and communication skills 43:19 Confidence and communication skills are crucial for interview performance. 47:15 Clear concepts in English for better communication Crafted by Merlin AI.
One of the best interview I have seen... She calmy answered all questions which such grace & confidence.... This is next level 💯 we all should master our communication skill it's extremely important..... Best of luck to her🎉 👑
@@murlidhardubey9296Mere muh se English he ni nikalti ideas bahut acche ate hai 😢😢 84% btech mai hai 6 sem tak,interview kiase nikaelga mere muh se English ni nikalti meri bahut khosis ki 😢😢
@@murlidhardubey9296 she had no problem with it then why are you bothering? what if we asked you about why you worship elephant, monkey, pig and 69+ crore others? what if we asked you about casteism, sati daha and other women treatments in your religion?
at 21:49 Count(*) will count total number of rows from a table be it null or not null where as Count (attribute_name) will count no of rows in that particular attribute(column) ignoring null rows.
But here we applied a constraint that primary key exist in table so any null record who if have primary key value not null and all other values null will be counted and if primary key is also null then we cannot add that null record as we already specified primary key not while defining table so in both cases number of records should be same what do you think
Case-Insensitive: MySQL and SQL Server (when not configured otherwise) typically treat identifiers as case-insensitive. This means that "Table1" and "table1" would be considered the same. Case-Sensitive: PostgreSQL and Oracle (when not configured otherwise) treat identifiers as case-sensitive. So "Table1" and "table1" would be considered as different.
Sql is not case sensitive but the data in tables is case sensitive. SELECT & select are same. Table name, index name all are case insensitive. But data in table columns "SQL" is different from "sql"
Mysql databases are not case sensitive...if you create a table with tablename EMPLOYEES and create another table with tablename employees .Both will be different tables.
@@magxbeats sql throws an error . a database should have an unique table_name. it doesnt create a new table if you change the case. sql stores tablenames in lower case only.
at 19:50 when we are using a temp name for a column to hide the orginal name then what if someone see's that query there you are pitting na its orginal name like (roll no as ROl)
First of all understand that the interview questions depends on the level of the candidate. For junior levels we just only need to cover the basics and they will anyways to be guided by senior developers.
The answer of the name of student with maximum marks can be done using a sub query. The answer is : Select name from student where marks =( Select max(marks) from student); Here the query inside round brackets is knows as inner query which will be executed first which will be used as a parameter for where clause for outer query. I hope this helped you .😊😊😊😊
00:03 Understanding basic concepts of databases and database management systems
02:26 SQL is a query language for database operations
07:16 Case sensitivity and constraints in SQL
09:45 Foreign key linking and CRUD operations
14:42 Difference between Drop, Delete and Truncate in SQL
16:56 Understanding SQL commands and concepts
21:01 Using aggregate functions and joining tables in SQL
23:30 Understanding Inner Joins in SQL
27:51 Interest in Development Role
30:15 Teamwork is essential for success
34:37 Utilize online tutorials and organizational resources to learn quickly.
36:46 Effective communication and learning during the managerial and technical rounds.
41:15 Importance of technology interest and communication skills
43:19 Confidence and communication skills are crucial for interview performance.
47:15 Clear concepts in English for better communication
Crafted by Pradeep Naagar
Its good to have ppl like u on TH-cam 😊
Thank you bro
Thank you
❤ thanks
Bro wrote crafted by his name as if he has written a world disrupting novel.
21:49 select count(*) and select count(field_name) difference is select count(*) will count null values but count(fieldname) will not count null values that is difference
True not count null values with field count
Thanks
ustadi nhi dikhao
Thank you man
Beautiful interview and very confident participant
because of this interview i got a chance to revise my sql concepts
But the table name is case sensitive
@@rajatrahangdale869nope wrong answer
@@rajatrahangdale869 man , its case insensitive
00:03 Understanding basic concepts of databases and database management systems
02:26 SQL is a query language for database operations
07:16 Case sensitivity and constraints in SQL
09:45 Foreign key linking and CRUD operations
14:42 Difference between Drop, Delete and Truncate in SQL
16:56 Understanding SQL commands and concepts
21:01 Using aggregate functions and joining tables in SQL
23:30 Understanding Inner Joins in SQL
27:51 Interest in Development Role
30:15 Teamwork is essential for success
34:37 Utilize online tutorials and organizational resources to learn quickly.
36:46 Effective communication and learning during the managerial and technical rounds.
41:15 Importance of technology interest and communication skills
43:19 Confidence and communication skills are crucial for interview performance.
47:15 Clear concepts in English for better communication
Crafted by Merlin AI.
Great. The way she decribed all the things. Her presence of mind and communication was great.
Database is not organisation of the structure😂,it is organised collection of data stored electronically
what kind of horrible black dress by the candidate..
Even there are many people who speak well in BPO or recruitment side 😅
Tere kom ko he toh appreciate toh karega 😂😂😂😂
Its a very good interview, very informative...
Primary key is combined of unique key & not null that means we can't leave that column blank as well as that record will be unique
Primary key is minimal key which satisfied Entity integrity constraint
14:02 The Command is used to insert the multiple columns at a time is wrong because we should not use values keywords multiple times.
Aap TCS me ho kya bro???
This is Helpful For So Many people
Thank You For Given your experience to us 🙏❤
One of the best interview I have seen...
She calmy answered all questions which such grace & confidence....
This is next level 💯 we all should master our communication skill it's extremely important.....
Best of luck to her🎉 👑
but why she is in black tent
@@murlidhardubey9296Mere muh se English he ni nikalti ideas bahut acche ate hai 😢😢 84% btech mai hai 6 sem tak,interview kiase nikaelga mere muh se English ni nikalti meri bahut khosis ki 😢😢
@@murlidhardubey9296 she had no problem with it then why are you bothering? what if we asked you about why you worship elephant, monkey, pig and 69+ crore others? what if we asked you about casteism, sati daha and other women treatments in your religion?
@@murlidhardubey9296 so that black faced people like you should not see her white beauty 🤣🤣, so much jealousy 🤣
Excellently handled the questions.
at 21:49 Count(*) will count total number of rows from a table be it null or not null where as Count (attribute_name) will count no of rows in that particular attribute(column) ignoring null rows.
But here we applied a constraint that primary key exist in table so any null record who if have primary key value not null and all other values null will be counted and if primary key is also null then we cannot add that null record as we already specified primary key not while defining table so in both cases number of records should be same what do you think
@@evilhunter662interviewer told me at the end of my interview
Good I will share your details with hr
This means?
Must appreciate the way she is giving answers superbb👌👌
Excellent and awesome performance Good one🎉
very nice interview....had an exposure of the interview environment
SQL is not a case sensitive language but for table name , column name, e.g it depends on case ❤
Case-Insensitive: MySQL and SQL Server (when not configured otherwise) typically treat identifiers as case-insensitive. This means that "Table1" and "table1" would be considered the same.
Case-Sensitive: PostgreSQL and Oracle (when not configured otherwise) treat identifiers as case-sensitive. So "Table1" and "table1" would be considered as different.
@@hiteshrs4457interviewer told me at the end of my interview
Good I will share your details with hr
This means?
generally sql is not case senstive
Yeah in terms of syntax its not case sensitive because Select and SeLect both will work.
Yes, we should care abt small letters word and capital letters word because it provides readability.
but while defining a table name it is
Sql is not case sensitive but the data in tables is case sensitive.
SELECT & select are same.
Table name, index name all are case insensitive.
But data in table columns "SQL" is different from "sql"
Correct so it will not create a new table it will give an error that the table already exists
SQL isn't case sensitive. When you try to to create another table with name of any case of existing table name, it won't create.
Yes, you're correct.
Mysql databases are not case sensitive...if you create a table with tablename EMPLOYEES and create another table with tablename employees .Both will be different tables.
Basic logic...u cannt give same name to multiple tables...irrespective of case sensitive
It's very beautiful interview and so more helpful to everyone
Candidate has done very well in the interview ..Congratulations
You should also learn sql
what kind of horrible black dress by the candidate..
@@abhishekchauhan2601interviewer told me at the end of my interview
Good I will share your details with hr
This means?
Very usefull 🎉
Very good one
Quite informative and helpful video.
She is so confident best wishes for her.
Very useful 👌
the question which was asked i find it very easy becz i had sql in my previuos semester
having in semester is completetly different when it comes to nterview i hope you understand it when you face the inrerview
Good interview and confident participant
It's informative
She is excellent
Non Madarsachap.
Informative interview excellent ❤
Excellent👍
Very informative interview and useful for freshers and experience person's
Excellent❤
She handled the interview very well👍👍
wonderful interview!
Very confident candidate
@7:50, tables,databases are not case sensitive. in sql, nothing is case sensitive.
it is case sensitive though
Create table Student & student as table name will create 2 different table man it's case sensitive as for queries it's not case sensitive
@@magxbeats sql throws an error . a database should have an unique table_name. it doesnt create a new table if you change the case. sql stores tablenames in lower case only.
Not sure about other but in Postgres it is case sensitive.
i think in sql table names are not case sensitive
Yes
DDL does NOT required commit, auto commit, delete can be rolled back.
DDL is mostly auto commit ,but is configurable in some databases.
Yes you said the answer ddl commands like create alter drop truncate rename once used these commands fetched the data auto commit.
She is very confident. Good interview 😊💯👍
at 19:50 when we are using a temp name for a column to hide the orginal name then what if someone see's that query there you are pitting na its orginal name like (roll no as ROl)
Output Table won't have the original column name, but If u want to hide it from developer than DBA can use views to create an abstraction.
Very informative
Excellent 👌
Great session
22:21 With agg function we need to use group by function
Yes. But it is not mandatory. When the query is simple there is no need to use aggregate function. It all depends on the condition.
please upload interview for cloud engineer
Hi are you Embedded Systems engineer?
useful.. nice,good,
Excellent 👌👍
0:50 - Database Management Q
1:32 - RDBMS
2:55 - What is SQL
5:18 - Create Table
10:58 - Select Query
ITS WAS INFORMETIVE
Great and confident 👍
very useful, thank you
Useful
Really Very Helpful
In depth answers!
Very good answer ... Confidence level 👍
🎉 thank you
Nice interview 😊
Excellent,superb 👍
in which domain you are preparing?
@@haariskhan5307AI/ML
The interview is too easy and basic even for a fresher. 😂
First of all understand that the interview questions depends on the level of the candidate. For junior levels we just only need to cover the basics and they will anyways to be guided by senior developers.
Excellent 🥰
Nice👏👏👏👏👏👍👍
Easy n basic interview
Yes too easy questions 😂
Good For freshers
@@laxmanbudhewad7611 yes SQL is easier than programming language :)
Easy 😂😂😂
Very useful
select name , max(rollno) from student
group by name ???
The answer of the name of student with maximum marks can be done using a sub query.
The answer is :
Select
name
from
student
where marks =(
Select max(marks) from student);
Here the query inside round brackets is knows as inner query which will be executed first which will be used as a parameter for where clause for outer query.
I hope this helped you .😊😊😊😊
Great
SQL is not case sensitive
Its a very good interview
Nice❤❤
that is girl so much talented
Nice
Sql is cas insensitive student and Student is same
very useful
this is good
Excellent interview 😊
Excellent
Learnt many things
Sql case sensitive??🙂
No
No
yes, that depends from the collation. default collation is case insensitive
SQL is case insensitive but i thing the Table name is not !
Yes... Queries are not case sensitive but if any call strings are case sensitive..
Good
Goodd 😊
👍👌
Rich contents
Best interview confidence 🫡
Awesome interview ❤
Too good ❤
Something might be hidden inside burqa😂😂😂
Excellent✌
Nice interview 😊
Excellent