SQL interview Questions and Answers | Frequently asked SQL interview questions | Sql Mock Interview

  Рет қаралды 205,618

Lotus IT Hub training institute

Lotus IT Hub training institute

Күн бұрын

Пікірлер: 159
@Shivamishra16
@Shivamishra16 5 ай бұрын
This video effectively validates my knowledge of SQL and simulates the structured environment of a real interview. Thank you for sharing!
@digdeepwiththraya203
@digdeepwiththraya203 17 күн бұрын
Excuse me sir, am not fresher for data analyst I have 6yr experience but, am new for SQL cuz I managed company database only by using Excel and pivot tables .... So, can I get job if I update my CV with SQL
@khileshpatil3081
@khileshpatil3081 9 ай бұрын
Nice explanation thanks you for sharing mock interview
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you khilesh 😊
@priyankavishwakarma8341
@priyankavishwakarma8341 9 ай бұрын
Nice explanation Thanks for sharing mock interview
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Priyanka 😊
@KumarRaj_01
@KumarRaj_01 4 ай бұрын
🥰🥰
@ruchitiwari5613
@ruchitiwari5613 9 ай бұрын
Best mock interview for freshers in SQL thank you lotus it hub😊
@LotusITHub
@LotusITHub 7 ай бұрын
Thank you
@digdeepwiththraya203
@digdeepwiththraya203 17 күн бұрын
​@@LotusITHub excuse me, an not fresher for data analyst I have 6yr experience, but am new for SQL cuz I managed company database only by excel and pivot tables , so if I update my CV by adding sql ...can i get job I mean have priority
@tanujsingh702
@tanujsingh702 4 күн бұрын
​@@digdeepwiththraya203 which formulas you use the most in excel
@ankurrakhroy1278
@ankurrakhroy1278 9 ай бұрын
Nice .. thanks for sharing mock interview...
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Ankur 😊
@Shree_Kadarge
@Shree_Kadarge 9 ай бұрын
Nice
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Shree 😊
@Jafilkhan.
@Jafilkhan. 3 ай бұрын
local and global variable was amazing question in SQL.
@sameersawal28
@sameersawal28 24 күн бұрын
It is concept from transact -sql
@ShubhamPatil-vp4wl
@ShubhamPatil-vp4wl 8 ай бұрын
Good practice session 👍👍
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you shubham 😊
@Suhail_lala_2.0
@Suhail_lala_2.0 3 ай бұрын
mayuri didi or sir ji ne mere kafi sare doubt clear ki hai Thank you Lotus Team
@vashvikjamalta2542
@vashvikjamalta2542 9 ай бұрын
Nice interview
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you vaishavik 😊
@bharathyadav3103
@bharathyadav3103 9 ай бұрын
Nice One Which i Seen Today ❤
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Bharat 😊
@manishascorner5443
@manishascorner5443 4 күн бұрын
She is not confident but she tried her best
@ranjeettharkude1281
@ranjeettharkude1281 9 ай бұрын
Nice 👍🏻👍🏻
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Ranjeet 😊
@PRIYANKAMALI-yu2qy
@PRIYANKAMALI-yu2qy 9 ай бұрын
Nice greate👍👍
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Priyanka 😊
@fattuguyzz.123
@fattuguyzz.123 8 ай бұрын
Very Nice interview👍👍👍
@LotusITHub
@LotusITHub 7 ай бұрын
Thank you
@Prateekvlog817
@Prateekvlog817 15 күн бұрын
THANK YOU A LOT SIR
@jafarullahansari6787
@jafarullahansari6787 4 ай бұрын
INSERT INTO customer (CustID, CustName, Age, City, Salary) VALUES (1, 'Sam', 26, 'Delhi', 9000), (2, 'Ram', 19, 'Bangalore', 11000), (3, 'Pam', 31, 'Mumbai', 6000), (4, 'Jam', 42, 'Pune', 10000); no need to write insert into for every rows u can write this method (for insert values)
@iamzb3006
@iamzb3006 3 ай бұрын
I would say no need to write every row , just copy one row and paste then just change values
@sameersawal28
@sameersawal28 24 күн бұрын
I think she is passing some time by writing insert command for every row.
@imranshaikh2140
@imranshaikh2140 9 ай бұрын
Very nice and helpful mock interview good explanation ,thank you Nilesh sir,
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Imran 😊
@vinodvlogs3338
@vinodvlogs3338 8 күн бұрын
Its avery basic interview helps for starter
@LotusITHub
@LotusITHub 8 күн бұрын
@@vinodvlogs3338 thank you
@Savita_94
@Savita_94 4 ай бұрын
Sir verry nice and helpful vedio Thank you so much 🎉
@thebesttechnical3608
@thebesttechnical3608 27 күн бұрын
Thanks a lot. Enjoyed the Video while learning. It felt easy while learning.
@samwarriorgaming341
@samwarriorgaming341 9 ай бұрын
Very Nice ✨
@LotusITHub
@LotusITHub 7 ай бұрын
Thanks ☺️
@anjaneyulukollipara699
@anjaneyulukollipara699 4 ай бұрын
nice video , upload more videos lotus team...
@meghgholap
@meghgholap 9 ай бұрын
Nice Interview...
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you megh 😊
@JiminPark-dt4lz
@JiminPark-dt4lz 6 ай бұрын
Best class in pune
@goldeerajput4943
@goldeerajput4943 5 ай бұрын
Very Nice explanation for sharing mock interview 🤗🤗
@haricreations5979
@haricreations5979 2 ай бұрын
Nice sir it is very useful
@skchintu6172
@skchintu6172 4 ай бұрын
Make a note guys: while giving any questions by recruiter. Don't ask can you repeat once again like Instead of asking that , using comment write the question when he saying.
@vinodvlogs3338
@vinodvlogs3338 8 күн бұрын
@@skchintu6172 u will not get the time to write
@kavyasamazingworld8912
@kavyasamazingworld8912 8 ай бұрын
Very useful information mock interview ❤
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Kavya 😊
@priyapuranik5080
@priyapuranik5080 7 ай бұрын
Very helpful. Please make more mock interview 👍
@LotusITHub
@LotusITHub 7 ай бұрын
Thank you Priya
@patilkartik0212
@patilkartik0212 5 ай бұрын
nice video for freshers she tried nicely 👌
@vannevijay4006
@vannevijay4006 5 ай бұрын
Type of sql means commands 🤔 i thought different platforms like mysql, postgressql, amazon aurora, oracle.
@altafshaikh12899
@altafshaikh12899 4 ай бұрын
Types of SQL or SQL commands or Subset of SQL
@behindthescenesreality9368
@behindthescenesreality9368 4 ай бұрын
Same here😂
@Shrisairam-d4z
@Shrisairam-d4z 8 ай бұрын
Nice mock interview 😊👍
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Bhagyshri 😊
@mukulsaini2961
@mukulsaini2961 3 ай бұрын
If this is what questions ask in interview, anyone get selected, but for knowledge purpose it great effort..appreciated 🌼
@LotusITHub
@LotusITHub 3 ай бұрын
@@mukulsaini2961 thank you
@Mohit-sp8kh
@Mohit-sp8kh 8 ай бұрын
Very nice
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Mohit 😊
@MayurchiPrarthana
@MayurchiPrarthana 8 ай бұрын
Very informative video
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Mayur 😊
@manishascorner5443
@manishascorner5443 4 күн бұрын
Look at her speed bro 😂
@musicalband_
@musicalband_ Сағат бұрын
Yeahh I observed
@RajuKumar-un1gf
@RajuKumar-un1gf 4 ай бұрын
the fact is nobody want to fresher candidate at sql developer post .
@ramakrishnajalika5451
@ramakrishnajalika5451 29 күн бұрын
Yes
@iamzb3006
@iamzb3006 4 ай бұрын
thank sir it was so helpful
@pri_shortsvideo
@pri_shortsvideo 5 ай бұрын
Thank you for sharing this mock interview it help me so much
@LotusITHub
@LotusITHub 5 ай бұрын
@@pri_shortsvideo thank you
@faizanchoudhary6439
@faizanchoudhary6439 4 ай бұрын
U can help us also
@mohansutar4147
@mohansutar4147 8 ай бұрын
Good Interview
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you mohan 😊
@dailyuploads3959
@dailyuploads3959 5 ай бұрын
Nice answers
@LotusITHub
@LotusITHub 5 ай бұрын
@@dailyuploads3959 thank you
@Aanand.
@Aanand. 4 ай бұрын
didnt knew sql interviews are this much easy
@ManishKumar-g3t1o
@ManishKumar-g3t1o 5 ай бұрын
me arts background sei hu or yei sab merei leyei just like play hai
@abhiblog29
@abhiblog29 7 ай бұрын
Very nice interview sir ji
@LotusITHub
@LotusITHub 7 ай бұрын
Thank you Abhi
@vasuD-e7h
@vasuD-e7h 3 ай бұрын
@companies more tricky questions will be asked and real time scenarios based questions will be asked frequntly.
@kisansabale8316
@kisansabale8316 8 ай бұрын
Very Very nice interview Didi.
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you kishan 😊
@pranavborkar5327
@pranavborkar5327 8 ай бұрын
खूप छान बेटा 🎉🎉🎉
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you pranav😊
@Shiv_Garjana_official
@Shiv_Garjana_official 7 ай бұрын
This is good that you are sharing videos like this but please focus on the mistakes of the candidate and try to cut that part from the video as fresher will consider that wrong answer as a right and it will mislead the viewer
@LotusITHub
@LotusITHub 7 ай бұрын
Thank you for your Comment , Next Time will focus on that
@pranalidawale6951
@pranalidawale6951 8 ай бұрын
Nice 👍
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you pranali 😊
@judhistirabehera102
@judhistirabehera102 3 ай бұрын
Bache log ki questions h😊😊
@nayaknirakar301
@nayaknirakar301 2 ай бұрын
Yes
@legend_ns
@legend_ns 6 ай бұрын
She is good, it's just that she needs to improve her query readability a bit. Also it's a good practice to highlight the functions and statements with capital letters. And yeah it's comes from practice only. Well done! 👍🏻
@LotusITHub
@LotusITHub 6 ай бұрын
Thank you,will improve sure 😊
@juhichaubey4735
@juhichaubey4735 4 ай бұрын
nicely explain all points thanks both ........thanks for sharing the mock interview
@LotusITHub
@LotusITHub 4 ай бұрын
Our pleasure!
@tejasmohite748
@tejasmohite748 9 ай бұрын
I think It's a good way to practice for the mock interview. Thank you so much for uploading this kind of video sir👍🙌 Good interview! It will help people to overcome fear of interview! One of the best interview video seen in recent days!🙌😊
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you tejas😊
@Ajith_Aji13
@Ajith_Aji13 4 ай бұрын
Thats easy interview questions 😅
@Cuts-tube
@Cuts-tube 5 ай бұрын
The girl is looking more confident than the interviewer
@gireeshsagar4973
@gireeshsagar4973 4 ай бұрын
😂😂😂
@ishanksaxena3329
@ishanksaxena3329 3 ай бұрын
This kind of communication is why freshers dont get a job
@Lafzzz...
@Lafzzz... 5 ай бұрын
Nice explanation Good question You are doing a great job Plzz share salary package a candidate can get as a fresher Like this candidate
@anshumehta7606
@anshumehta7606 4 ай бұрын
its come by practice only
@ninaddanane9459
@ninaddanane9459 2 ай бұрын
Very Informative Video.....But in a real interview the questions are not so straight forward
@musicalband_
@musicalband_ Сағат бұрын
8.53 why she use again insert command, one enough to load data
@triggu6826
@triggu6826 4 ай бұрын
canva ne ad banayi hai ya movie
@searchpastvideos
@searchpastvideos 3 күн бұрын
Anybody please tell me the real interview for data analyst also has same these kind of basic questions?
@lakkudawargave
@lakkudawargave 8 ай бұрын
Sir upload more interviews videos
@LotusITHub
@LotusITHub 8 ай бұрын
Yes sure 😊 thankyou
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you 😊
@nabeelamjad1129
@nabeelamjad1129 18 күн бұрын
Why there is no semicolon after every query
@hyd-d4y
@hyd-d4y 4 ай бұрын
My age is21 currently working, from 2 years. Till sslc i have completed.Can i start career in these fields.
@tanujavlog6839
@tanujavlog6839 2 ай бұрын
Yes
@dhruvaldalwadi5985
@dhruvaldalwadi5985 5 ай бұрын
Don't hide the mistakes vala part , we also make the same mistakes there will be a lesson for both of us... please
@patilkartik0212
@patilkartik0212 5 ай бұрын
bcz they dnt say wrong sometime ...for deleted table they use show databases but she shows it is desc descending order is it correct i m also new learner
@Hemas_World984
@Hemas_World984 4 ай бұрын
​@@patilkartik0212Hi that is not descending it is describe to check table description.short cut we use desc tablename;
@educateus85
@educateus85 5 ай бұрын
I did python developer course, i did civil engineering and right now I'm not getting enough opportunity. How can i get
@LotusITHub
@LotusITHub 5 ай бұрын
Do More practice,give test improve communication,go more depth learn how to use linkdin for job search
@vivekpatil3631
@vivekpatil3631 5 ай бұрын
Me pan Washim Maharashtra cha ahe ki
@fariduddinkhan5203
@fariduddinkhan5203 15 күн бұрын
I have 3 years of experience in SQL and LINUX I have given better interviews than this but still I am jobless
@Rabbani_World_Flock
@Rabbani_World_Flock 5 ай бұрын
I want to give my interview to you please 🎉❤
@Starshorts_2002
@Starshorts_2002 4 ай бұрын
I am SQL fresher where can I apply
@TheUntoldFacts01
@TheUntoldFacts01 4 ай бұрын
everything is good but some nervousness during the interview need to improve it this is a mock interview and i am 100% sure this candidate if given any real interview so she can’t speak properly so please improve it …!!! by the way thanks for this video
@priyankahiwale3235
@priyankahiwale3235 5 ай бұрын
Mi BSC Last year la ahe tr mi kru shkte ka IT mde carier
@tanujavlog6839
@tanujavlog6839 2 ай бұрын
Yes
@chutifun99
@chutifun99 3 ай бұрын
As someone with 5+ years into the industry, I cannot emphasise more on how important is communication skills. As a BA your core job is to communicate results and ideas to stakeholders which requires solid communication skills as well
@iamzb3006
@iamzb3006 3 ай бұрын
I would say no need to write every row , just copy one row and paste then just change values
@wrushabhkamde119
@wrushabhkamde119 6 ай бұрын
Kachra seth😂
@neelshinde1677
@neelshinde1677 Ай бұрын
but are those interviews this simple? i don't think so
@rohinilakshmi81
@rohinilakshmi81 3 ай бұрын
In 2024 any SQL jobs
@azqamubeen3934
@azqamubeen3934 2 ай бұрын
Search on linkdin
@rohinilakshmi81
@rohinilakshmi81 3 ай бұрын
Please any one answer my question
@ashutoshlahase6607
@ashutoshlahase6607 7 ай бұрын
sir also need basic training
@LotusITHub
@LotusITHub 7 ай бұрын
Thank you ashutosh 😊
@PhilemonMortimer-q6o
@PhilemonMortimer-q6o 2 ай бұрын
Moore David Brown Jeffrey Jackson Thomas
@inzirajput6174
@inzirajput6174 3 ай бұрын
He asked what r diffrnt types of joins and she answered the definition of joins 😁 after that she answered types of joins If he asked dffrnt typs of joins she can directly give the diffrnt types of joins are left,right,inner, full joins
@vasuD-e7h
@vasuD-e7h 3 ай бұрын
These are just basic questions ,need to ask sub query and joins also nth highest and nth lowest salaries (co-related sub queries) ...
@user-is7is7yk5h
@user-is7is7yk5h 4 ай бұрын
She need to practice more
@altafshaikh12899
@altafshaikh12899 4 ай бұрын
she was not confident in every question and her language of answering was also not good if you give an interview like this you will never get selected for second round .
@nishantgautam1581
@nishantgautam1581 4 ай бұрын
Bhai tuh tension mat le woo ladki uper se dikhne m bhi thk h , woo ho jaaye gi har baar select , apni tension loo
@NitinKumar-vw9gb
@NitinKumar-vw9gb 4 ай бұрын
Don't worry bro it's not your turn, wait for your turn
@SHUBHAMJADHAV-lo5kb
@SHUBHAMJADHAV-lo5kb 2 ай бұрын
U just nailed it bruh 😆😆😆😆🤌🏻🤌🏻🤌🏻🤌🏻🫶🏻🫶🏻🫶🏻🫶🏻 ​@@nishantgautam1581
@AjayKumar-wc3ml
@AjayKumar-wc3ml 2 ай бұрын
At least , she is trying 👍👍👍
@AnirudhSingh-y8q
@AnirudhSingh-y8q 25 күн бұрын
Yes bro sahi bola yaar 😅​@@nishantgautam1581
@User-y5p1g
@User-y5p1g 3 ай бұрын
What is the sound during 12:31? Anyone watch it?😮
@Genius_facts_yt
@Genius_facts_yt 17 күн бұрын
Ab samajh aaya voice mute q ho raha tha legend understand easily 😂
@pokeguyff4569
@pokeguyff4569 5 ай бұрын
is she selected or not
@GhulamAbbas-rh4nc
@GhulamAbbas-rh4nc 4 ай бұрын
She selected or not? Answer please @lotusithub
@LotusITHub
@LotusITHub 4 ай бұрын
@@GhulamAbbas-rh4nc yes
@bhagwatborkar-zx2sc
@bhagwatborkar-zx2sc 8 ай бұрын
Very nice
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you bhagwat 😊
@Rushi_Mohale
@Rushi_Mohale 8 ай бұрын
Nice
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Rushi 😊
@digambarshinde4788
@digambarshinde4788 8 ай бұрын
Very Nice
@LotusITHub
@LotusITHub 8 ай бұрын
Thank you Digambar 😊
Fresher Mock Interview SQL | Technical Round | SQL Interview for Fresher | HR Interview
14:50
Lotus IT Hub training institute
Рет қаралды 108 М.
The 25 SQL Questions You MUST Know for Data Analyst Interviews
32:47
KSR Datavizon
Рет қаралды 250 М.
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН
MySQL Full Course for free 🐬
3:00:00
Bro Code
Рет қаралды 2,2 МЛН
Roadmap for Learning SQL
4:52
ByteByteGo
Рет қаралды 509 М.
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН