Please go through this top 10 SQL projects with Datasets that you can practice and can add in your resume
π1. Social Media Analytics:
(https://www.kaggle.com/amanajmera1/framingham-heart-study-dataset)
π2. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)
π3. HR Analytics:
(https://www.kaggle.com/pavansubhasht/ibm-hr-analytics-
attrition-dataset)
π4. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)
π5. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)
π6. Inventory Management:
(https://www.kaggle.com/datasets?
search=inventory+management)
π 7.Customer Relationship Management:
(https://www.kaggle.com/pankajjsh06/ibm-watson-
marketing-customer-value-data)
π8. Financial Data Analysis:
(https://www.kaggle.com/awaiskalia/banking-database)
π9. Supply Chain Management:
(https://www.kaggle.com/shashwatwork/procurement-analytics)
π10. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)
Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itβs a programming language try to make it more exciting for yourself.
Join for more: https://t.iss.one/DataPortfolio
Hope this piece of information helps you
π1. Social Media Analytics:
(https://www.kaggle.com/amanajmera1/framingham-heart-study-dataset)
π2. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)
π3. HR Analytics:
(https://www.kaggle.com/pavansubhasht/ibm-hr-analytics-
attrition-dataset)
π4. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)
π5. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)
π6. Inventory Management:
(https://www.kaggle.com/datasets?
search=inventory+management)
π 7.Customer Relationship Management:
(https://www.kaggle.com/pankajjsh06/ibm-watson-
marketing-customer-value-data)
π8. Financial Data Analysis:
(https://www.kaggle.com/awaiskalia/banking-database)
π9. Supply Chain Management:
(https://www.kaggle.com/shashwatwork/procurement-analytics)
π10. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)
Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itβs a programming language try to make it more exciting for yourself.
Join for more: https://t.iss.one/DataPortfolio
Hope this piece of information helps you
π1
βοΈ6 Tips to Study Coding EffectivelyβοΈ
by UFV Academic Success Centre
1. Donβt just read the code exampleβType it out and then create a similar one
πΉ A code sample is the representation of the idea or program.
πΉ Type it in your own words to understand how the five components are working together.
πΉ Create a similar sample to understand the abstract of the program.
πΉ Try some code challenges from some well-known websites, such as leetcode, codewars, and
topcoders.
2. Practice and keep track of what you have learned
πΉ Practice makes perfect.
πΉ As a programmer, you often can have some repetitive tasks. Keeping track of what you learn will
help you quickly refer back to the tasks you have done.
πΉ Document what you have learned. Documentation is a good resource to help you look up the
algorithm/solution and repetitive tasks easily and increase your productivity rapidly.
3. Try to create, then build your own program
πΉ Apply what you have learned to a real-life example.
πΉ Building your own program brings you to the next level of program abstract and will help you feel
satisfied and accomplished with what you have learned.
πΉ When you come up with a solution, try a different approach. There is more than one right way to
do something, and searching for different solutions will help you develop your problem solving
skills.
4. Learn how to research and solve problems
πΉ Search for topics by specific keywords.
πΉ Learn how to research your problem when you get stuck. Some websites may help, such as
stackoverflow, stackexchange, github, and forums.
πΉ If you find a solution online, make sure you understand every line of code. You will learn more this
way rather than just copying and pasting it into your project.
5. Take a break while debugging
πΉ Consider taking break to clear your mind when you encounter difficult bug.
πΉ Stepping away for a few hours will allow you to return with a fresh perspective.
6. Things to avoid
πΉ Perfection: As a beginner, improving your coding skills and problem solving are more important
than making your code perfect. Seeking perfection will cause you to procrastinate instead of
progress. Remember that mistakes are opportunities to learn.
πΉ Comparison: Never compare your code style/knowledge with anyone else. You will end up being
disappointed and demotivated. Practice and trust yourself.
πΉ Complexity: Learn how to break a problem into smaller problems, so you can conquer it more
easily.
A good programmer is able to make a program simpler and less complex. Make it work first, then
make it right, finally make it fast. βSimplicity is the ultimate sophistication,β said Leonardo Da Vinci.
by UFV Academic Success Centre
1. Donβt just read the code exampleβType it out and then create a similar one
πΉ A code sample is the representation of the idea or program.
πΉ Type it in your own words to understand how the five components are working together.
πΉ Create a similar sample to understand the abstract of the program.
πΉ Try some code challenges from some well-known websites, such as leetcode, codewars, and
topcoders.
2. Practice and keep track of what you have learned
πΉ Practice makes perfect.
πΉ As a programmer, you often can have some repetitive tasks. Keeping track of what you learn will
help you quickly refer back to the tasks you have done.
πΉ Document what you have learned. Documentation is a good resource to help you look up the
algorithm/solution and repetitive tasks easily and increase your productivity rapidly.
3. Try to create, then build your own program
πΉ Apply what you have learned to a real-life example.
πΉ Building your own program brings you to the next level of program abstract and will help you feel
satisfied and accomplished with what you have learned.
πΉ When you come up with a solution, try a different approach. There is more than one right way to
do something, and searching for different solutions will help you develop your problem solving
skills.
4. Learn how to research and solve problems
πΉ Search for topics by specific keywords.
πΉ Learn how to research your problem when you get stuck. Some websites may help, such as
stackoverflow, stackexchange, github, and forums.
πΉ If you find a solution online, make sure you understand every line of code. You will learn more this
way rather than just copying and pasting it into your project.
5. Take a break while debugging
πΉ Consider taking break to clear your mind when you encounter difficult bug.
πΉ Stepping away for a few hours will allow you to return with a fresh perspective.
6. Things to avoid
πΉ Perfection: As a beginner, improving your coding skills and problem solving are more important
than making your code perfect. Seeking perfection will cause you to procrastinate instead of
progress. Remember that mistakes are opportunities to learn.
πΉ Comparison: Never compare your code style/knowledge with anyone else. You will end up being
disappointed and demotivated. Practice and trust yourself.
πΉ Complexity: Learn how to break a problem into smaller problems, so you can conquer it more
easily.
A good programmer is able to make a program simpler and less complex. Make it work first, then
make it right, finally make it fast. βSimplicity is the ultimate sophistication,β said Leonardo Da Vinci.
π4π₯1
NumPy_SciPy_Pandas_Quandl_Cheat_Sheet.pdf
134.6 KB
Cheatsheet on Numpy and pandas for easy viewing π
ibm_machine_learning_for_dummies.pdf
1.8 MB
Short Machine Learning guide on industry applications and how itβs used to resolve problems π‘
1663243982009.pdf
349.9 KB
All SQL solutions for leetcode, good luck grinding π«£
git-cheat-sheet-education.pdf
97.8 KB
Git commands cheatsheets for anyone working on personal projects on GitHub! πΎ
π4π₯2β€1