Amazon·Software Engineer·Technical Phone Screen
- Which Linux and Unix commands do you use regularly, and how do they fit into your actual day-to-day work as an engineer?
- What kinds of SQL queries can you write, and how do you go from a vague business question to an actual working query?
- How do joins affect row counts, and what do you watch out for when writing them?
- How would you write a query to get the most recent record for each user?
“I started listing commands alphabetically like an idiot before catching myself and grouping them by what they're for.”