ExcelVBANotesForProfessionals.pdf

@Allcodingsolution

SQLNotesForProfessionals.pdf

@Allcodingsolution

♨️ IBM INTERVIEW EXPERIENCE

Technical Round:

1) They Ask Some Basic Java Questions.

HR Round:

1) Tell Me About YourSelf.
2) Why IBM?
3) About IBM?
4) Hobbies?
5) Where Do You See YourSelf In The
Next Five Years?
6) Why Should I Hire You?

✅ Note: Be Confident & Don't Be
Nervous. Be Clear & Tharow
With Resume Because Most Of
The Qsn Are Rised From IT.

Telegram:- @Allcodingsolution

Websites to practice frontend skills:

1. Frontend Mentor
frontendmentor.io

2. Codewars
codewars.com

3. Codewell
codewell.cc

4. JavaScript30
javascript30.com

5. Coderbyte
coderbyte.com

6. CSS Battle
cssbattle.dev

7. FreeCodeCamp
freecodecamp.org/learn/

8. Frontend Practice
frontendpractice.com

9. CodePen Challenges
codepen.io/challenges/?re

10. Dev Challenges
devchallenges.io

If I were to start Computer Science in 2023,

- Harvard - Stanford
- MIT - IBM
- Microsoft - Google

❯ CS50 from Harvard
http://cs50.harvard.edu/x/2023/certificate/

❯ C/C++http://ocw.mit.edu/courses/6-s096-effective-programming-in-c-and-c-january-iap-2014/

❯ Python
http://cs50.harvard.edu/python/2022/

❯ SQLhttp://online.stanford.edu/courses/soe-ydatabases0005-databases-relational-databases-and-sql

❯ DSA
http://techdevguide.withgoogle.com/paths/data-structures-and-algorithms/

❯ Javahttp://learn.microsoft.com/shows/java-for-beginners/


❯ JavaScripthttp://learn.microsoft.com/training/paths/web-development-101/

❯ TypeScript
http://learn.microsoft.com/training/paths/build-javascript-applications-typescript/

❯ C#http://learn.microsoft.com/users/dotnet/collections/yz26f8y64n7k07


❯ Mathematics (incl. Statistics)ocw.mit.edu/search/?d=Mathematics&s=department_course_numbers.sort_coursenum

❯ Data Science
cognitiveclass.ai/courses/data-science-101

❯ Machine Learninghttp://developers.google.com/machine-learning/crash-course

❯ Deep Learning
introtodeeplearning.com

❯ Full Stack Web (HTML/CSS)pll.harvard.edu/course/cs50s-web-programming-python-and-javascript/2023-05

❯ OS, Networking
ocw.mit.edu/courses/6-033-computer-system-engineering-spring-2018/

❯ Compiler Designonline.stanford.edu/courses/soe-ycscs1-compilers

𝐅𝐫𝐞𝐞 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬 𝐭𝐨 𝐚𝐝𝐝 𝐭𝐨 𝐲𝐨𝐮𝐫 𝐑𝐞𝐬𝐮𝐦𝐞 𝐢𝐧 𝟐𝟎𝟐𝟑:

🔸Data Science https://mylearn.oracle.com/ou/learning-path/become-an-oci-data-science-professional-2023/121944

🔸React https://hackerrank.com/skills-verification/react_basic

🔸Angular https://hackerrank.com/skills-verification/angular_intermediate

🔸SEO https://academy.hubspot.com/courses/seo-training

🔸Digital Marketing from Google http://learndigital.withgoogle.com/digitalgarage/course/digital-marketing

🔸Cloud Security https://mylearn.oracle.com/ou/learning-path/become-a-cloud-security-professional-2023/121923

🔸Web Dev (HTML and CSS) https://freecodecamp.org/learn/2022/responsive-web-design/

🔸Python https://cs50.harvard.edu/python/

🔸JavaScript https://hackerrank.com/skills-verification/javascript_intermediate

🔸DevOps https://mylearn.oracle.com/ou/learning-path/become-an-oci-devops-professional-2023/121756

🔸Machine Learning https://freecodecamp.org/learn/machine-learning-with-python/

🔸Java https://data-flair.training/courses/free-java-course/

🔸C++ http://learn.saylor.org/course/view.php?id=65

🔸Go https://hackerrank.com/skills-verification/golang_intermediate

🔸Neo4j Certified Professional https://graphacademy.neo4j.com/courses/neo4j

🔸Redis Certified Developer https://university.redis.com/certification/

🔸MongoDB https://learn.mongodb.com/learning-paths/mongodb-for-sql-professionals

🔸Backend Development https://freecodecamp.org/learn/back-end-development-and-apis/

🔸SQL https://hackerrank.com/skills-verification/sql_advanced

🔸C# https://freecodecamp.org/learn/foundational-c-sharp-with-microsoft/


Telegram:- @Allcodingsolution

Websites to practice Frontend skills :

1. Frontend Mentor
frontendmentor.io

2. Codewars
codewars.com

3. Codewell
codewell.cc

4. JavaScript30
javascript30.com

5. Coderbyte
coderbyte.com

6. CSS Battle
cssbattle.dev

7. FreeCodeCamp
freecodecamp.org/learn/

8. Frontend Practice
frontendpractice.com

9. CodePen Challenges
codepen.io/challenges/?re

10. Dev Challenges
devchallenges.io

Telegram:- @Allcodingsolution

Telegram:- @Allcodingsolution

Telegram:- @Allcodingsolution

Telegram:- @Allcodingsolution

Telegram:- @Allcodingsolution

Telegram:- @Allcodingsolution

Telegram:- @Allcodingsolution

Learn for free in 2024

1. HTML
html.com

2. CSS
css-tricks.com

3. JavaScript
javascript.info

4. Git & GitHub
git-scm.com

5. React
react-tutorial.app

6. APIs
rapidapi.com

7. SQL
sqlbolt.com

DATA SCIENCE ROADMAP


This is the Ultimate RoadMap to become a Data Scientist, one needs to learn the following things. I have added the
resource links of all important things in this PDF.
DO YOU NEED A COLLEGE DEGREE?
With basic understanding of Maths, you can start. Even if you are not doing B Tech, Basic BSC Degree with Maths or some
other equivalent will suffice.
REQUIREMENTS [RESOURCES CAN BE FOUND AT THE END OF THIS DOCUMENT]
• Statistics + Maths
o Linear Algebra Notes (Amazing Resource for revising Data Science by Queen Mary University of London)
o Learn the basics of Mean, median, mode, dy/dx. This quick video can help you get started.
o Buy a copy of Hines Book (Probability and Statistics in Engineering by William Hines)
o Focus a bit more on Normal Distribution
o Learn basics of Optimization and Gradient Descent. You can watch this series I created long back.
o Get this amazing book on Graphs (Play with Graphs Book – Amit Aggarwal)
• Programming
o If confused choose Python as your first programming language
▪ Python in Hindi – 100 Days of Code by CodeWithHarry
▪ For English Lovers, there is this awesome course on Udemy
• Now once you have a basic understanding of Python, start learning Data Science
o Learn Basics – Start from this free book or buy it on Amazon
o Learn to use this amazing package for building quick Data Reports
o Learn NumPy from here
o Learn Pandas from here
o Matplotlib / Seaborn from here
• Database – Learn Basic CRUD Operations and depending upon how you are fetching your data, pick from these
technologies.
o MySQL
o MongoDB
o PyMongo
o SQLAlchemy
• Transition to ML/DL – Once you have some good hold on Python, Pandas and some data science projects, start
transitioning to Machine Learning.
o Grab a copy of this book: Hands on ML with Scikit-learn and Tensorflow (Author of this book also maintains
constantly updating Github Repo)
o Watch this project video I created on an End-to-End ML Project
• Linux & GIT
o Learn Basic Commands of Linux from this video by CodeWithHarry
o Learn to push your code to GitHub - Watch this quick video.
o Learn how to SSH into a Linux machine & abut SSH Keys
• Optional Tools that you can learn depending upon your requirements.
o AWS – Create an account and get started for Free. It will take you a long time to master it
o Learn about cronjobs from this video
o Learn about BeautifulSoup for Web Scraping using Python
o Tableau/Hadoop/PowerBI
o Excel VBA
o Good Code Repos & Papers: PapersWithCode

Try these Free courses from Microsoft in 2024 to level up your Skills 📈

𝟭. 𝗗𝗮𝘁𝗮 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀
https://learn.microsoft.com/en-us/training/paths/azure-data-fundamentals-explore-non-relational-data/

𝟮. 𝗦𝗾𝗹 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀
https://learn.microsoft.com/en-us/training/paths/azure-sql-fundamentals/

𝟯. 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜
https://learn.microsoft.com/en-us/training/paths/create-use-analvtics-reports-power-bi/

𝟰. 𝗔𝘇𝘂𝗿𝗲 𝗰𝗼𝘀𝗺𝗼𝘀 𝗗𝗕
https://learn.microsoft.com/en-us/training/paths/create-use-analytics-reports-power-bi/

𝟱. 𝗔𝗜 𝗳𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀
https://learn.microsoft.com/en-us/training/paths/create-no-code-predictive-models-azure-machine-learning/

𝟲. 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝘁𝗼 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴
https://learn.microsoft.com/en-us/training/modules/introduction-to-machine-learning/

𝟳. 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹 𝗔𝗜 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀
https://learn.microsoft.com/en-us/training/modules/get-started-ai-fundamentals/

𝟴. 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗼𝗳 𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝘃𝗲 𝗔𝗜
https://learn.microsoft.com/en-us/training/modules/fundamentals-generative-ai/

𝟵. 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗼𝗳 𝗖𝗼𝗺𝗽𝘂𝘁𝗲𝗿 𝗩𝗶𝘀𝗶𝗼𝗻
https://learn.microsoft.com/en-us/training/modules/analyze-images-computer-vision/

𝟭𝟬. 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗼𝗳 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗹𝗲 𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝘃𝗲 𝗔𝗜
https://learn.microsoft.com/en-us/training/modules/responsible-generative-ai/

𝟭𝟭. 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗼𝗳 𝗙𝗮𝗰𝗶𝗮𝗹 𝗥𝗲𝗰𝗼𝗴𝗻𝗶𝘁𝗶𝗼𝗻
https://learn.microsoft.com/en-in/training/modules/detect-analyze-faces/

𝟭𝟮. 𝗗𝗲𝘀𝗰𝗿𝗶𝗯𝗲 𝗰𝗹𝗼𝘂𝗱 𝗰𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴
https://learn.microsoft.com/en-in/training/modules/describe-cloud-compute/

𝟭𝟯. 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗼𝗳 𝗺𝗮𝗰𝗵𝗶𝗻𝗲 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴
https://learn.microsoft.com/en-in/training/modules/fundamentals-machine-learning/

𝟭𝟰. 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝘁𝗼 𝗚𝗶𝘁
https://learn.microsoft.com/en-in/training/modules/intro-to-git/

𝟭𝟱. 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝘁𝗼 𝗚𝗶𝘁𝗛𝘂𝗯
https://learn.microsoft.com/en-in/training/modules/introduction-to-github/

𝟭𝟲. 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗔𝘇𝘂𝗿𝗲 𝗙𝗿𝗲𝗲 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲
https://intellipaat.com/academy/course/free-microsoft-azure-certification-course/

𝟭𝟳. 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 𝗔𝗻𝗮𝗹𝘆𝘀𝘁
https://imp.i384100.net/ZQ4bNQ

𝟭𝟴. 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝟯𝟲𝟱 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗦𝗽𝗲𝗰𝗶𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻
https://imp.i384100.net/LXGOAo

𝐅𝐑𝐄𝐄 𝐃𝐞𝐯𝐎𝐩𝐬 & 𝐂𝐥𝐨𝐮𝐝 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬:

1. DevOps
http://openclassrooms.com/courses/7853556-discover-the-devops-methodology

2. CI/CD
http://simplilearn.com/free-ci-cd-online-training-course-skillup

3. Docker
http://cognitiveclass.ai/courses/docker-essentials

4. Kubernetes
http://simplilearn.com/learn-kubernetes-basics-free-course-skillup

5. GIT
http://simplilearn.com/learn-git-basics-skillup

6. GitHub
http://mygreatlearning.com/academy/learn-for-free/courses/github-tutorial-for-beginners

7. Linux
http://mygreatlearning.com/academy/learn-for-free/courses/linux-tutorial

8. Cloud Computing
http://cognitiveclass.ai/courses/introduction-to-cloud

9. AWS
http://openclassrooms.com/courses/7864796-discover-cloud-with-amazon-web-services

10. Azure
http://mygreatlearning.com/academy/learn-for-free/courses/microsoft-azure-essentials

11. AWS
http://openclassrooms.com/courses/7864796-discover-cloud-with-amazon-web-services

12. Azure
http://mygreatlearning.com/academy/learn-for-free/courses/microsoft-azure-essentials

13. Cloud Computing
http://cognitiveclass.ai/courses/introduction-to-cloud

14. Linux
http://mygreatlearning.com/academy/learn-for-free/courses/linux-tutorial

15. GCP
http://simplilearn.com/learn-google-cloud-platform-fundamentals-free-course-skillup

16. Serverless
http://mygreatlearning.com/academy/learn-for-free/courses/serverless-computing

17. Docker
https://cognitiveclass.ai/courses/docker-essentials

18. Kubernetes
http://simplilearn.com/learn-kubernetes-basics-free-course-skillup

19. CI/CD
http://simplilearn.com/free-ci-cd-online-training-course-skillup

20. Jenkins
http://mygreatlearning.com/academy/learn-for-free/courses/jenkins-tutorial

21. Puppet
http://simplilearn.com/free-course-to-learn-puppet-basics-skillup…

22. Chef
http://simplilearn.com/chef-in-devops-basics-free-course-skillup

23. Ansible
http://simplilearn.com/learn-ansible-basics-free-course-skillup

24. Selenium
http://mygreatlearning.com/academy/learn-for-free/courses/selenium-basics

25. VirtualBox & vSphere
https://openclassrooms.com/en/courses/7163136-set-up-virtual-machines-using-virtualbox-and-vsphere

Free JavaScript Courses to learn in 2024:

1. Learn JavaScript
https://codecademy.com/learn/introduction-to-javascript

2. JavaScript for Beginners
https://simplilearn.com/learn-javascript-basics-free-course-skillup

3. Javascript Essentials
https://udemy.com/course/javascript-essentials/

4. JavaScript Fundamentals
https://udemy.com/course/javascriptfundamentals/

5. Learn to Program in Javascript: Beginner to Pro
https://udemy.com/course/programming-in-javascript/

6. Code Your First Game: Arcade Classic in JavaScript on Canvas
https://udemy.com/course/code-your-first-game/

7. Learn JavaScript - Full Course for Beginners
https://youtube.com/watch?v=PkZNo7MFNFg&ab_channel=freeCodeCamp.org

8. Learn Intermediate JavaScript
https://codecademy.com/learn/learn-intermediate-javascript

9. Programming with JavaScript
https://imp.i384100.net/DK10Wb

10. Meta Front-End Developer Professional Certificate
https://imp.i384100.net/k0bgjx

11. HTML, CSS, and Javascript for Web Developers
https://imp.i384100.net/MmjnAM