Dive Into SQL Data Analysis: Full Portfolio Project

[@Analystmind]

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

[@theinsightminer08]

Thanks ,your way of explaining the query was brilliant

[@Analystmind]

@@theinsightminer08 thank you so much ❤️

[@BettyHill-t7f]

Thanks shubham this the best sql project i have seen

[@Analystmind]

@@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

[@makarsh29]

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

[@Analystmind]

@@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

[@tanushrithawkar3690]

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?

[@Analystmind]

@@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!

[@tanushrithawkar3690]

@@Analystmind Thank you, Looking forward to make it work 👍

[@sweetsubha514]

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

[@Analystmind]

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.

[@mggaming106]

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)

[@Analystmind]

Try implementing kzbin.info/www/bejne/iZKldaiopaanpsUsi=dP-Zjlvte-s2PT3k

[@sukhendupatra2192]

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-t7f]

Thanks shubham this the best sql project i have seen

[@Analystmind]

@@BettyHill-t7f thank you so much ❤️❤️