GETTHEOFFER.DEV

Mock Interviews

1How much time does it take?2Rejections 3I need experience to get experience 4Referral 5CV 6How to stand out 7Investigate the company 8Useful resources

Do and Don'ts 10Be human Why do you want to work at our company Why are you switching Technical questions from HR What are your salary expectations Interview with the Hiring Manager

16Before We Begin Try to talk about the problems of the system instead of the advantages What is Concurrency ACID Isolation levels And Common Sense Isolation levels And The Twist Optimistic and Pessimistic locks A Bit More About Locks Indexes, Part 1: Main Types Indexes, Part 2: Composite index Indexes, Part 3: Clustered vs Non-Clustered 27Indexes, Part 4: Geospatial SQL traps, Part 1 SQL traps, Part 2 SQL traps, Part 3 How to improve a slow database Problems with ORMs Troubles with distributed systems Monolith vs Microservices gRPC vs HTTP RabbitMQ and Kafka How do you deal with traffic Kubernetes: Part 1, Recap Kubernetes: Part 2, Interview Kubernetes: Part 3, GitOps The Problem with Open Source

42Leetcode Home Coding Interview

44Prepare the whiteboard What NOT to do Back-of-the-Envelope Math SQL vs NoSQL CAP Protocols Universal Patterns Know the Tricks, Part 1 Know the Tricks, Part 2 Know the Tricks, Part 3 All the concepts

55Intro Focus on the Business Need What is SCRUM From Idea to Production How Do You Test Observability What is your code smell How can you deal with an argument at work I need to give you more work at the end of the sprint

64State of Tech Today AI Enthusiasm Determinism vs Non-Determinism Tokenomics

68Salary Negotiation How to pass the probation period Sell Yourself Story of 2 Engineers Who Wanted a Promotion

72Interview is not an exam Which Grades to Apply to HRs are ghosting me Gut feeling My company offers me more money Books to Read Good and seamless habits Afterword

Course

Course

Mock Interviews

1How much time does it take?2Rejections 3I need experience to get experience 4Referral 5CV 6How to stand out 7Investigate the company 8Useful resources

Do and Don'ts 10Be human Why do you want to work at our company Why are you switching Technical questions from HR What are your salary expectations Interview with the Hiring Manager

16Before We Begin Try to talk about the problems of the system instead of the advantages What is Concurrency ACID Isolation levels And Common Sense Isolation levels And The Twist Optimistic and Pessimistic locks A Bit More About Locks Indexes, Part 1: Main Types Indexes, Part 2: Composite index Indexes, Part 3: Clustered vs Non-Clustered 27Indexes, Part 4: Geospatial SQL traps, Part 1 SQL traps, Part 2 SQL traps, Part 3 How to improve a slow database Problems with ORMs Troubles with distributed systems Monolith vs Microservices gRPC vs HTTP RabbitMQ and Kafka How do you deal with traffic Kubernetes: Part 1, Recap Kubernetes: Part 2, Interview Kubernetes: Part 3, GitOps The Problem with Open Source

42Leetcode Home Coding Interview

44Prepare the whiteboard What NOT to do Back-of-the-Envelope Math SQL vs NoSQL CAP Protocols Universal Patterns Know the Tricks, Part 1 Know the Tricks, Part 2 Know the Tricks, Part 3 All the concepts

55Intro Focus on the Business Need What is SCRUM From Idea to Production How Do You Test Observability What is your code smell How can you deal with an argument at work I need to give you more work at the end of the sprint

64State of Tech Today AI Enthusiasm Determinism vs Non-Determinism Tokenomics

68Salary Negotiation How to pass the probation period Sell Yourself Story of 2 Engineers Who Wanted a Promotion

72Interview is not an exam Which Grades to Apply to HRs are ghosting me Gut feeling My company offers me more money Books to Read Good and seamless habits Afterword

Loading…

Get Hired/Technical Interview/Indexes, Part 4: Geospatial

Chapter 27

Indexes, Part 4: Geospatial

Part of the full course

Unlock this chapter

This one is part of the paid course. Everything before the interview, the free sampler articles, the Core Java drills, and mock interviews stay open either way.

Buy Course Buy Course + Mock Interview

Keep going

Technical InterviewHow to improve a slow database
Technical InterviewSQL traps, Part 2
Technical InterviewIndexes, Part 2: Composite index