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
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"
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.
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)
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 .😊😊😊😊
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.
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.
because of this interview i got a chance to revise my sql concepts
But the table name is case sensitive
@@rajatrahangdale869nope wrong answer
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
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.
Beautiful interview and very confident participant
Its a very good interview, very informative...
This is Helpful For So Many people
Thank You For Given your experience to us 🙏❤
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 😂😂😂😂
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?
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
Excellently handled the questions.
Must appreciate the way she is giving answers superbb👌👌
Excellent and awesome performance Good one🎉
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?
very nice interview....had an exposure of the interview environment
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???
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 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?
It's very beautiful interview and so more helpful to everyone
Very usefull 🎉
Very good one
Quite informative and helpful video.
Informative interview excellent ❤
Very useful 👌
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
She is so confident best wishes for her.
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?
It's informative
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
@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.
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.
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.
She is excellent
Non Madarsachap.
Excellent 👌
Excellent👍
Very confident candidate
Excellent❤
very useful, thank you
wonderful interview!
Very informative
She handled the interview very well👍👍
i think in sql table names are not case sensitive
Yes
She is very confident. Good interview 😊💯👍
Great session
🎉 thank you
Great and confident 👍
Excellent 👌👍
Excellent,superb 👍
in which domain you are preparing?
@@haariskhan5307AI/ML
ITS WAS INFORMETIVE
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.
Useful
useful.. nice,good,
In depth answers!
0:50 - Database Management Q
1:32 - RDBMS
2:55 - What is SQL
5:18 - Create Table
10:58 - Select Query
please upload interview for cloud engineer
Hi are you Embedded Systems engineer?
Easy n basic interview
Yes too easy questions 😂
Good For freshers
@@laxmanbudhewad7611 yes SQL is easier than programming language :)
Easy 😂😂😂
Great
Nice👏👏👏👏👏👍👍
Nice interview 😊
Very useful
Excellent 🥰
Very good answer ... Confidence level 👍
Nice❤❤
Really Very Helpful
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 .😊😊😊😊
that is girl so much talented
Its a very good interview
very useful
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.
Nice
this is good
Learnt many things
Excellent interview 😊
Goodd 😊
Excellent
Good
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..
Sql is cas insensitive student and Student is same
👍👌
SQL is not case sensitive
Rich contents
Best interview confidence 🫡
Awesome interview ❤
Excellent✌
Nice interview 😊
Excellent