Web Development Basics Notes

Full Stack Guide (MERN Stack )

» M - MongoDB
» E - Express JS
» R - React JS
» N - Node JS

** Most popular stack for front-end , Backend and Database

👉 Below are the direct links to download handwritten notes of MERN Stack ( LinkedIn Links ) :

🖋 JavaScript Notes - https://lnkd.in/dv2-qumh

🖋 MongoDB Notes - https://lnkd.in/d2NT7pAW

🖋 Express JS Notes - https://lnkd.in/dSqzX9r6

🖋 React JS Notes - https://lnkd.in/du-m9s42

🖋 Node JS Notes - https://lnkd.in/d8NFSc4S


📝 BONUS :

🖋 Handwritten DSA Notes - https://lnkd.in/dqcMqsqp

*
**
***
****
Invite your friends to join our community so that more and more students can get BEST content for free.
****
***
**
*

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