avatarNaina Chaturvedi

Summary

The website provides a comprehensive compilation of resources for tech interviews, including advanced SQL series, system design case studies, data structures and algorithms, and various projects and courses in data science, machine learning, and Python programming.

Abstract

The webpage titled "Mega Post— Tech Interview: The Only List of Questions You Need To Practice" serves as an extensive repository for individuals preparing for technical interviews in the tech industry. It offers a meticulously organized "Advanced SQL Series" covering a range of topics from basic queries to complex SQL concepts. Additionally, the page presents a plethora of system design case studies for popular platforms like Instagram and Amazon, encouraging a deep dive into the architecture and design principles of such systems. The resource also includes a thorough exploration of data structures and algorithms, complete with practice questions and implementation details. Furthermore, it provides access to a multitude of projects and courses, encompassing data science, machine learning, and Python programming, aimed at enhancing practical skills and understanding. The content is curated to cater to both beginners and advanced learners, with an emphasis on hands-on experience through projects and real-world applications.

Opinions

  • The author emphasizes the importance of practical application by providing links to GitHub repositories and project videos, suggesting a learning-by-doing approach.
  • There is an endorsement of the resources as being beneficial for understanding data structures, algorithms, system design, and problem-solving techniques, as evidenced by the author's personal use in interviews.
  • The author encourages the use of these resources as a reference or practice tool, indicating a belief in their comprehensive nature and utility for interview preparation.
  • A disclaimer is included to ensure that readers understand the list is not exhaustive but rather a collection of the author's favorite questions to gauge a candidate's understanding and problem-solving abilities.
  • The author plans to provide additional content, such as tips and techniques for solving coding questions and writing optimized code quickly, indicating a commitment to ongoing educational support.
  • The website promotes a newsletter subscription, suggesting the author values continuous engagement and learning beyond the static content provided.
  • The author advocates for the importance of certain topics over others, like DP, Tree, Graph, Binary Search, Linked List, and dynamic programming, for interview preparation.
  • The inclusion of highly recommended courses with certificates implies that the author believes in the value of structured learning and credentialing for career advancement.
  • The author provides a brief overview of the dynamic programming concept, highlighting its significance in tech interviews.
  • The website content is periodically updated, as indicated by the author's intention to write another post covering techniques for solving coding questions, reflecting a commitment to keeping the content current and relevant.

Mega Post— Tech Interview : The Only List of Questions You Need To Practice

Mega Compilation — Use it just as a reference/practice resource…

Burn Freddy Burn (Pic credits : Pinterest)

Welcome back peeps. I’m creating this post to help students/anyone who wants to get into tech — who are preparing for their tech interviews. While I’m sitting on the other side of the table as an interviewer now; I know how daunting the prep journey can be. Use it just as a reference/practice resource and you may bookmark this list.

Advanced SQL Series

Day 1 : SQL Basics and Kick start of Advanced SQL Series

Day 2 : SQL Basics, Query Structure, Built In functions Conditions

Day 3 : Most Important Commands, Joins and Filters

Day 4 : Set Theory Operations, Stored Procedures and CASE statements in SQL

Day 5 : Wildcards, Aggregation and Sequences in SQL

Day 6 : Subqueries, Group by, order by and Having clauses in SQL and Analytical Functions

Day 7 : Window Functions, Grouping Sets and Constraints in SQL

Day 8 : BigQuery Basics, SELECT, FROM, WHERE and Date and Extract in BigQuery

Day 9 : Common Expression Table, UNNEST Clause, SQL vs NoSQL Databases

Day 10 : Triggers, Pivot and Cursors in SQL

Day 11 : Views, Indexes and Auto Increment in SQL

Day 12 : Query optimizations, Performance tuning in SQL

Day 13 : Introduction to MySQL, PostgreSQL and Mongo DB, Comparison between MySQL and PostgreSQL and Mongo DB, Introduction to SQL and NoSQL Databases

Day 14 : MySQL in Depth

Day 15 : PostgreSQL inDepth

System Design Case Studies — In Depth

Design Instagram

Design Netflix

Design Reddit

Design Amazon

Design Messenger App

Design Twitter

Design URL Shortener

Design Dropbox

Design Youtube

Design API Rate Limiter

Design Web Crawler

Design Amazon Prime Video

Design Facebook’s Newsfeed

Design Yelp

Design Uber

Design Tinder

Design Tiktok

Design Whatsapp

Most Popular System Design Questions

Mega Compilation : Solved System Design Case studies

Complete Data Structures and Algorithm Series

Complexity Analysis

Sliding Window

Backtracking

Greedy Technique

Two pointer Technique

1- D Dynamic Programming

Divide and Conquer Technique

Recursion

Github —

Some of the other best Series —

30 Days of Natural Language Processing ( NLP) Series

How to solve any System Design Question ( approach that you can take)?

Complete System Design Case Studies Series

30 days of Data Structures and Algorithms and System Design Simplified

60 Days of Deep Learning with Projects Series

60 days of Data Science and ML Series with projects

Data Science and Machine Learning Research ( papers) Simplified **

60 Days of Deep Learning with Projects Series

100 days : Your Data Science and Machine Learning Degree Series with projects

23 Data Science Techniques You Should Know

Tech Interview Series — Curated List of coding questions

Complete System Design with most popular Questions Series

Complete Data Visualization and Pre-processing Series with projects

Complete Python Series with Projects

Complete Advanced Python Series with Projects

Kaggle Best Notebooks that will teach you the most

Complete Developers Guide to Git

All the Data Science and Machine Learning Resources

210 Machine Learning Projects

30 days of Machine Learning Ops

Projects Videos —

All the projects, data structures, SQL, algorithms, system design, Data Science and ML , Data Analytics, Data Engineering, , Implemented Data Science and ML projects, Implemented Data Engineering Projects, Implemented Deep Learning Projects, Implemented Machine Learning Ops Projects, Implemented Time Series Analysis and Forecasting Projects, Implemented Applied Machine Learning Projects, Implemented Tensorflow and Keras Projects, Implemented PyTorch Projects, Implemented Scikit Learn Projects, Implemented Big Data Projects, Implemented Cloud Machine Learning Projects, Implemented Neural Networks Projects, Implemented OpenCV Projects,Complete ML Research Papers Summarized, Implemented Data Analytics projects, Implemented Data Visualization Projects, Implemented Data Mining Projects, Implemented Natural Leaning Processing Projects, MLOps and Deep Learning, Applied Machine Learning with Projects Series, PyTorch with Projects Series, Tensorflow and Keras with Projects Series, Scikit Learn Series with Projects, Time Series Analysis and Forecasting with Projects Series, ML System Design Case Studies Series videos will be published on our youtube channel ( just launched).

Subscribe today!

Tech Newsletter —

If you are interested, you can join my newsletter through which I send tech interview tips, techniques, patterns, hacks — Software Development, ML, Data Science, Startups and Technology projects to more than 30K readers. You can subscribe to Tech Brew :

This post is divided into —

  1. Most important/most frequently asked topic wise list
  2. Company wise list
  3. Curated List ( post)
  4. System Design list

Disclaimer : This list consists of those questions ( some of my favorite questions I ask while interviewing candidates) which gives you a very good understanding of data structures, algorithms, system design and a good grip on problem solving. This post no way endorses that you should practice only these questions; instead you must do these questions along with other questions of your choice during your preparations. good luck in advance.

Whenever I get time next weekend, I’ll write another post covering some tips, patterns and techniques to solve coding questions and how to write optimized code fast.

Highly Recommended Data Science and Machine Learning Courses that you MUST take ( with certificate) —

Complete Data Scientist

Complete Data Analyst

Complete Data Engineering

Complete Machine Learning Engineer

Complete Deep Learning

Complete Natural Language Processing

Complete Self Driving Car Engineer

Find best data science and data engineering courses here

Find best Machine Learning and Deep Learning courses here

Useful Tip — Some topics like DP, Tree, Graphs, Binary Search, Linked List are more important than other remaining topics from preparation pov.

Lets’ dive in!

Dynamic Programming

Analyzing Video using Python, OpenCV and NumPy

For complete 60 days of Data Science and ML : Day 1 — Day 60 : Quick Recap of 60 days of Data Science and ML

Clustering Geolocation Data in Python using DBSCAN and K-Means

Hyperparameter Tuning with Keras Tuner

Part 1 of Data Science and ML mega series ( Day 0 — Day 20) can be found here —

Python Iterators, Generators And Decorators Made Easy

Maths for Data Science and Machine learning

Recursion/Backtracking

100 days : Your Data Science and ML Degree

Greedy algorithms

Tree

100 days : Your Data Science and ML Degree — Part 2

Cluster Analysis using Python — Part 1

Machine Learning Clustering in detail with a project 2 ( part 1)

Linked List

Graph

Machine Learning Clustering in detail with a project 2 ( part 2)

Multiple linear regression with a project

Matrix

Array

Principal Component Analysis with a project

Binary Search

Implement Tokenization, POS tagging, Chunking, Named Entities Recognition ( NER)

Interval

Fast & Slow pointers

String

Language Classification with a project

Two Pointers

Python Crash Course — Part 1

Python Crash Course — Part 2

Sliding Window

Complete Advanced Python with Projects — Mega Compilation Part 6

Heap

Complete Python Strings

Python — Map, Classes, Functions and Arguments with Implementation

Company Wise Questions

Here we go —

Uber

Advanced Python with Code Implementation

Google

Efficient Code and Optimization techniques for Python

Goldman Sachs

60 days of Data Science and Machine Learning Series — Day 1

Byte Dance

Underscores(_) in Python

Doordash

Python’s F-Strings

Meta

6 Exceptional GitHub Repos for All Developers — Part 1

The Complete Developer’s Guide to Git

Citadel

Lyft

Airbnb

Snapchat

Square

Paypal

Databricks

Dropbox

Asana

Akuna Capital

Twitter

Twilio

Curated List — The Top & Most Frequently Asked Coding Questions You Should Practice

System Design

All the Complete System Design Series Parts —

1. System design basics

2. Horizontal and vertical scaling

3. Load balancing and Message queues

4. High level design and low level design, Consistent Hashing, Monolithic and Microservices architecture

5. Caching, Indexing, Proxies

6. Networking, How Browsers work, Content Network Delivery ( CDN)

7. Database Sharding, CAP Theorem, Database schema Design

8. Concurrency, API, Components + OOP + Abstraction

9. Estimation and Planning, Performance

10. Map Reduce, Patterns and Microservices

11. SQL vs NoSQL and Cloud

12. Most Popular System Design Questions

Github —

  • Design a concurrent Hashmap
  • Design an ATM Machine system which can support massive amount of transactions
  • Design Airport Baggage system
  • Design a Credit Card Authorization System

Major Compilation : Best Notebooks on Kaggle — Part 1

  • Design Uber
  • Design a logging system
  • Design Google Maps
  • Design a Video Conferencing System
  • Design a file storage service
  • Design a video streaming service
  • Design a chat service
  • Design a ride-sharing service
  • Design a URL shortening service

Python projects —

  • Design a social media service
  • Design a social message board
  • Design Flight Information Display system
  • Design a conference room booking system

Part 2 of Data Science and ML mega series ( Day 21 — Day 35) can be found here —

  • Design newsfeed feature of Facebook
  • Design an efficient Mail delivery system
  • Design like/dislike feature at Youtube scale.
  • Design Instagram.
  • Design Tik-Tok
  • Design twitter

Part 3 of Data Science and M Lmega series ( Day 36 — Day 48) can be found here —

  • Design metas newsfeed with live posts
  • Design a Limited Time Deals
  • Design Twitter’s trending topics
  • Design a system that counts the number of clicks on YouTube videos
  • Design Gmail
  • Design a global system to upgrade software on a fleet of machines
  • Design a recommendation system
  • Design a food sharing application
  • Design an API for a tic tac toe game
  • Design payment module for Uber app
  • Design a smart meter system
  • Build Cart as a service

Complete Data Preprocessing and Data Visualization with Projects — Mega Compilation Part 2

  • Design comment system
  • Design flight system
  • Design Tinder
  • Design survey site like surveymonkey
  • Design a geographically partitioned multi-player card game.
  • Design a kind of kindle fire application
  • Design Truecaller type of system
  • Design performance management system (appraisal workflow system) that can be used across companies.

The Most Hilarious Code Comments Ever

  • Design Instant Messenger.
  • Design a CDN network
  • Design a Google document system
  • Design a random ID generation system
  • Design a key-value database
  • Design the Facebook news feed function
  • Design a realtime Video chat like Google Duo
  • Design News paper & Magazine subscription system
  • Design a system like Hackerrank/Top Coder
  • Design an API Rate Limiter
  • Design a proximity server
  • Design a Type-Ahead service
  • Design a traffic control system
  • Design amazon’s frequently viewed product page

Build Machine Learning Pipelines( With Code)

  • Design a toll system for highways.
  • Design URL Shortener.
  • Design an online poker game for multiplayer.
  • Design a graph search function
  • Design a picture sharing system
  • Design an API Rate Limiter system for GitHub or Firebase sites
  • Design a search engine
  • Design a recommendation system
  • Design What’s up
  • Discussion and designing LRU cache.

Recurrent Neural Network with Keras

  • Design a forum-like systems like Quora, Reddit or HackerNews.
  • Design the Facebook timeline function
  • Design a function to return the top k requests during past time interval
  • Design an online multiplayer card game

Custom Layers in Keras

  • Design a website like Pastebin.
  • Design Google’s Web Crawler
  • Design Zoom
  • Design Twitter
  • Design a recommendation system for products.
  • Design a tinyurl system
  • Design Paypal
  • Design Air traffic control system
  • Design Google Maps
  • Design Grammarly
  • Design AirBNB
  • Design a vending machine in Java
  • Design a traffic control system
  • Design a limit order book for trading systems
  • Design Online Examination Portal
  • Design RedBus
  • Design BookMyShow
  • Design a garbage collection system.
  • Design a system to capture unique addresses in the entire world
  • Design an elevator system
  • Design an e-commerce website
  • Design an e-commerce website using microservices

Curated List — The Top & Most Frequently Asked Coding Questions You Should Practice

  • Design Domain Backdooring system
  • Design Amazon Locker
  • Design Movies Review Aggregator System
  • Design offline caching system for Ecommerce platform
  • Design Amazon E-commerce
  • Design Online chess game/Multiplayer game
  • Design gaming platform.
  • Design a last-mile delivery platform
  • Design Foodpanda/Zomato/Swiggy/
  • Design Meeting Calendar system
  • Design Spotify
  • Design Promo Code API
  • Design Vending machine
  • Design splitwise
  • Design Google pay at scale
  • Design a Job schedular
  • Design Meeting Scheduler
  • Design Debugger
  • Design Automatic Parking System
  • Design malloc, free and garbage collection system.
  • Design a system for collaborating over a document
  • Design election commission architecture

ANN, Linear Regression, Decision Tree Regression and Random Forest with a project

  • Design a garbage collection system
  • Design a scalable web crawling system
  • Design the Facebook chat function
  • Design a trending topic system
  • Design Amazon Best Seller Item Service
  • Design a global chat service like Whatsapp or a facebook messenger.
  • Design dropbox’s architecture.
  • Design a picture sharing website.
  • Design a news feed
  • Design a product based on maps
  • Design commenting system
  • Design a ranking system.
  • Design Amazon Cart system
  • Design a url compression system
  • Design Elevator system.

Transfer learning and Text Classification

  • Design distributed caching system.
  • Design Amazon Locker Service.
  • Design Dropbox or Google Drive

Natural Language Processing and Convolutions

  • Design Google Search
  • Design Facebook
  • Design Snapchat
  • Design Instagram
  • Design App-store
  • Design a music player application
  • Design a distributed LRU Cache

Bidirectional Encoder Representations from Transformers ( BERT) with a project

  • Design subscription based sports website
  • Design Netflix
  • Design Quora
  • Design Lookahead system
  • Design Google Docs/ Collaborative Editing service
  • Design URL Shortner service
  • Design Whatsapp

Quick Recap : 30 days of Natural Language Processing ( NLP) with Projects Series

  • Design a Latency Management System
  • Design a Library Management System
  • Design a Notification service
  • Design ESPN/Cricinfo/Cricbuzz
  • Design Uber

30 days of Data Analytics Series —

Day 1 : Data Analytics basics and kickstart of Data analytics with projects series

Day 2: Business Understanding — Data Driven Decision Making, Descriptive Analysis, Predictive Analysis, Diagnostic Analysis, Prescriptive Analysis

Day 3 : Data Analytics Ecosystem — Data Life Cycle, Data Analysis complete process ( most important things)

Day 4 : Probability, Conditional Probability, Binomial Distribution, Probability Density Function, Sampling Distribution

Day 5 : Statistics

Day 6 : Basic and Advanced SQL

Day 7 : Data Collection, Data Cleaning and Python

Day 8 : Pandas and Numpy

Day 9 : Data Manipulation

Day 10 : Data Visualization — Part 1

Day 11 : Project 1 : Data Visualization — Part 2

Day 12 : Data Visualization — Part 3

Day 13: Tableau — Part 1

Day 14: Tableau — Part 2

Day 15: Tableau — Part 3

Tableau Project

Day 16 : Data Analysis Project 2

Day 17 : Data Analysis Project 3

Day 18: Data Analysis Project 4

Day 19: Data Analysis Project 5

Day 20 : Data Analysis Project 6

Categorical and Numerical Features

Missing Value Analysis

Fill the missing Values

Unique Value Analysis

Univariate Analysis

Bivariate Analysis

Multivariate Analysis

Correlation Analysis

Day 21 : Data Analysis Project 7

Data Profiling

Feature Engineering

GroupBy Features

Categorical and Numerical Features

Missing Value Analysis

Fill the missing Values

Unique Value Analysis

Univariate Analysis

Bivariate Analysis

Multivariate Analysis

Correlation Analysis

Day 22 : Data analysis Project 8

Linear Regression

Data Profiling

Feature Engineering

Sort Values

Categorical and Numerical Features

Missing Value Analysis

Unique Value Analysis

Univariate Analysis

Bivariate Analysis

Multivariate Analysis

Correlation Analysis

Correlation Coefficients

Take Complete Hands On Tableau Course : Link

Happy learning and keep coding :)

Some of the links are affiliates.

Follow for more updates, stay tuned and of-course let me end this post with a quote by Steve Jobs ;)

“Your work is going to fill a large part of your life, and the only way to be truly satisfied is to do what you believe is great work. And the only way to do great work is to love what you do. If you haven’t found it yet, keep looking. Don’t settle. As with all matters of the heart, you’ll know when you find it.”

Tech
Software Development
Programming
Data Science
Machine Learning
Recommended from ReadMedium