Some useful content

Groups/links to stay up to date with latest tech

• https://dev.to/
• interviewready
• TLDR
• Java Techie
• ConceptandCoding

Some other useful reads

• Consistent way of dealing with Stock buy and sell problem

𝐒𝐲𝐬𝐭𝐞𝐦 𝐃𝐞𝐬𝐢𝐠𝐧 𝐆𝐨𝐥𝐝𝐦𝐢𝐧𝐞 🙌🏻✔️

✅ Things you must know in System Design

• System design basics: https://bit.ly/3SuUR0Y
• Horizontal and vertical scaling: https://bit.ly/3slq5xh
• Load balancing and Message queues: https://bit.ly/3sp0FP4
• High-level design and low-level design, Consistent Hashing, Monolithic and Microservices architecture: https://bit.ly/3DnEfEm
• Caching, Indexing, Proxies: https://bit.ly/3SvyVDc
• Networking, How Browsers work, Content Network Delivery ( CDN): https://bit.ly/3TOHQRb
• Database Sharding, CAP Theorem, Database schema Design: https://bit.ly/3CZtfLN
• Concurrency, API, Components + OOP + Abstraction : https://bit.ly/3sqQrhj
• Estimation and Planning, Performance: https://bit.ly/3z9dSPN
• Map Reduce, Patterns, and Microservices: https://bit.ly/3zcsfmv
• SQL vs NoSQL and Cloud: https://bit.ly/3z8Aa49
• Most Popular System Design Questions: https://bit.ly/3Dp40Ux

✅ System Design Case Studies

• Design Netflix: https://bit.ly/3GrAUG1
• Design Reddit: https://bit.ly/3OgGJrL
• Design Messenger App : https://bit.ly/3DoAAXi
• Design Instagram: https://bit.ly/3BFeHlh
• Design Dropbox: https://bit.ly/3SnhncU
• Design Youtube: https://bit.ly/3dFyvvy
• Design Tinder: https://bit.ly/3Mcyj3X
• Design Yelp: https://bit.ly/3E7IgO5
• Design Whatsapp: https://bit.ly/3M2GOhP
• Design URL shortener : https://bit.ly/3xP078x
• Design Amazon Prime Video: https://bit.ly/3hVpWP4
• Design Twitter: https://bit.ly/3qIG9Ih
• Design Uber: https://bit.ly/3fyvnlT
• Design TikTok : https://bit.ly/3UUlKxP
• Design Facebook's Newsfeed: https://bit.ly/3RldaW7
• Design Web Crawler: https://bit.ly/3DPZTBB
• Design API Rate Limiter: https://bit.ly/3BIVuh7

✅ All solved case studies: https://bit.ly/3dCG1rc

• System Design Important terms - https://bit.ly/3Om9d3H
• Most Popular System Design Questions: https://bit.ly/3E9oH7K
• Complete System Design Basics Series: https://bit.ly/3rG1cfr

SQL preparation kit

Here it goes: Day One:

• SQL Bolt (sqlbolt.com)
• Data science skill (bit.ly/3i6obPg)

Day Two:

• Average post hiatus (bit.ly/3WRPv2I)
• Teams power users (bit.ly/3jCIggI)
• Cards issued difference (bit.ly/3YUdhgi)
• Pharmacy Analytics Part 1 (bit.ly/3hWwb5q)
• Pharmacy Analytics Part 2 (bit.ly/3Q2Gm53)
• Most expensive purchase (bit.ly/3VrvIWx)

Day Three:

• Unfinished parts (bit.ly/3Vydpzd)
• Compressed mean (bit.ly/3C8oDUf)
• Apple pay volume (bit.ly/3Cb9Sjg)
• Subject mater expert (bit.ly/3Grfskj)
• Highest number of products (bit.ly/3Go3LL0)
• Ad campaign ROAS (bit.ly/3i0bNAw)
• Top rated businesses (bit.ly/3hSqjdG)

Day Four:

• Advertiser Status (bit.ly/3i2mhzh)
• Average Vacant Days (bit.ly/3Wun3nC)
• 3-Topping Pizzas (bit.ly/3GpHxIA)
• Average Deal Size (Part 2) (bit.ly/3vpRj7k)
• LinkedIn Power Creators (Part 2) (bit.ly/3FZf8aR)
• Bad Delivery Rate (bit.ly/3IeNmKt)
• Email Table Transformation (bit.ly/3WSr2Kq)

Day Five:

• Event Friends Recommendation (bit.ly/3jCzyiz)
• Follow-Up Airpod Percentage (bit.ly/3G562tl)
• Fill Missing Client Data (bit.ly/3C8JaYu)
• First Transaction (bit.ly/3vmsmJW)
• Google Maps Flagged UGC (bit.ly/3IdKrS3)

Day Six:

• Highest-Grossing Items (bit.ly/3jE697G)
• Best-Selling_Product (bit.ly/3GnytnF)
• International Call Percentage (bit.ly/3PXrNzO)
• Reactivated Users (bit.ly/3GqWzhh)

Day Seven:

• Rolling 3-Day Earnings (bit.ly/3vHPral)
• Tweet's Rolling Averages (bit.ly/3I9JuKn)

Note: some of the problems are "premium" problems

Leetcode

• RLE Iterator
• Odd Even Jump
• Snapshot Array
• Longest String Chain
• Minimum Area Rectangle
• Random Pick with Weight
• Filling Bookcase Shelves
• Product of the Last K Numbers
• Tiling a Rectangle with the Fewest Squares
• Shortest Path in a Grid with Obstacles Elimination
• Minimum Number of Flips to Convert Binary Matrix to Zero Matrix

--Constructive Algorithms

1. Split String https://lnkd.in/eTb6VDmC

2. Bin packing problem https://lnkd.in/eXZKX3Sv

--Combinatorics

1. Sum of smallest elements in distinct sets https://lnkd.in/exm7jDTm

--Dynamic Programming

1. Kth Step Sequence https://lnkd.in/ertBsik7

2. Collecting coins [Combinatorics involved] https://lnkd.in/eqM-zDyi

--Graph

1. Turn on all systems [Minimum spanning tree] https://lnkd.in/ekj627TZ

2. Turning Pages [DFS / Backtracking] https://lnkd.in/eHsfBsM5

--Tree

1. Delete Edge to minimize the difference in subtree sum. https://lnkd.in/edba9e8T

--Bitset

1. Queries on Binary String [Queues can be used] https://lnkd.in/edZRjGck

--Hashmap

1. Insert Delete Get Random https://lnkd.in/eRk-hSKW

2. Implement a hash map. https://lnkd.in/eznHKki3

--Stacks

1. Implement a queue with two stacks. https://lnkd.in/ebJbDced

--Binary Search 2) Index of a rotation point in an array. https://lnkd.in/e2KQs-Mq

Old but useful links for prep

1. For Online Assessment + Phone Screen + Onsite Rounds:

• https://lnkd.in/dhgnCHDh
• https://lnkd.in/dV65F9s2
• https://lnkd.in/dmMsTEXb
• https://lnkd.in/dyCbzm7P
• https://lnkd.in/dvPHRbi3
• https://lnkd.in/d5C5AfDB
• https://leetcode.com/discuss/interview-question/4687107/Microsft-interview

2. For Behavioural Rounds:

• https://lnkd.in/daWKBYxu
• https://lnkd.in/d2VThaPC
• https://lnkd.in/dUAGGSRg
• https://lnkd.in/dV9kQ2e9
• https://lnkd.in/dRsXPyfW

3. For System Design Rounds (LLD + HLD):

• https://lnkd.in/dYqeeU8v
• https://lnkd.in/gZ_AEPTP
• https://lnkd.in/dFXbu9sk
• https://lnkd.in/dCcyUVuJ
• https://lnkd.in/dcu9mZeF
• https://lnkd.in/dFBM9aPg!
• https://lnkd.in/ddv7-88p

4. Top Interview Experiences to go through:

• https://lnkd.in/d5THPkkW
• https://lnkd.in/d9cTpYKE
• https://lnkd.in/dcAdcben
• https://lnkd.in/dhFyWtEf
• https://lnkd.in/da_kR-F6
• https://lnkd.in/dkPWFxgf.
• https://lnkd.in/dx83T_ri

5. Some Strategies To Follow:

• https://lnkd.in/dwrtagc8
• https://lnkd.in/dQhPGrF7
• https://lnkd.in/dPMHXMP8)
• https://lnkd.in/dTABpjpu