Data Analyst live Mock Interview | SQL | Power BI | Data Science - Must Watch!!
HTML-код
- Опубликовано: 2 окт 2024
- 🌟 Talentele Institute, Bhubaneswar: Your premier destination for Data Science & Analytics training!
👉 Rated No.1 in Bhubaneswar for Data Science and Analytics training with an impeccable placement record!
🏆 Proudly MSME Registered Company!
Courses Offered:
Data Analytics
Data Science
HR Data Analytics
Banking & Finance Analytics
Pharma Data Analytics
Business Analytics
Program Highlights:
👉 Comprehensive tools & program coverage: SQL, Tableau, Python, Advanced Excel & Power BI.
👉 Expertise in Data Analytics, Business Analytics, and Machine Learning techniques.
👉 Hands-on domain exposure: Marketing, Retail, Banking, Finance, HR, Sales.
👉 Real-life project-based learning with 4 industry-partnered capstone projects.
👉 Tailored resume building for enhanced job prospects.
👉 Step-by-step transition guidance by experienced professionals.
👉 Guaranteed 100% job assistance until you secure your dream job.
👉 Soft skills development: Master the art of stakeholder presentations.
👉 Mock interview sessions for real-world preparation.
🤴 Earn prestigious Data Science certificates & internship letters upon completion.
Faculty: Learn from industry experts, including Dell & Oracle employees currently serving as Data Science Managers.
For inquiries and admissions:
📞 Call or message us now: +91 7205617787
🌐 Visit our website: www.talentele.in
Unlock your potential in Data Science & Analytics with Talentele Institute!
#DataAnalytics
#DataScience
#BigData
#MachineLearning
#ArtificialIntelligence
#PredictiveAnalytics
#BusinessIntelligence
#DataMining
#DataVisualization
#AI
#Statistics
#Python
#RProgramming
#SQL
#DataDriven
#Analytics
#DeepLearning
#DataInsights
#DataEngineering
#DataAnalysis
#DataModeling
#DataPreprocessing
#DataQuality
#BusinessAnalytics
#DataManagement
#MachineLearningAlgorithms
#DataScientists
#DataStrategy
#DigitalTransformation
#IoT
#CloudComputing
#DataWarehousing
#DataIntegration
#DataSecurity
#DataGovernance
#DataLiteracy
#DataEthics
#DataInnovation
#DataCulture
#DataChallenges
#DataTrends
#DataFuturist
#DataSolutions
#DataVisualization
#DataPrivacy
#DataCollection
#DataEngineering
#DataOps
#DataTech
#DataCareer
Why i am getting nervous by seeing this video 😂
Same here brother 😵
Yes
Tooo🙃
😂😂😂
I also
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
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 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! 😊
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
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 , 😅
😂😂😂😂😂😂
Thanks for sharing this wonderful video
i think aggreagate functions not used with where clause for using that functions we use having clause that's the main difference
yes
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
He seems really nervous but handling this quite well...
Yes as a beginner he is a bit nervous but conceptually strong enough ! 😊
BSC physics to IT 😂😂 everyone want to IT job
Yes,You can also achive the IT JOB.
only required graduation degree in any field...
I think he did a brilliant job👍👍
He is definitely good at sql
Ama odia toka re...Great ❤
You cannot use aggregate functions directly with where clause However With HAVING clause u can use it😂😂
Data analytics ke job mile tho knowledge gain ho study kr tho lete hai but na training milte na jeldi job 🥲
Anderson Melissa Robinson Deborah Young Kenneth
Excellent 😊❤ really good video the job I am looking for
Excellent interview 👍
Hey soumya ! Thanks 🙏🏻
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.
Sir can u provide experience resume for data analyst
Is this guy placed there.?
We cannot use where with aggregate functions
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?
Ajitesh is my friend. Proud of u bro
Thanks ra 🙌🏻
@@HollywoodPremier007got job bro?
Follow my RUclips channel for the SQL Pyspark DSA in python Oops in python Pandas scenarios based interview questions and answers preparation:
youtube.com/@dewithdhairy
I didn't receive any calls or emails from the recruiter for data analyst
Helpful Indeed !!! Thank you sir .
😊
although he is giving interview bt it making me nervous pretty hard
I am looking for a Data Analyst job.
Easy questions
user define function is custom function
Is he selected
This looks soo easy , question are to easy
Excellent interview ❤🎉
Questions are so basic.
Iski mooch nakli lag rahi hai😅
Good job Shubrakant 🎉😊
Indeed ! 🎉😊
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
Great Job
Thanks a lot 😊
is this staged?
Dmmm that's so easy questions for him 😮
woah reaalyy??damn then how hard it would be??
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
🎉🎉
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🎉
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.
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
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 😑
bhai ye jis company m data analystt ho gya vha k beda garg ho gya hoga
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?
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.
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..?
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 ! 👍🏻
What is the minimum salary for freshers in india
It ranges between 3 lacs to 7lacs.
kya iss bhai ka selection hua tha?
Yes
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
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
@@rks_rohit680 Python also needed, but first perfect SQL,EXCEL and PowerBI. If you're perfect then move to python
Groupby , then having.
🔥👍🏻
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.