Shakra ! Please make a dedicated video on how to use leetcode for Data Analyst Interview (Python +SQL)..how you personally used leetcode for DA Interview preparation👍Would be waiting for the video👍
Ma'am you are like saviour who wants to switch job to data analyst ❤, keep it up the hard work as you did earlier. Eagerly waiting for your next video.
Hi Shakra, I am following you on Instagram and LinkedIn. And I am learning data analysis from your channel itself. I just want to tell you this series is really helpful in the learning process. I request you to post window functions and other advance sql content.. plzz...
Just one change , in select you have to retrieve the column where you are using group by , in your example you have to retrieve department or select department and on each groups aggregate function will be applied and you will get column Min_salary.
@Shakra is this the right query?? select department_id,first_name,salary min_sal from employees where salary in(select min(salary) from employees group by department_id)order by department_id ;
As you are grouping it by employee_id so you should also select it in sub query... aggregate function and the grouping condition both should be ik select Clause
hi shakra! i am doing data cleaning project on postgres SQL. in that i want change date format, but i am unable to change this. the dataset date format is month day, year. and i want change this in dd/mm/yyyy. i am use below query but it gives error. UPDATE housing SET SaleDate = TO_CHAR(TO_DATE(SaleDate, 'Month DD, YYYY'), 'DD/MM/YYYY'); ERROR: function to_date(date, unknown) does not exist LINE 2: SET SaleDate = TO_CHAR(to_date(SaleDate, 'Month DD, YYYY'), ... ^ please help me out this.
@@ShakraShamim thanks for wonderful video. Can u advice me. If it's okay to do Google analytics certificate simultaneously or I should be first learn SQL Excel then go for Coursera certification? Thank you 😊❤️
Hlw mam today I subscribed for this chennel and thanks to more to more provide knowledgeable video s this chennel thanq mam.happy Eid mam. Can i ask something qualifications for education regarding mam
Hi shakira, agar tum sql ka course kra rhi ho na toh sirf vhi topic explain kro jo needed hai IT professional ke liye sath me project bhi explain kro end to end taki jo person tumhara video dekhe atleast tumari vjah se khi to kisi position pr jaye I like you that's why I suggest you.❤ ❤❤
Hi Shakra I am doing manual testing and want to switch in data analyst, but my designation is as test engineer in company, if i switch in data analyst is my experience will count or i need to work as fresher,actually I learnt SQL, python tableau till now and now learning PoweraBI, now I am confused, is my experience will count or not?
Shakra ! Please make a dedicated video on how to use leetcode for Data Analyst Interview (Python +SQL)..how you personally used leetcode for DA Interview preparation👍Would be waiting for the video👍
You journey is very motivating please apka ye free analytics course jaldi hi complete kare, really needed content like this.
Ye nhi karwati madam apne kaam mai hi busy rhti hai
Ma'am you are like saviour who wants to switch job to data analyst ❤, keep it up the hard work as you did earlier. Eagerly waiting for your next video.
Easiest explanation in whole TH-cam 😊
Just keep it up mam you’re seriously doing very good work for peoples who want to switch ❤☺️
Your comment made my day,, thanks
Amazing explanation... learning with ease.
Thank you ma'm.
Thanks
Maine pura vedio dekh liya bahot informative hai bahot vedio dekha par samajh me nhi aa rha tha par apka vedio samajh me aa gya❤❤❤
ye to hona hi tha
Hi Shakra,
I am following you on Instagram and LinkedIn. And I am learning data analysis from your channel itself. I just want to tell you this series is really helpful in the learning process. I request you to post window functions and other advance sql content.. plzz...
Ur tutorial is very inquisitive n beneficial .
Thank you so much for your all video ma'am
Thanks for sharing.. looking forward for more…
Thanks for watching!
Happy Birthday Shakra🥳
Thanks
Thank you for sharing you knowledge.
Glad it was helpful!
SELECT name, MIN(salary) AS min_salary
FROM employees
GROUP BY department;
Ma'am, Is my query right?
Just one change , in select you have to retrieve the column where you are using group by , in your example you have to retrieve department or select department and on each groups aggregate function will be applied and you will get column Min_salary.
Select Department, name, MIN(salary) AS Min_Salary from employees GROUP BY Department.
Ma'am is this query correct?
@Shakra is this the right query??
select department_id,first_name,salary min_sal from employees where
salary in(select min(salary) from employees group by department_id)order by department_id ;
Your where condition should be like--WHERE (department_id, salary) IN (
SELECT department_id, MIN(salary)
FROM employees
GROUP BY department_id
)
As you are grouping it by employee_id so you should also select it in sub query... aggregate function and the grouping condition both should be ik select Clause
Hello please tell me the difference between data analytics and business analytics and which one is easy
You are doing great work ❤
Thank you 🙌
So nicely teaching 😊👍
Thanks a lot 😊
Well Explained 👏🏼👏🏼
Glad you liked it
hi shakra!
i am doing data cleaning project on postgres SQL. in that i want change date format, but i am unable to change this.
the dataset date format is month day, year. and i want change this in dd/mm/yyyy.
i am use below query but it gives error.
UPDATE housing
SET SaleDate = TO_CHAR(TO_DATE(SaleDate, 'Month DD, YYYY'), 'DD/MM/YYYY');
ERROR: function to_date(date, unknown) does not exist
LINE 2: SET SaleDate = TO_CHAR(to_date(SaleDate, 'Month DD, YYYY'), ...
^
please help me out this.
In companies which database server is most use pgAdmine or mysql workbench
Bahut badhiya mam
Mujhe Hindi me basic to advance Excel shikhna hai mam kaha se shikhe
For business analytics what tools are required
mam , please make more video on SQL please
Hey Shakra.....Is data Analyst after 12th possible ??
Is Graduation degree is really necessary.....??
Great content😊
Thanks!!
Thank you!
Welcome!
Hi didi
I have just completed 12
Confused about what degree to persuve to become data analytics...
Great learning content 🙌
Glad you think so!
@@ShakraShamimI messaged you so many times but u didn't reply
@@ShakraShamim thanks for wonderful video. Can u advice me. If it's okay to do Google analytics certificate simultaneously or I should be first learn SQL Excel then go for Coursera certification? Thank you 😊❤️
Hlw mam today I subscribed for this chennel and thanks to more to more provide knowledgeable video s
this chennel thanq mam.happy Eid mam. Can i ask something qualifications for education regarding mam
SELECT name, salary from emp where salary=(select MIN(salary) from emp);
SELECT name, MIN(salary)
FROM emp
GROUP BY name;
Mam may manual testing or automation testing ka lay job search kar rahai can you given any advice plz
Hi shakira, agar tum sql ka course kra rhi ho na toh sirf vhi topic explain kro jo needed hai IT professional ke liye sath me project bhi explain kro end to end taki jo person tumhara video dekhe atleast tumari vjah se khi to kisi position pr jaye
I like you that's why I suggest you.❤ ❤❤
hlw mam , mamaap bta sakte h data analysis ka course me sab se phle kya start kare excel , sql python, power bi
Sql
Hi,
I have one question can we ask a person who work for the role of software engineer to reffer me for another role in his company
nice content
mam why are u not making more vdos
Nice
Thanks !!
Please make a video one resume for data analyst job
Yes, it will come soon
Mam apki sql ki playlist ana ku ruk gai ?
is there any hiring in data analyst job ? i tried lot but no response !!
shakra mam is there hiring in your company any other place ?
Yes now the market is again opening , so keep trying. you will get a call
maam upload next video please
data analytics course please
I think you need a thumbnail designer
Hlo maim aapse baat krni h
Select department,max(salary),min(salary) from employee group by department
Question was -
Write a query to fetch minimum salary & name of that employee, according to each department.
@@ShakraShamim select name,min(salary) from employee group by department
Mam mujhe bhi data analyst banna hai
Hi Shakra I am doing manual testing and want to switch in data analyst, but my designation is as test engineer in company, if i switch in data analyst is my experience will count or i need to work as fresher,actually I learnt SQL, python tableau till now and now learning PoweraBI, now I am confused, is my experience will count or not?
Make it relevant experience,, then u can easily switch
Hey there, is it possible to connect with you via LinkedIn?
Connect with me on instagram - user-name - shakra.shamim