Interview Preparation Kit and Resume Building Kit are Free of Cost

SQL - END-TO-END Learning Resources and Guide 👇
SQL BASIC ➡️ SQL ADVANCE

🌐 SQL Basics (14 videos)

📌 SQL Fundamentals, CRUD Operations & Setting Environment -
https://lnkd.in/ekBxGU2c

📌 Primary Key vs Unique Key, Auto Increment Values -
https://lnkd.in/eXSugBVX

📌 DDL vs DML, Truncate vs Delete -
https://lnkd.in/eCEj6NHc

📌 Foreign Key Constraint -
https://lnkd.in/ebfYyM2b

📌 Distinct, Order By, Limit, Like Keyword -
https://lnkd.in/ec-McKnC

📌 Order of execution in SQL -
https://lnkd.in/eShPzDCJ

📌 Aggregate Functions in SQL -
https://lnkd.in/e2HQQZj3

📌 Datatypes in SQL -
https://lnkd.in/eJ7prXMR

📌 Logical Operators in SQL -
https://lnkd.in/eubjUHeD

📌 Joins in SQL -
https://lnkd.in/e63jvjec

📌 Difference between where and having in mysql -
https://lnkd.in/eTwb9pcJ

📌 Over Clause & Partition By Clause -
https://lnkd.in/ewspqCVS

📌 Row Number Function in MySQL -
https://lnkd.in/eK9-Ef4P

📌 Rank & Dense Rank -
https://lnkd.in/en83Pr5V

🌐 SQL Advanced (2 videos)

📌 CTE in SQL -
https://lnkd.in/e-cKsd89

📌 SQL internals -
https://lnkd.in/erwxZY8J

SQL Leetcode (8 problems)

📌 LeetCode 175 - combine 2 tables
https://lnkd.in/eMmX8DQa

📌 Leetcode 176 - Second highest salary (3 approaches)
https://lnkd.in/eaDRxzSd

📌 Leetcode 178,180,181 - Rank Scores, Consecutive Numbers, Employees Earning More Than Their Managers
https://lnkd.in/efibXrXG

📌 Leetcode 182,183 - Duplicate Emails, Customers Who Never Order
https://lnkd.in/e9ZSr9s2

📌 LeetCode 184 - Department Highest Salary
https://lnkd.in/evpeZrJh


CC: Sumit Mittal Sir

SQL Mindmap

🔥 𝟒𝟎+ 𝐌𝐮𝐬𝐭-𝐇𝐚𝐯𝐞 𝐂𝐡𝐞𝐚𝐭 𝐒𝐡𝐞𝐞𝐭𝐬 𝐟𝐨𝐫 𝐖𝐞𝐛 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐫𝐬 :

📝 HTML Cheat Sheet: https://websitesetup.org/html5-cheat-sheet/

📝 CSS Cheat Sheet: https://websitesetup.org/css3-cheat-sheet/

📝 JavaScript Cheat Sheet: https://websitesetup.org/javascript-cheat-sheet/

📝 jQuery Cheat Sheet: https://websitesetup.org/jquery-cheat-sheet/

📝 PHP Cheat Sheet: https://websitesetup.org/php-cheat-sheet/

📝 MySQL Cheat Sheet: https://websitesetup.org/mysql-cheat-sheet/

📝 Git Cheat Sheet: https://education.github.com/git-cheat-sheet-education.pdf

📝 Bootstrap Cheat Sheet: https://hackerthemes.com/bootstrap-cheatsheet/

📝 Node.js Cheat Sheet: https://overapi.com/nodejs

📝 React Cheat Sheet: https://reactcheatsheet.com/

📝 Vue.js Cheat Sheet: https://www.vuemastery.com/pdf/Vue-Essentials-Cheat-Sheet.pdf

📝 Angular Cheat Sheet: https://angular.io/guide/cheatsheet

📝 Express.js Cheat Sheet: https://github.com/azat-co/cheatsheets/blob/master/express4/

📝 Flask Cheat Sheet: https://s3.amazonaws.com/assets.datacamp.com/blog_assets/Flask_SQLAlchemy_Cheat_Sheet_Python.pdf

📝 Django Cheat Sheet: https://github.com/lucrae/django-cheat-sheet

📝 GraphQL Cheat Sheet: https://wehavefaces.net/graphql-shorthand-notation-cheatsheet-17cd715861b6

📝 REST API Cheat Sheet: https://www.restapitutorial.com/lessons/restquicktips.html

📝 Postman Cheat Sheet: https://learning.postman.com/docs/postman/cheatsheet/

📝 Regular Expressions Cheat Sheet: https://cheatography.com/davechild/cheat-sheets/regular-expressions/

📝 HTTP Status Codes Cheat Sheet: https://httpstatuses.com/

📝 Design Patterns Cheat Sheet: https://www.dofactory.com/javascript/design-patterns

📝 Google Analytics Cheat Sheet: https://www.optimizesmart.com/google-analytics-cheat-sheet/

📝 SEO Cheat Sheet: https://www.semrush.com/blog/seo-cheat-sheet/

📝 Performance Optimization Cheat Sheet: https://web.dev/performant-cheat-sheet/

📝 UX Design Cheat Sheet: https://uxdesign.cc/the-ultimate-ux-design-cheat-sheet-d8f52282a3fc

📝 Accessibility Cheat Sheet: https://www.a11yproject.com/checklist/

📝 Git Commands Cheat Sheet: https://education.github.com/git-cheat-sheet-education.pdf

📝 GitHub Markdown Cheat Sheet: https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet

📝 Nginx Cheat Sheet: https://devhints.io/nginx

📝 Docker Cheat Sheet: https://dockerlabs.collabnix.com/docker/cheatsheet/

📝 Kubernetes Cheat Sheet: https://kubernetes.io/docs/reference/kubectl/cheatsheet/

📝 Linux Commands Cheat Sheet: https://cheatography.com/davechild/cheat-sheets/linux-command-line/

📝 Bash Scripting Cheat Sheet: https://devhints.io/bash

📝 VS Code Cheat Sheet: https://code.visualstudio.com/shortcuts/keyboard-shortcuts-windows.pdf

📝 SASS Cheat Sheet:

https://devhints.io/sass

📝 LESS Cheat Sheet: https://devhints.io/less

🔥 𝟭𝟬+ 𝗙𝗿𝗲𝗲 𝗥𝗲𝘀𝘂𝗺𝗲 𝗕𝘂𝗶𝗹𝗱𝗲𝗿 𝗪𝗲𝗯𝘀𝗶𝘁𝗲𝘀 :-


(All of them offers downloading in pdf version)


📌 Canva: https://www.canva.com/create/resumes/

Canva is a graphic design platform that offers a wide range of templates, including resume templates. It is a free online tool that allows you to customize your resume with various design elements and download it in different formats.


📌 Zety: https://zety.com/resume-builder

Zety is a resume builder that offers both free and paid versions. The free version allows you to create a basic resume with a variety of templates, and you can download it in a plain text or PDF format.


📌 Novoresume: https://novoresume.com/

Novoresume is a resume builder that offers a free version with limited features. It allows you to create a basic resume with a variety of templates.


📌 VisualCV: https://www.visualcv.com/

VisualCV is a free online resume builder that allows you to create a custom-designed resume with a variety of templates. It also includes a variety of customization options, such as font style and color.


📌 Resume.com: https://www.resume.com/

Resume.com is a free online resume builder that allows you to create a basic resume with a variety of templates. It also includes customization options, such as font style and color.


📌 MyPerfectResume: https://www.myperfectresume.com/resume-builder

MyPerfectResume is a free online resume builder that allows you to create a basic resume with a variety of templates. It also includes customization options, such as font style and color.


📌 Resume-Now: https://www.resume-now.com/

Resume-Now is a free online resume builder that allows you to create a basic resume with a variety of templates. It also includes customization options, such as font style and color.


📌 Resumaker: https://resumaker.online/en

Resumaker is a free online resume builder that allows you to create a basic resume with a variety of templates. It also includes customization options, such as font style and color.


📌 Resume-Builder.net: https://www.resume-builder.net/

Resume-Builder.net is a free online resume builder that allows you to create a basic resume with a variety of templates. It also includes customization options, such as font style and color.


📌 Resume Genius: https://resumegenius.com/

Resume Genius is a free online resume builder that offers a variety of templates for different job industries. It also includes helpful tips and suggestions for each section of your resume.


📌 CakeResume: https://www.cakeresume.com/

CakeResume is a free online resume builder that offers a variety of templates and customization options. It also includes a personal website builder and the ability to track your resume views and downloads.

I hope this list of free resume builder websites will be helpful for you !!!

CHEAT SHEETS FOR DATA SCIENCE

🌟 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝟰𝟳 𝗖𝗮𝗿𝗲𝗳𝘂𝗹𝗹𝘆 𝗖𝘂𝗿𝗮𝘁𝗲𝗱 𝗖𝗵𝗲𝗮𝘁𝘀𝗵𝗲𝗲𝘁𝘀 𝗬𝗼𝘂'𝗹𝗹 𝗘𝘃𝗲𝗿 𝗡𝗲𝗲𝗱! 📚

1. Python : https://lnkd.in/grD8XUS6
2. Pandas : https://lnkd.in/g4yTJ7CP
3. NumPy : https://lnkd.in/gg9Uw-km
4. Matplotlib https://lnkd.in/gahrGicD
5. Seaborn https://lnkd.in/gcu4UKpw
6. Scikit-learn https://lnkd.in/gGfkNu5i
7. TensorFlow : https://lnkd.in/g3fw3uRV
8. Keras : https://lnkd.in/gfPTfbgg
9. PyTorch https://bit.ly/3lnsiIz
10. SQL : https://lnkd.in/gnwe4qcb
11. R : https://lnkd.in/gEgJ6A8j
12. Git : https://lnkd.in/gyzhztvH
13. AWS https://bit.ly/3ZQWMS1
14. Azure https://bit.ly/42f4N4V
15. Google Cloud Platform : https://bit.ly/3JJADzv
16. Docker : https://bit.ly/3Lt2zJe
17. Kubernetes https://lnkd.in/gjXCT7Mb
18. Linux Command Line : https://bit.ly/3FtcTgw
19. Jupyter Notebook https://lnkd.in/g7cPmgHQ
20. Data Wrangling :https://bit.ly/3TiMibP
21. Data Visualization : https://lnkd.in/gQ52Jd_J
22. Statistical Inference https://lnkd.in/grNXVQh5
23. Probability : https://lnkd.in/gvnWCphc
24. Linear Algebra : https://lnkd.in/gty6XpVF
25. Calculus https://lnkd.in/gjhsmsxu
26. Time Series : https://bit.ly/3Fvuep4
27. NLP: https://bit.ly/3Fvursm
28. Neural Network : https://lnkd.in/gThs2AAp
29. Deep Learning : https://lnkd.in/gVbSPae2
30. Machine Learning : https://bit.ly/3mZ5Wh3
31. Apache Spark : https://lnkd.in/ge7Rj-Yr
32. Hadoop : https://bit.ly/3Lq34DR
33. Big-O Notation t: https://lnkd.in/gfYqM8WU
34. Regular Expression : https://lnkd.in/gE9kZTZW
35. Unix/Linux Permissions https://bit.ly/3ZUfwA8
36. Python String Formatting https://lnkd.in/gHi26Uk2
37. Flask : https://lnkd.in/gGzbSTgU
38. Django : https://lnkd.in/grZcWz8y
39. SQL : https://lnkd.in/gyierV3f
40. PostgreSQL : https://lnkd.in/gzfiW7zB
41. MySQL: https://lnkd.in/g4JnPVTe
42. MongoDB : https://lnkd.in/gHc4F4ER
43. TensorFlow Probability Cheat Sheet: https://lnkd.in/gr3bgDGP
44. OpenAI GPT-3 Documentation: https://lnkd.in/gawB_SC9
45. GPT-3 API Reference: https://lnkd.in/gtCGZvX8
46. GPT-3 GitHub Repository: https://lnkd.in/g56cQQPD
47. Chat GPT Cheat Sheet : https://lnkd.in/e43cDB9q

Join this group for Data Analysis:-

https://chat.whatsapp.com/JX43FG1neR60DFOhrHc7Ng

📌 𝗔𝗺𝗮𝘇𝗶𝗻𝗴 𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗔𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲𝘀 𝘁𝗼 𝗳𝗶𝗻𝗶𝘀𝗵 𝗵𝗼𝘂𝗿𝘀 𝗼𝗳 𝘄𝗼𝗿𝗸 𝗶𝗻 𝘀𝗲𝗰𝗼𝗻𝗱𝘀 !!! 💯

📍 𝗙𝗼𝗿 𝗪𝗿𝗶𝘁𝗶𝗻𝗴:

ChatSonic - https://lnkd.in/dbKtMMaE
ChatABC - https://chatabc.ai
JasperAI - https://www.jasper.ai
Quillbot - https://quillbot.com

📍 𝗙𝗼𝗿 𝗖𝗼𝗱𝗶𝗻𝗴:

Copilot- https://lnkd.in/dzekWja7
Tabnine - https://www.tabnine.com
MutableAI - https://mutable.ai
Safurai - https://www.safurai.com
10Web - https://lnkd.in/d22pd829

📍 𝗙𝗼𝗿 𝗥𝗲𝘀𝗲𝗮𝗿𝗰𝗵:

Paperpal - https://paperpal.com
Perplexity - https://www.perplexity.ai
YouChat - https://lnkd.in/d5urTnEu
Elicit - https://elicit.org

📍 𝗙𝗼𝗿 𝗧𝘄𝗶𝘁𝘁𝗲𝗿:

Tweetmonk - https://tweetmonk.com
Tribescaler - https://tribescaler.com
Postwise - https://postwise.ai
TweetLify - https://www.tweetlify.co

📍 𝗙𝗼𝗿 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆:

Synthesia - https://www.synthesia.io
Otter - https://otter.ai
Bardeen - https://www.bardeen.ai
CopyAI - https://lnkd.in/dBNHJg2U

📍 𝗙𝗼𝗿 𝗖𝗼𝗻𝘁𝗲𝗻𝘁 𝗖𝗿𝗲𝗮𝘁𝗶𝗼𝗻:

WriteSonic - https://lnkd.in/gM3ryrax
Tome - https://beta.tome.app
CopySmith - https://app.copysmith.ai
TextBlaze - https://blaze.today

📍 𝗥𝗲𝘀𝘂𝗺𝗲 𝗕𝘂𝗶𝗹𝗱𝗲𝗿𝘀:

Kickresume - https://www.kickresume.com
ReziAI - https://www.rezi.ai
ResumeAI - https://www.resumai.com
EnhanceCV - https://enhancv.com

📍 𝗙𝗼𝗿 𝗣𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀:

BeautifulAI - https://www.beautiful.ai
Simplified - https://simplified.com
Slidesgo - https://slidesgo.com
Sendsteps - https://lnkd.in/d2bJi-h3

📍 𝗙𝗼𝗿 𝗔𝗜 𝗔𝘂𝗱𝗶𝗼:

MurfAI - https://murf.ai
Speechify - https://speechify.com
LovoAI- https://lovo.ai
MediaAI- https://www.ai-media.tv

Excel is one of the important skills you need as a Data Analyst.

Neat & Clean SQL Handwritten Notes

Most comprehensive material on Data Science Interview Preparation.

Handwritten JavaScript Notes

Ultimate Resources for React Developers

800+ SQL Questions and Answers in one document for all your needs!!!

REST API in an illustrative way !!!