SeattleDataGuy

Posted on Sep 15, 2019 • Edited on Dec 9, 2019

Software Engineer Interview The Interview Study Guide For Software Engineers

#career #beginners #sql #python

Software engineering interviews, like other technical interviews, require plenty of preparation. There are a number of subjects that need to be covered in order to ensure you are ready for back-to-back questions on algorithms, data structures, design, optimization and honestly just an ever growing basket of subjects.

So I created a checklist on my last round of interviews that covers many of the popular topics.

To help you keep track of your progress, we've compiled a comprehensive checklist of the same problems listed below; that list can be found here.

Warm Up With The Classics

How did you do? Take a moment and rate yourself on these classics. We have been asked most of these at some point in the interview process---and often early on as weed-out style questions. They often have less to do with algorithms and data structures, but still require a good understanding of loops and arrays (yes, an array is a data structure).

Algorithms And Data Structures

Pre-Study Problems

Before going through the video content about data structures and algorithms, consider trying out these problems below. See if you can answer them. This will help you know what to focus on.

Algorithms And Data Structures Videos

Dynamic Programming

String Manipulation

Coding Interview Question and Answer: Longest Consecutive Characters --- Video
Sedgewick --- Substring Search --- Video

Interview Problem Walk-throughs

Google Coding Interview --- Universal Value Tree Problem --- Video
Google Coding Interview Question and Answer #1: First Recurring Character --- Video
Find min and max element in a binary search tree --- Video
Find height of a binary tree --- Video
Check if a binary tree is binary search tree or not --- Video
What Is Tail Recursion? Why Is It So Bad? --- Video

Post-Study Problems

Now that you have studied for a bit, and watched a few videos, let's try some more problems!

Operational Programming Problems

Some companies won't ask you algorithm problems. Instead, they might focus more on implementation and operational problems. These are usually more niche and involve practical problems, like looping through data and performing a task of some sort. These types of problems don't usually require as much practice because it is more about taking basic concepts like arrays and HashMaps and keeping track of what you are doing to them.

System Design Videos

System design questions are crucial questions that show you are more than just a coder. You need to be able to think big picture as an engineer. Where do certain services belong, what kind of servers do you need, how would you manage traffic, etc. All of these ideas show that you are able to design software, not just code what people tell you to code.

Parking Lot System --- Video
Whats App --- Video
Uber design --- Video
Instagram --- Video
Tinder Service --- Video

Operating Systems

Operating system questions are a little more rare, but it is good to have a solid understanding of concepts like threads, scheduling, memory, etc., even if it is just a basic understanding. It is very embarrassing to get asked what the difference is between a process and a thread and not know the answer.

Threads

Object Oriented

Similar to operating systems, not every interview will ask you about object-oriented programming, but you never know. You want to make sure you remember your basics from your computer 162 course.

Java Programming Tutorial --- 49 --- Inheritance --- Video
Java Programming Tutorial --- 55 --- Introduction to Polymorphism --- Video
Java Programming Tutorial --- 58 --- Abstract and Concrete Classes --- Video
Java Programming Tutorial --- 57 --- Overriding Rules --- Video
Java Programming Tutorial --- 59 --- Class to Hold Objects
Object-Oriented Programming --- Video

Design Patterns

If you were like us, we weren't taught about all the various design patterns. So it's good to get an understanding of how they work and why you would use them. Some interview questions can be as simple as, "Why would you use a factory class?"

Factory Design Pattern --- Video
Observer Design Pattern --- Video
Adapter Design Pattern --- Video
Facade Design Pattern --- Video
Chain of Responsibility Design Pattern --- Video
Interpreter Design Pattern --- Video
Singleton Design Pattern Tutorial --- Video
Chapter 6 (Part 1) --- Patterns (video) --- Video
Head First Design Patterns --- Video

SQL

This is the last section. Many of you probably won't be asked that many SQL questions. However, I always think it is good to have in your back pocket.

SQL --- Problems

SQL --- Videos

IQ15: 6 SQL Query Interview Questions --- Video
Learning about ROW_NUMBER and Analytic Functions --- Video
Advanced Implementation Of Analytic Functions --- Video
Advanced Implementation Of Analytic Functions Part 2 --- Video
Wise Owl SQL Videos --- Video

Post SQL Problems

Interviewing can be tough because you can feel like you are making no progress. Having this study guide will help you track your progress and give you a better read on how you are doing!

Good luck!

Also, if you are looking to read/watch more great posts or videos:
Connecting To Big Query Using Jupyter Notebook On SaturnCloud Part 2

Three Books You Should Read As A Data Scientist
Hadoop Vs Relational Databases
How Algorithms Can Become Unethical and Biased
How To Improve Your Data Driven Strategy
How To Develop Robust Algorithms
4 Must Have Skills For Data Scientists
SQL Best Practices — Designing An ETL Video

Top comments (81)

scottshipp • Sep 16 '19

I think we really need to face a reckoning in our profession. And the reckoning is this: requiring an overload of stuff that's simply not-important on-the-job just to get through the interviewing process and land a position.

Some of it is mildly useful for the actual job. But the rest of it is a bunch of hurdles that we don't need to put in the way of people.

And we need to do a much better job of building bridges into the profession that actually build people up into valuable devs.

The current approach of "leetcode" gatekeeping to the industry is a failure.

SeattleDataGuy • Sep 16 '19

I think many developers and engineers hold this same sentiment. Most of us study really hard to figure out how to reverse a binary tree into a linked list blah blah blah(I hope you get thats a joke)....and then we get the job and....

We are just calling APIs of libraries developed by people before us. So what was the point. So yes, there are many of us that agree. But, since this is still the current way, I hope this list can be useful but would also like to see it deprecated :).

Zack Z. • Sep 18 '19

It's hard to demand change when you're interviewing for a new job. However, once you have the job, I think it's a lot easier to demand change. Be that person who asks, "Why are we doing interviewing like this?" Be that person who says, "This interview question provides no useful signal." Be that person who says, "We shouldn't use Leetcode / Hackerrank / etc. as a filtering step."

Olle Linux • Sep 17 '19

Very true! Still thanks for the great list of 'todo\'s'

EuroWhisper • Sep 18 '19

I'm very glad to see that this is the top comment on the article. Honestly, these hiring processes that start with some algorithm challenges straight out of that controversial "Cracking The Coding Interview" book benefit nobody, but hurt everyone.

It reinforces the "imposter syndrome" experienced by many perfectly competent candidates and companies basically rob themselves of valuable prospective employees by insisting on taking this approach to interviewing.

As someone looking for their first frontend job... Can I solve a bunch of advanced algorithm challenges? Nope, I don't have the computer science background for that. But can I build a reusable component library, consume REST/GraphQL API's to communicate with the server and display data in a sensible way on the client-side? I sure can.

Yet, people like me are being glossed over, even though we are perfectly able of solving real-world problems.

I suppose another way to look at it each time this happens is "the trash took itself out". As in, if this is their hiring practice and they see nothing wrong with it, would I like working for that company anyway? Though, that doesn't help me get my foot in the door.

rjlacanlaled • Sep 19 '19

But they need to know your skills are above average as to effectively Google search the simple solution to their "super project" needs.

javyer12 • Aug 21 '22

100% true, I'm learning frontend, and some of these examples overwhelm me, but I still find the challenge of learning it interesting

EuroWhisper • Aug 22 '22

Don't worry about it too much, it's now 3 years since I made that comment. I still suck at solving these "brainteasers" that are pointlessly used at interviews and I'm working for a nice company where I'm well respected, have been told I'm approaching senior level very quickly and am involved in training juniors. I don't bother practicing brain teasers at all, in fact. I instead put my effort into learning "advanced" React features, NextJS, some AWS basics and now looking into Svelte and judging by the salary increases, it was a good idea.

Lee Smith 🍻 • Sep 17 '19 • Edited

This is all well and good...brings back a lot of memories from undergrad school.

But after enduring such an interview from a company, PLEASE PLEASE PLEASE don't forget to then ask your interviewer how they've used/applied said "algorithms, data structures, design, optimization and honestly just an ever growing basket of subjects" in their CURRENT work.

If you get a blank stare back, you'll know that you were just put through an "interview" that was essentially algorithm hazing and nothing more. I'd seriously question whether or not I'd want to work for this company.

Bob Edmison • Sep 18 '19

This x 1000. I interviewed with a Big Name Company once, early in my career, and was asked some question about implementing a AVL tree or some such. I asked the guy ( and it was a guy because they all were at Big Name Company, but that's a diff issue ) if he had ever, in his entire working life at that place, ever implemented an AVL tree, or any other primitive data structure from scratch. When he said "no", I asked why they were asking me how to do it. He said because they always asked that question. I said I'd answer when I had my data structures book handy. I got the gig anyway.

These questions are pointless. I'm a hiring manager now. I never ask interviewees questions about how to implement basic structures or algorithms. If someone is rolling their own now, they need to have a damn good reason for it. However, I will ask questions to tease out if they understand WHEN AND HOW TO USE different algorithms, structures, design patterns, etc, and the tradeoffs associates with those choices. I think that is fair game, and also a better indicator of what kind of software engineer you will be.

If you can code up a quick sort, but I don't ask you that kind of sort to use in a given situation , and then don't find out until after I hire you that you use bubble sorts for everything, me knowing you can code a quick sort is not terribly helpful.

Theofanis Despoudis • Feb 22 '20

You were asked for AVL tree? Jesus

Adarsh Menon • Aug 2 '20

I was asked - what is the data structure that databases usually use to store data. I said B trees or B+ trees (we were discussing indexing, fan-out et.. ). Then he said ok now implement a B tree with all the crud operations. I told him I can explain the logic to you, but I don't think i can code that. Maybe I could, but it would take me a log time to convert the logic into code.

Eddie • Sep 19 '19

Thirthirded

Bob McCann • Sep 17 '19

100% this! Same with not allowing you to use Google as you attempt to formulate a solution. I assume you would be allowed to use Google day-to-day as you perform your job, right?

Kevin Lang • Sep 20 '19

Exactly! I'm disappointed by how many people accept these whiteboarding rituals as a necessary or unavoidable evil. They aren't. There are plenty of companies out there that offer more sane alternatives that mirror day-to-day work.

Akash • Aug 13 '22

@leesmith That's super good advice. I always shout my guts out to people I chat with that this type of convention or practice that is going on in the soft dev world is so useless but more often than not I get that 'stop cribbing' look back or just some ignorant view point back which makes me think that people are just whizzing through life mindlessly, like they don't actually care. Anyways, I am definitely gonna raise this question in my next interview of how they have used what they are asking me in their work on a day to day basis. It'll be super fun (and maybe a little risky) xd

Emmanuel Okiche • Sep 18 '19

Seconded!!

Belverus • Sep 16 '19

Seems like I will never be ready :)

Ola' John Ajiboye • Sep 20 '19

In first interview. I was asked to sum up all integers in an array. I used reduced method.interviewer asked me to use for loop instead. I completely froze. They laughed at me an sent me out. That was a push in the right direction for me.

Belverus • Sep 20 '19 • Edited

I was asked:

OOP & all related concepts on Java. It was very detailed. (answered 85%)
Data Structures & Algorithms (BST, RB Tree, Sets, Maps, Hashing, Graphs, BFS, DFS, MSP, etc..) (answered 90%)
SQL: they nearly asked every single keyword on SQL. (answered 99%)
Implemented a LinkedList on a blackboard. Then they made me do couple of sorting algorithms on that.
HTML & CSS live-coding.

And they rejected me yesterday because I don't know JS Which was already very clear on my resume. This was a junior FE position :)

SeattleDataGuy • Sep 20 '19

Welcome to interviewing....

Ola' John Ajiboye • Sep 20 '19

Most companies have no clue how to interview and the process is similar for senior and Junior. I interviewed at another company for an internship where I was asked to implement a LinkedList in Java even though I made it clear I was more into Javascript. But somehow I did well because I was prepared for anything. The interview gave a glowing review and said he was really impressed. The recruiter contacted me to ask if I had another offer I was considering, I said No. Then he said they were going to interview other candidates. Next thing I heard was that they picked other guys.

I just kep working harder. Months after that I got a dream offer. I am glad I missed that opportunity.I would have had to start form an intern. But I got another offer as solid mid-level Engineer. Just keep pushing. Itäs a matter of time. I was rejected around 300times , some after 6 rounds.

SeattleDataGuy • Sep 16 '19

Don't let this stress you out. You don't need to do every problem to be ready. I just recommend doing a few of each. Doing an interview or two, seeing where you need to study and then do more :).

Belverus • Sep 16 '19

I did my first interview today. It was bad. Not that bad as I imagined. I could answer what I learned since from the start. I was already aware but rediscovered that I need to learn a lot.

Thanks for the boost!

SeattleDataGuy • Sep 16 '19

We have all had that first interview. I remember my first interview at Amazon. The very first question shut me down and I froze and just couldn't think of a good answer. Luckily the interviewer allowed me to move on so I could get some answers in. But those first interviews show you what you don't know...it's painful but good :);

Belverus • Sep 16 '19

Haha exactly. Happened to me either. I asked to "move on" and get back to that question "later".

Chris Achard • Sep 16 '19 • Edited

You know something's going to be a great resource when it already has a whole bunch of "saved for later" tags 😃

Great list! Love that you included more than just algorithms (like system design, etc too). Even if you're not interviewing right now, it's a great idea to just pick a few videos off the list and watch them :)

Thanks!

SeattleDataGuy • Sep 17 '19

Thanks for your kind words! Yes almost 1k saves as of right now. I really tried to make it comprehensive. Also, that isn't meant to intimidate anyone. The reason I add a checklist is so you can do a few in each section and go for an interview. Figure out where you need to work on things and focus on that area.

Nihar Raote • Sep 20 '19

Took only 3 days for that number to jump up to 2000. Just goes to show how awesome this checklist is. Thanks for creating this!

SeattleDataGuy • Sep 20 '19

It's crazy how fast it got liked o.O

Cristiano D. Silva • Sep 17 '19

Questions like these do not prove that the candidate has knowledge or experience, it only proves that the candidate has academic experience.

The test that I give to all my candidates is simple and direct to the point. It expects that the candidate knows engineering and coding and test those aspects with non-standard questions and problems that could have more than one solution where you could verify how the candidate responded the question and follow up with him/her about it.

This is my opinion off course but it does seem foolish applying tests like this.