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
@@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
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.
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)
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! 👍🏻
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
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!🙌😊
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
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
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
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
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 .
This video effectively validates my knowledge of SQL and simulates the structured environment of a real interview. Thank you for sharing!
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
Nice explanation thanks you for sharing mock interview
Thank you khilesh 😊
Nice explanation Thanks for sharing mock interview
Thank you Priyanka 😊
🥰🥰
Best mock interview for freshers in SQL thank you lotus it hub😊
Thank you
@@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
@@digdeepwiththraya203 which formulas you use the most in excel
Nice .. thanks for sharing mock interview...
Thank you Ankur 😊
local and global variable was amazing question in SQL.
It is concept from transact -sql
Good practice session 👍👍
Thank you shubham 😊
Nice
Thank you Shree 😊
Nice One Which i Seen Today ❤
Thank you Bharat 😊
mayuri didi or sir ji ne mere kafi sare doubt clear ki hai Thank you Lotus Team
Very Nice interview👍👍👍
Thank you
THANK YOU A LOT SIR
Nice greate👍👍
Thank you Priyanka 😊
Nice 👍🏻👍🏻
Thank you Ranjeet 😊
Sir verry nice and helpful vedio
Thank you so much 🎉
Best class in pune
nice video for freshers she tried nicely 👌
Very useful information mock interview ❤
Thank you Kavya 😊
Very Nice ✨
Thanks ☺️
Thanks a lot. Enjoyed the Video while learning. It felt easy while learning.
Nice interview
Thank you vaishavik 😊
nice video , upload more videos lotus team...
Very Nice explanation for sharing mock interview 🤗🤗
Its avery basic interview helps for starter
@@vinodvlogs3338 thank you
Nice sir it is very useful
thank sir it was so helpful
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.
@@skchintu6172 u will not get the time to write
Very nice and helpful mock interview good explanation ,thank you Nilesh sir,
Thank you Imran 😊
She is not confident but she tried her best
Very helpful. Please make more mock interview 👍
Thank you Priya
Nice mock interview 😊👍
Thank you Bhagyshri 😊
Type of sql means commands 🤔 i thought different platforms like mysql, postgressql, amazon aurora, oracle.
Types of SQL or SQL commands or Subset of SQL
Same here😂
If this is what questions ask in interview, anyone get selected, but for knowledge purpose it great effort..appreciated 🌼
@@mukulsaini2961 thank you
Very informative video
Thank you Mayur 😊
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)
I would say no need to write every row , just copy one row and paste then just change values
I think she is passing some time by writing insert command for every row.
Thank you for sharing this mock interview it help me so much
@@pri_shortsvideo thank you
U can help us also
Nice answers
@@dailyuploads3959 thank you
Very Very nice interview Didi.
Thank you kishan 😊
Very nice interview sir ji
Thank you Abhi
खूप छान बेटा 🎉🎉🎉
Thank you pranav😊
Very nice
Thank you Mohit 😊
didnt knew sql interviews are this much easy
Good Interview
Thank you mohan 😊
@companies more tricky questions will be asked and real time scenarios based questions will be asked frequntly.
Nice Interview...
Thank you megh 😊
Bache log ki questions h😊😊
Yes
Look at her speed bro 😂
Yeahh I observed
Nice 👍
Thank you pranali 😊
nicely explain all points thanks both ........thanks for sharing the mock interview
Our pleasure!
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! 👍🏻
Thank you,will improve sure 😊
the fact is nobody want to fresher candidate at sql developer post .
Yes
Nice explanation
Good question
You are doing a great job
Plzz share salary package a candidate can get as a fresher
Like this candidate
me arts background sei hu or yei sab merei leyei just like play hai
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
Thank you for your Comment , Next Time will focus on that
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!🙌😊
Thank you tejas😊
The girl is looking more confident than the interviewer
😂😂😂
Thats easy interview questions 😅
This kind of communication is why freshers dont get a job
Very Informative Video.....But in a real interview the questions are not so straight forward
I would say no need to write every row , just copy one row and paste then just change values
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
its come by practice only
8.53 why she use again insert command, one enough to load data
My age is21 currently working, from 2 years. Till sslc i have completed.Can i start career in these fields.
Yes
Anybody please tell me the real interview for data analyst also has same these kind of basic questions?
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
Don't hide the mistakes vala part , we also make the same mistakes there will be a lesson for both of us... please
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
@@patilkartik0212Hi that is not descending it is describe to check table description.short cut we use desc tablename;
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
Why there is no semicolon after every query
Sir upload more interviews videos
Yes sure 😊 thankyou
Thank you 😊
I have 3 years of experience in SQL and LINUX I have given better interviews than this but still I am jobless
I want to give my interview to you please 🎉❤
These are just basic questions ,need to ask sub query and joins also nth highest and nth lowest salaries (co-related sub queries) ...
I did python developer course, i did civil engineering and right now I'm not getting enough opportunity. How can i get
Do More practice,give test improve communication,go more depth learn how to use linkdin for job search
canva ne ad banayi hai ya movie
I am SQL fresher where can I apply
Me pan Washim Maharashtra cha ahe ki
Kachra seth😂
Mi BSC Last year la ahe tr mi kru shkte ka IT mde carier
Yes
but are those interviews this simple? i don't think so
In 2024 any SQL jobs
Search on linkdin
Moore David Brown Jeffrey Jackson Thomas
Please any one answer my question
sir also need basic training
Thank you ashutosh 😊
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 .
Bhai tuh tension mat le woo ladki uper se dikhne m bhi thk h , woo ho jaaye gi har baar select , apni tension loo
Don't worry bro it's not your turn, wait for your turn
U just nailed it bruh 😆😆😆😆🤌🏻🤌🏻🤌🏻🤌🏻🫶🏻🫶🏻🫶🏻🫶🏻 @@nishantgautam1581
At least , she is trying 👍👍👍
Yes bro sahi bola yaar 😅@@nishantgautam1581
She need to practice more
What is the sound during 12:31? Anyone watch it?😮
Ab samajh aaya voice mute q ho raha tha legend understand easily 😂
is she selected or not
She selected or not? Answer please @lotusithub
@@GhulamAbbas-rh4nc yes
Very nice
Thank you bhagwat 😊
Nice
Thank you Rushi 😊
Very Nice
Thank you Digambar 😊