TCS SQL Real Interview BY TCS Team! TCS Interview Recording Simulation! TCS Ninja Hiring

[@naagarhive6581]

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

[@Rockstar.919]

Its good to have ppl like u on KZbin 😊

[@IfNotMe]

Thank you bro

[@SanjaySanjay-rw6lr]

Thank you

[@India_Asks]

❤ thanks

[@brownerjerry174]

Bro wrote crafted by his name as if he has written a world disrupting novel.

[@babadeepa2011]

Beautiful interview and very confident participant

[@mohdshahzad8856]

Great. The way she decribed all the things. Her presence of mind and communication was great.

[@KingJagguYT]

Its a very good interview, very informative...

[@zidhas546]

very nice interview....had an exposure of the interview environment

[@heebakouser4529]

Very useful 👌

[@piyush42962]

Excellently handled the questions.

[@mr_affan15]

Informative interview excellent ❤

[@user-wk6zv8vr4h]

Excellent and awesome performance Good one🎉

[@azharanees2333]

She is very confident. Good interview 👍

[@DeMiGodxSees]

😂I same way I can wear helmet and give interview I'm 200× more confident

[@believer-fcaeth]

​@@DeMiGodxSees Better to keep covered so as to keep her safe from THE XAPE SPECIALIST SANATAN CULT following Gobarchap lindus 😅

[@123....infinityanish2]

Excellent❤

[@imranrmd1552]

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

[@nareshnani608]

True not count null values with field count

[@consoledoterror971]

Thanks

[@hrishikeshXXV]

ustadi nhi dikhao

[@mohammadjaved4044]

Good interview and confident participant

[@trueworld3604]

Excellent👍

[@saralachattar8243]

It's very beautiful interview and so more helpful to everyone

[@naveen_maddela]

Very usefull 🎉 Very good one

[@gouravshaw6939]

wonderful interview!

[@shabbir.j.kholiya9886]

It's informative

[@syedmajidahmed8292]

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🎉 👑

[@salmanshaikh-zj1cg]

Great and confident 👍

[@ManuHere-fy5jv]

This is Helpful For So Many people Thank You For Given your experience to us 🙏❤

[@youtubveeru]

useful.. nice,good,

[@mukulhingase6575]

Excellent✌

[@smita1668]

Quite informative and helpful video.

[@prasadjoshi9368]

Must appreciate the way she is giving answers superbb👌👌

[@muskan2651]

Very informative

[@naimahmad3615]

She handled the interview very well👍👍

[@mohdshahrukh8801]

Excellent 👍

[@advocatemz3152]

Great session

[@muhammadrezaulkarim5850]

She is excellent

[@frozenlove3198]

Non Madarsachap.

[@ambrinalvi]

Excellent

[@datalover120]

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

[@muhammadaknan6023]

Primary key is minimal key which satisfied Entity integrity constraint

[@manakoi9288]

you can if it is an identity column

[@SatyarthRanjan-lt1tz]

because of this interview i got a chance to revise my sql concepts

[@nawelfardeheb5657]

very useful, thank you

[@nitinchauhan6549]

generally sql is not case senstive

[@SabinPoudel]

Yeah in terms of syntax its not case sensitive because Select and SeLect both will work.

[@shubhamroy7510]

Yes, we should care abt small letters word and capital letters word because it provides readability.

[@mahimaprasadnayak7256]

but while defining a table name it is

[@mohdshahrukh8801]

Yes is various factors are depend like MYSQL SERVER,QRACAL SERVER POSTGRA SQL and attributes name Some time Command Like or Ilike Some case it behaviour like Case sensitive And Some case it behaviour Case insensitive

[@ravishmahajan9314]

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"

[@Mahesh-rt4jg]

In depth answers!

[@mkpavankumar490]

Excellent 👌👍

[@abdulkhadar3349]

Nice

[@simplyanup9658]

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.

[@RS-3_roses]

Yes, you're correct.

[@ellenmarygeorge8130]

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.

[@krishnaRaog21]

Candidate has done very well in the interview ..Congratulations

[@wobaidurrobtareq3941]

She is so confident best wishes for her.

[@faisalchauhan6380]

the question which was asked i find it very easy becz i had sql in my previuos semester

[@askgaming99-cq6rr]

Excellent 🥰

[@souravtewari4597]

Really Very Helpful

[@animeshbiswas2754]

🎉 thank you

[@user-uc3xu4bk3t]

Very good answer ... Confidence level 👍

[@vaishnavikodag2966]

Nice interview 😊

[@MasterMinds-pk7vp]

DDL does NOT required commit, auto commit, delete can be rolled back.

[@ar_editz]

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.

[@ahlussuffiya4225]

Nice❤❤

[@Sam-ahmd]

Good

[@kandulasujith1206]

Learnt many things

[@Satya_1011]

She is well educated and great skill of communication in simple way

[@ALL_IN_ONEcanbe]

But still i have a doubt 😅... Really she is speaking or any other person from the back side.....

[@shasha_reacts]

​@@ALL_IN_ONEcanbe when we are not capable of holding good knowledge of something all we can do is judge or discriminate in every possible manner 😊 No worries you are not alone there are many with similar shitty ideology 😊

[@ALL_IN_ONEcanbe]

@@shasha_reacts i cot More than 40+ people on this case 😂😂😂 i never judging any and i have mentioned my experience here.... It should be fair to understand the situation.. on all sides and give a job to the best person.... At least the truth is best 😅😉 hope u not an dump u can understand it right... One more thing discriminate 😂😂😂😂 ho ho ho... U took more seriously on ur community... my comment in video is in general.... 2% cot in interview time and 20%cot In joining time... all thou Goes the wrong way.. ur judging others now 😭😭 so cruel 😑😑😑

[@shasha_reacts]

@@ALL_IN_ONEcanbe don't even try to be cool and act as if you are not really intended towards community 🤣🤣 bohot deke h tere jaise.....and if that's the case then everyone attending online interview can be pointed of doing any malpractices Ho ho ho you think people sitting there are so dumb and technology so outdated that they will encourage misconduct or malpractices to happen... Grow up bud ...

[@ALL_IN_ONEcanbe]

@@shasha_reacts 😂😂😂 got ur frustration... Mouth Closed with some clothes so called burkha or something else not sure name and still we can hear voice so clear 😅😅 how? Is it point less.. come on first u should grow up and .. I am not saying she is cheating here. But I only have doubts about it. hope you know the difference

[@dsdjiitian]

very useful

[@sumaiyashaikh4286]

Excellent,superb 👍

[@haariskhan5307]

in which domain you are preparing?

[@jblseng]

@@haariskhan5307AI/ML

[@meruvadharani7121]

Its a very good interview

[@chaitraram4992]

Easy n basic interview

[@laxmanbudhewad7611]

Yes too easy questions 😂

[@thariq94__]

Good For freshers

[@vivekgodse3685]

@@laxmanbudhewad7611 yes SQL is easier than programming language :)

[@shaiksajid613.]

Easy 😂😂😂

[@abdulkafeel2849]

please upload interview for cloud engineer

[@TTT-oj1mj]

Hi are you Embedded Systems engineer?

[@robmind10]

SQL is not a case sensitive language but for table name , column name, e.g it depends on case ❤

[@hiteshrs4457]

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.

[@siddheshpatil1271]

that is girl so much talented

[@_MSTHAKUR]

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)

[@saidinesh4397]

@7:50, tables,databases are not case sensitive. in sql, nothing is case sensitive.

[@suhailshaikh1771]

it is case sensitive though

[@mdamirmallick8806]

Goodd 😊

[@pandu7820]

i think in sql table names are not case sensitive

[@Par_323]

Yes

[@sandipwayase3938]

👍👌

[@wallahengineer9989]

Excellent interview 😊

[@SaiVlog_9]

Sql is cas insensitive student and Student is same

[@asceticadarsh8284]

22:21 With agg function we need to use group by function

[@dhanushreddy4367]

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.

[@prakharsrivastava6571]

select name , max(rollno) from student group by name ???

[@PreetBhanushali1234]

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 .😊😊😊😊

[@arjumandbano6590]

Rich contents

[@user-rg9kx7ibccd]

The interview is too easy and basic even for a fresher. 😂

[@StartreckTu]

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.

[@dhruvshah3974]

how do u know if who is giving interview under burqa..what nonsence is this ...

[@surajkumar8755]

Sql case sensitive??🙂

[@yeet3833]

No

[@poojakumbhar]

No

[@manakoi9288]

yes, that depends from the collation. default collation is case insensitive

[@Aman__]

SQL is case insensitive but i thing the Table name is not !

[@ALL_IN_ONEcanbe]

Yes... Queries are not case sensitive but if any call strings are case sensitive..

[@m.kirubakaran6564]

Nice👏👏👏👏👏👍👍

[@Anaskhanartist]

Awesome interview ❤

[@user-os4bq6ps8t]

Yadi ye hijab use kregi to pata kaise chalega ki kon interview de rha hai ye bahut bade level pe scam kr sakta hai ban hijab on such cases

[@mdammar]

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.

[@KA34BALLARIAN]

Excellent

[@meghasolanki747]

Nice interview 😊