SQL Notes for Beginners

Commonly used techniques for SQL Optimization

Neat & Clean JavaScript Notes

MERN Stack Guide

Python Notes

Data Analysis by MS Excel

Remote friendly Companies List

𝐋𝐢𝐬𝐭 𝐨𝐟 𝐂𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐇𝐢𝐫𝐢𝐧𝐠 𝐟𝐨𝐫 𝐃𝐀𝐓𝐀 𝐀𝐍𝐀𝐋𝐘𝐒𝐓 𝐑𝐨𝐥𝐞 🚀🚀🚀.

𝑷𝒖𝒓𝒆 𝒑𝒍𝒂𝒚 𝒂𝒏𝒂𝒍𝒚𝒕𝒊𝒄𝒔 𝒄𝒐𝒎𝒑𝒂𝒏𝒊𝒆𝒔:
1. Mu Sigma
2. SAS
3. Fractal Analytics
4. Modelytics
5. Marketics
6. Ugam Solutions
7. LatentView
8. Brillio
9. Tiger Analytics
10. TheMathCompany
11. Affine Analytics
12. Moody's Analytics
13. IRI
14. Quantiphi
15. EXL

𝑪𝒐𝒏𝒔𝒖𝒍𝒕𝒊𝒏𝒈 𝒄𝒐𝒎𝒑𝒂𝒏𝒊𝒆𝒔 𝒅𝒐𝒊𝒏𝒈 𝒂𝒏𝒂𝒍𝒚𝒕𝒊𝒄𝒔 𝒘𝒐𝒓𝒌:
1. ZS Associates
2. Bain & Company
3. PwC
4. Deloitte
5. McKinsey
6. BCG
7. MindTree Consulting
8. EY
9. KPMG
10. Avalon Consulting
11. Accenture
12. Kantar group

𝑭𝒊𝒏𝒂𝒏𝒄𝒊𝒂𝒍 𝒔𝒆𝒓𝒗𝒊𝒄𝒆𝒔 (𝑰𝒏-𝒉𝒐𝒖𝒔𝒆 𝒂𝒏𝒂𝒍𝒚𝒕𝒊𝒄𝒂𝒍 𝒄𝒐𝒏𝒔𝒖𝒍𝒕𝒊𝒏𝒈):
1. Credit Suisse
2. Deutsche Bank
3. Citigroup
4. HSBC
5. JP Morgan Chase
6. American Express
7. Bank of America
8. Capital One
9. Barclaycards
10. Paypal
11. Goldman Sachs
12. Merrill Lynch
13. DeShaw
14. Blackstone Analytic Partners
15. Fidelity
16. TSYS
17. GAIN Credit
18. Mastercard
19. Visa
20. GE Money
21. Axis

𝑶𝒕𝒉𝒆𝒓𝒔 (𝒐𝒇𝒇𝒆𝒓𝒊𝒏𝒈 𝑨𝒏𝒂𝒍𝒚𝒕𝒊𝒄𝒔 𝒓𝒐𝒍𝒆𝒔):
1. LiveRamp Holdings
2. Cranes Software Enterprise
3. Genie Allegro Advisors
4. Aranca
5. Tata Strategic Management Group
6. IHS Markit
7. Factset Research
8.Infosys Analytics
9.Wipro Analytics
10. HCL Analytics
11. Eclerx
12. Ogilvy
13. Genpact
14. Equifax
15. Epsilon
16. Dell Analytics
17. IBM Analytics
18. Capgemini
19. HP Analytics
20. CGI

ALERT !!! 📢

We've got an exciting opportunity for you to get premium courses from Coding Ninjas for free

>>All you have to do is participate in the CNSAT scholarship test and you could receive up to 100% off any Coding Ninjas course.

📍DATE- 29th and 30th March
📍TIME SLOTS- 6 PM to 9 PM
📍DURATION- 1HR

>>Two days window, so you can attempt on any day.

>>Plus, if you register right now, you'll also receive an Interview Prep Kit and Resume Building Kit worth Rs. 500 for absolutely free.

>>Don't miss out on this chance to level up your coding skills and take your career to the next level.

HURRY UP!! 📢
Register Now -https://bit.ly/3JNZr8m

Placement Season is Coming , it's a GREAT OPPORTUNITY to check your preparation for Aptitude Questions as well as where you stand among your peers 👍 !!!

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