TCS SQL Real Interview BY TCS Team! TCS Interview Recording Simulation! TCS Ninja Hiring
Вставка
- Опубліковано 25 лис 2024
- TCS SQL Real Interview BY TCS Team! TCS Interview Recording Simulation! TCS Ninja Hiring
TCS interview questions, TCS interview questions for freshers 2024, TCS interview process for experienced, TCS SQL interview,
TCS SQL interview questions,
TCS SQL server dba interview questions and answers for experienced,
TCS SQL, TCS Interview Process,
TCS PL SQL, TCS interview for freshers
TCS interview for freshers in Tamil,
TCS interview for freshers 2024,
TCS interview process,
This Video Is only for educational Purposes Not any other Aim. If you Have any Queries contact us - at codiminati@gmail.com
Disclaimer-
This video is only for education purpose for help the student who is not aware about interview .This is a Mock Interview that was conducted by TCS so student and fresher can understand how interview is done in a BIG tech companies. So any person have any issue you can contact me I will delete video.
contact- codiminati@gmail.com
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 UA-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
Beautiful interview and very confident participant
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
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 😅
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
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 😢😢
This is Helpful For So Many people
Thank You For Given your experience to us 🙏❤
Its a very good interview, very informative...
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.
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.
Must appreciate the way she is giving answers superbb👌👌
Excellently handled the questions.
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???
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
Excellent and awesome performance Good one🎉
She is so confident best wishes for her.
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
very nice interview....had an exposure of the interview environment
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
It's very beautiful interview and so more helpful to everyone
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
Very useful 👌
Candidate has done very well in the interview ..Congratulations
You should also learn sql
what kind of horrible black dress by the candidate..
Very usefull 🎉
Very good one
Quite informative and helpful video.
Informative interview excellent ❤
It's informative
i think in sql table names are not case sensitive
Yes
Good interview and confident participant
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.
Excellent❤
She is excellent
Non Madarsachap.
Excellent👍
Excellent 👌
0:50 - Database Management Q
1:32 - RDBMS
2:55 - What is SQL
5:18 - Create Table
10:58 - Select Query
Very informative
wonderful interview!
Very confident candidate
She handled the interview very well👍👍
Great session
Excellent 👌👍
very useful, thank you
Useful
useful.. nice,good,
please upload interview for cloud engineer
Hi are you Embedded Systems engineer?
She is very confident. Good interview 😊💯👍
Great and confident 👍
ITS WAS INFORMETIVE
@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.
🎉 thank you
In depth answers!
Great
Very useful
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.
Easy n basic interview
Yes too easy questions 😂
Good For freshers
@@laxmanbudhewad7611 yes SQL is easier than programming language :)
Easy 😂😂😂
Excellent 🥰
Really Very Helpful
Nice interview 😊
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.
Nice👏👏👏👏👏👍👍
this is good
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.
Nice
that is girl so much talented
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 .😊😊😊😊
Best interview confidence 🫡
Nice❤❤
Learnt many things
Its a very good interview
Good
Excellent
Very good answer ... Confidence level 👍
Sql is cas insensitive student and Student is same
Goodd 😊
SQL is not case sensitive
Excellent interview 😊
👍👌
Rich contents
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..
Awesome interview ❤
Excellent✌
Excellent
Nice interview 😊