Please find the updated URLs GIT HUB Download Data : github.com/datacharmer/test_db Link for query: github.com/shubhamringole/employees/tree/main
@sukhendupatra2192Ай бұрын
@@Analystmind thanks
@theinsightminer086 күн бұрын
Thanks ,your way of explaining the query was brilliant
@Analystmind6 күн бұрын
@@theinsightminer08 thank you so much ❤️
@BettyHill-t7f18 күн бұрын
Thanks shubham this the best sql project i have seen
@Analystmind18 күн бұрын
@@BettyHill-t7f thank you so much ❤️
@ShreyaKansal-bx1poАй бұрын
Much needed video, thankyou so much for sharing your knowledge🙂
@AnalystmindАй бұрын
Glad it was helpful! ☺️
@aashishsharma2936Ай бұрын
very easy way to learn sql and its working by Analyst mind
@AnalystmindАй бұрын
@@aashishsharma2936 thank allot this means allot
@user-ur8ph9lj6fАй бұрын
Sir ji please upload complete data analytics portfolio projects in SQL, Power BI and Excel for experienced professionals
@AnalystmindАй бұрын
Sure give me some time busy with new office project will surely make it more hard level .
@asp4628Ай бұрын
Sir,please do project on advance level
@AnalystmindАй бұрын
Sure give me some time we will do a heavy project
@makarsh298 күн бұрын
bhai ek question hai .. mai bhi sql project banane ka try kr rha hoo dataset toh easily mil jaate hai but business problem nhi samaz aata (am asking for questions) toh mai analysis kis pr kroo ? plz help bhai .. kaafi confusion ho rhi hai
@Analystmind8 күн бұрын
@@makarsh29 usually jo questions solve hum karte hai wohi business requirements hoti hai as a data analyst people will always ask you to get this data now it's up to you how u will get it. For that schema knowledge is required and data you are working on. If you are doing for job work on query and logic behind it that is enough
@tanushrithawkar369017 күн бұрын
Hey, wanted to start this project but I'm getting stuck in command prompt itself , in second command it says 'mysql' is not recongnized as the internal or external command , operational file or batch file. Can you please help?
@Analystmind17 күн бұрын
@@tanushrithawkar3690 It sounds like your system isn't recognizing the `mysql` command, which usually happens when the MySQL installation path isn't added to the system's PATH environment variable. Here's how you can fix it: ### 1. **Locate MySQL Installation Path** - First, find where MySQL is installed. By default, it's usually in `C:\Program Files\MySQL\MySQL Server 8.0\bin`. ### 2. **Add MySQL to the System PATH** - Right-click on "This PC" or "My Computer" and select "Properties." - Click on "Advanced system settings" on the left. - In the System Properties window, click on the "Environment Variables" button. - In the Environment Variables window, under the "System variables" section, find the "Path" variable and select it. Then, click "Edit." - In the Edit Environment Variable dialog, click "New" and paste the path to the MySQL `bin` directory (e.g., `C:\Program Files\MySQL\MySQL Server 8.0\bin`). - Click "OK" to close all windows. ### 3. **Restart Command Prompt** - Close and reopen your Command Prompt to apply the changes. ### 4. **Test MySQL Command** - Type `mysql --version` in the Command Prompt to check if MySQL is now recognized. This should resolve the issue. Let me know if you encounter any further problems!
@tanushrithawkar369016 күн бұрын
@@Analystmind Thank you, Looking forward to make it work 👍
@sweetsubha51423 күн бұрын
Thanks Shubham for this beautiful project...😊😊 Isko resume mein kaise briefly describe karen??? Advice denge pls....isko kaise mein resume re likhun project ke barein mein
@Analystmind23 күн бұрын
U can explain the steps u learn like data import how u did what insight u got from the data which new things u learn.
@bashadudeАй бұрын
Bash script for automation file on daily database maintenance table maintenance big query index explains in detail this topic .
@AnalystmindАй бұрын
@@bashadude sure will pick this in future
@Dictator-ih7ccАй бұрын
Is this good to be added into resume???
@AnalystmindАй бұрын
@@Dictator-ih7cc define the steps u perform in this project point wise which will surely impress the interviewer to show your skills.
@mggaming10615 күн бұрын
Hi Shivam. I'm getting this error while using command prompt after entering pw. please help me fix this.. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
you did not upload all the files of the employee folder on github. Plz do the changes
@AnalystmindАй бұрын
GIT HUB Download Data : github.com/datacharmer/test_db Link for query: github.com/shubhamringole/employees/tree/main
@AnalystmindАй бұрын
Thank you for noticing
@DipankarRamanАй бұрын
@@Analystmind unable to found above link github page showing error.kindly, pls upload whole data and share it after making changes.
@AnalystmindАй бұрын
@@DipankarRaman Try now
@DipankarRamanАй бұрын
@@Analystmind now working thanks
@harpalsingharmo5015Ай бұрын
Hi shubham i am following your steps, but i am getting stuck to "Load the database schema and data into MySQL" in this step again and and again after entering the password it is showing error. i know the password even though its not working could you please suggest me another method. thanks
@AnalystmindАй бұрын
Use the table data import wizard method watch my video using below link kzbin.info/www/bejne/gnuXqZ2EnpmNd5Ysi=a0OuAAIjF-r_iTsj
@AnalystmindАй бұрын
If this still not working then probably u are entering wrong password either reset the password or directly try it in MySQL console
@sketchguru7068Ай бұрын
❤❤❤
@vikisol2096Ай бұрын
Sir data analyst ki liye best laptop batao
@AnalystmindАй бұрын
Any laptop with 16 GB ram I5 processor 12 gen or greater and good graphics of 4 gb
@akankshmamidala597Ай бұрын
In 4th query, you haven't found the current managers as asked in question, instead you did for all employees who were managers of a departement at any point of time. Can you tell how to do for only current managers @Analystmind
@AnalystmindАй бұрын
Thank you for highlighting it u can use the solution below WITH RankedManagers AS ( SELECT d.dept_no, d.dept_name, e.emp_no, e.first_name, e.last_name, dm.to_date, ROW_NUMBER() OVER (PARTITION BY d.dept_no ORDER BY dm.to_date DESC) AS rn FROM departments d JOIN dept_manager dm ON d.dept_no = dm.dept_no JOIN employees e ON dm.emp_no = e.emp_no ) SELECT dept_no, dept_name, emp_no, first_name, last_name, to_date FROM RankedManagers WHERE rn = 1;
@akankshmamidala597Ай бұрын
@@Analystmind Thank you
@mohdeliyasahmed8106Ай бұрын
How to import this data in SSMS?
@AnalystmindАй бұрын
learn.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-ver16 please go through the guide for it
@harpalsingharmo5015Ай бұрын
Thanks shubham this the best sql project i have seen
@AnalystmindАй бұрын
@@harpalsingharmo5015 thank you so much means allot
@BettyHill-t7f18 күн бұрын
Thanks shubham this the best sql project i have seen