I would like to give thank to entire Talentele teams for their good initiative. It will definitely help many students in preparing for their job interviews🎉🎉🎉🎉
Having clause is used with aggregate function Merge is same as JOIN And its join horizontally and not vertically For vertically we use UNION in SQL and append in power query
We can use physical column of a table to filter using where....while aggregated column we use having though aggregated column can be used in where clause but that will required sub/nested query
The candidate is undoubtedly a gem, has an exceptional SQL skills with a portfolio of over 500 independently completed assignments and completed numerous assignments in platforms like HackerRank and LeetCode. As the interview was scheduled abruptly, without prior notice, it's understandable that the candidate may have felt somewhat unprepared. Despite facing challenges, we believe in his talent and potential. However we wish him the best to continue his journey of excellence !
The candidate is undoubtedly a gem, has an exceptional SQL skill with a portfolio of over 500 independently completed assignments and completed numerous assignments in platforms like HackerRank and LeetCode. As the interview was scheduled abruptly, without prior notice, it's understandable that the candidate may have felt somewhat unprepared. Despite facing challenges, we believe in his talent and potential. However, we wish him the best to continue his journey of excellence!
@@tastetrekntravel bro understand the question first... You can't use aggregate function with where clause Select name from Xyz Where count(name) > 1 this gives an error You can use aggregate function with having clause
I am searching for the data analyst role. I am having around 2 years experience. If there is any vacancy for the analyst role, please help me so that i can give you better interview. Thank you!
In SQL, there are various types of indexes used to optimize database performance: 1. Single-Column Index: Index created on a single column to speed up retrieval based on its values. 2. Composite Index: Index on multiple columns, aiding queries involving those columns. 3. Unique Index: Enforces uniqueness of values in indexed columns, preventing duplicates. 4. Clustered Index: Determines physical order of rows in a table, based on indexed column(s). 5. Non-Clustered Index: Creates separate structure for index keys and row pointers, not affecting row order. 6. Bitmap Index: Specialized for data warehousing, storing bitmaps for each unique value for fast retrieval. 7. Function-Based Index: Based on result of function applied to column(s), speeding up queries involving the function. 8. Spatial Index: Optimizes querying of spatial data types, aiding operations like distance calculations. These index types may vary based on the specific database management system being used.
You can use aggregate functions in the WHERE clause, but the data gets filtered first, and then it's going to pass through the WHERE clause. If you want to filter data right after an aggregate function, then use the HAVING clause
Yes it is ! I have been in panel for more than a 15 years , in this question you can evaluate if the candidate has really used the function or just faking it. candidates those who have worked can confidently answer this question.
Follow my TH-cam channel for the SQL Pyspark DSA in python Oops in python Pandas scenarios based interview questions and answers preparation: youtube.com/@dewithdhairy
Why i am getting nervous by seeing this video 😂
Same here brother 😵
Yes
Tooo🙃
😂😂😂
I also
He did excellent job.... Confidently he said what he practice 👌
Yes 🙌🏻🔥
bro he did blunder .......because we cannot use aggregate func with where clause
@@Harmonic914at that moment you cannot even know what you have practiced 😊
@@TekkenGamer7 yaa but this is vary basic concept so no scope of mistake
I would like to give thank to entire Talentele teams for their good initiative. It will definitely help many students in preparing for their job interviews🎉🎉🎉🎉
Thanks a lot for your valuable feedback! 😊
Having clause is used with aggregate function
Merge is same as JOIN
And its join horizontally and not vertically
For vertically we use UNION in SQL and append in power query
He asked it in power BI, for which we use merge query to join two tables horizontally and append query to merge two tables vertically
Thanks for sharing this wonderful video
We can use physical column of a table to filter using where....while aggregated column we use having though aggregated column can be used in where clause but that will required sub/nested query
I think he did a brilliant job👍👍
Ama odia toka re...Great ❤
He seems really nervous but handling this quite well...
Yes as a beginner he is a bit nervous but conceptually strong enough ! 😊
Excellent interview 👍
Hey soumya ! Thanks 🙏🏻
Excellent interview ❤🎉
i think aggreagate functions not used with where clause for using that functions we use having clause that's the main difference
yes
Ajitesh is my friend. Proud of u bro
Thanks ra 🙌🏻
@@HollywoodPremier007got job bro?
Helpful Indeed !!! Thank you sir .
😊
Easiest sql interview ever 🙂↔️ I’ve attended zoho but they asked me to write query 😢 somehow I managed . I guess I’ll not select 😢
Don't worry bro, you'll get selected
@@DataAnalyst251rejected in technical round 🥹🤡
@Navz10 keep working hard, you'll get selected soon
@@DataAnalyst251😔😔😔😔😔😔
@@Navz10 i'M ALSO LOOKING FOR dATA JOB ONLY. ALL WE CAN DO I TRY AND WORK HARD, RESULTS ARE NOT IN OUR HAND
Itna easy interview hota hai kya. Ek mai hi hu kya i always face toughest questiom in all the interview
can you recall few tough questions which you find difficult in ur interview?
It's mock interview 😅😅 not real one , 😅
😂😂😂😂😂😂
He is definitely good at sql
Excellent 😊❤ really good video the job I am looking for
Data analytics ke job mile tho knowledge gain ho study kr tho lete hai but na training milte na jeldi job 🥲
This looks soo easy , question are to easy
Great Job
Thanks a lot 😊
It seems that he is not comfortable in sql, he needs to work hard, i wish him all the best anyways.
The candidate is undoubtedly a gem, has an exceptional SQL skills with a portfolio of over 500 independently completed assignments and completed numerous assignments in platforms like HackerRank and LeetCode. As the interview was scheduled abruptly, without prior notice, it's understandable that the candidate may have felt somewhat unprepared. Despite facing challenges, we believe in his talent and potential. However we wish him the best to continue his journey of excellence !
@@talentelelearningas he is from odisha...our main Lang is not English..so we are not comfortable in expressing our thoughts in English...
No he is good at SQL
@@madhupylahis basics are very strong
Is python required by data analyst?
I didn't receive any calls or emails from the recruiter for data analyst
Good job Shubrakant 🎉😊
Indeed ! 🎉😊
Sir can u provide experience resume for data analyst
Aggregate function not use with 'where' quary
Please currect 😊
👏
The candidate is undoubtedly a gem, has an exceptional SQL skill with a portfolio of over 500 independently completed assignments and completed numerous assignments in platforms like HackerRank and LeetCode. As the interview was scheduled abruptly, without prior notice, it's understandable that the candidate may have felt somewhat unprepared. Despite facing challenges, we believe in his talent and potential. However, we wish him the best to continue his journey of excellence!
We can use aggregate functions with a WHERE clause.
SELECT SUM(sales_amount)
FROM sales
WHERE sales_date >= '2024-01-01' AND sales_date
@@tastetrekntravel bro understand the question first...
You can't use aggregate function with where clause
Select name from Xyz
Where count(name) > 1 this gives an error
You can use aggregate function with having clause
We can use but depend on the question.
We cannot use where with aggregate functions
Is this guy placed there.?
Dmmm that's so easy questions for him 😮
woah reaalyy??damn then how hard it would be??
although he is giving interview bt it making me nervous pretty hard
Easy questions
I am looking for a Data Analyst job.
BSC physics to IT 😂😂 everyone want to IT job
Yes,You can also achive the IT JOB.
only required graduation degree in any field...
This much knowledge is enough for a DA technical interview .I mean we did not have to solve scenario base questions .I confused a lot into it.
You have to be an expert in direct and scenario based question, we have just asked basic questions to the candidate for screening.
@@talentelelearning make a video on senerieo base questions
@@shohaibameer1043 noted ! 👍🏻
I am searching for the data analyst role. I am having around 2 years experience. If there is any vacancy for the analyst role, please help me so that i can give you better interview. Thank you!
Literary bro you have no job after data analytics
You cannot use aggregate functions directly with where clause However With HAVING clause u can use it😂😂
user define function is custom function
Is he selected
Will the interview QnA be similar for someone who is trying to make a career change to data analytics and having no experience in Data Analytics?
I am searching job in Data analytics can any one help mi for this
Same here.... I have knowledge of Advance Excel, SQL and power query along with basic power bi
Did you Got job
How many types of indexes we have in sql, can anybody give the ans of this question as it was mentioned in the interview
In SQL, there are various types of indexes used to optimize database performance:
1. Single-Column Index: Index created on a single column to speed up retrieval based on its values.
2. Composite Index: Index on multiple columns, aiding queries involving those columns.
3. Unique Index: Enforces uniqueness of values in indexed columns, preventing duplicates.
4. Clustered Index: Determines physical order of rows in a table, based on indexed column(s).
5. Non-Clustered Index: Creates separate structure for index keys and row pointers, not affecting row order.
6. Bitmap Index: Specialized for data warehousing, storing bitmaps for each unique value for fast retrieval.
7. Function-Based Index: Based on result of function applied to column(s), speeding up queries involving the function.
8. Spatial Index: Optimizes querying of spatial data types, aiding operations like distance calculations.
These index types may vary based on the specific database management system being used.
@@aaryantiwari2106🎉
we cant use aggregate functions with where clause or next to where clause
You can use aggregate functions in the WHERE clause, but the data gets filtered first, and then it's going to pass through the WHERE clause. If you want to filter data right after an aggregate function, then use the HAVING clause
🎉🎉
Daya analyst bane ke liye kaunsa course karna hotha hai
In order to become a data analyst you should learn Python/R, Power BI/ Tableau/ SAS , SQL/ NoSqL and heap of other stuff mate.
Is there Any institute in Kolkata who gave Data Analyst Training and placement?
Don't get into Fake Job Guarantee Programs ! There are many such institutes who are making false promises.
@@talentelelearning any secured institution you know please suggest me
@@sayandutta_0184get in iift Kolkata
@@talentelelearning yes sir right so please tell me from where can i learn data analyst..?
Its not good habit to ask format of any function in interview, someone can ask what that function does
Yes it is ! I have been in panel for more than a 15 years , in this question you can evaluate if the candidate has really used the function or just faking it. candidates those who have worked can confidently answer this question.
bhai ye jis company m data analystt ho gya vha k beda garg ho gya hoga
Questions are so basic.
How to become data analyst with non coding background?
Learn SQL,EXCEL and POWERBI
@@DataAnalyst251 brother buy paython ka kya karege paythone bhi hai nja data analyst k liye
@@rolexx_200 Python also needed, but first perfect SQL,EXCEL and PowerBI. If you're perfect then move to python
bhai 1 year ka experience he normlization nai pata? use define function nai banaya?😑😑
bhai itta bada hogya spellings nii aati 😑
@@heh-satyam finally someone noticed the spelling mistakes 😂
@@_jatin_Vaishnav329 😑
kya iss bhai ka selection hua tha?
Yes
What is the minimum salary for freshers in india
It ranges between 3 lacs to 7lacs.
Groupby , then having.
🔥👍🏻
is this staged?
Iski mooch nakli lag rahi hai😅
Follow my TH-cam channel for the SQL Pyspark DSA in python Oops in python Pandas scenarios based interview questions and answers preparation:
youtube.com/@dewithdhairy
He needs to practice well , he doesnt know about normalisation in sql😂
Wanna give a try ? Ready for a mock interview ?
Bcoz he is from physics background and I think he skipped DBMS
SELECT SAL*12+SAL*12*0.20 HIKE
FROM EMPLOYEE
WHERE RATING= 1 ;
Like this we can write 3 separate queries.
Asking to update
@@PurushG-n6vyes
he was right using Update and case you can write a single query.