🛠️ Technical Support Analyst (L2) - 1 Week Preparation Plan

Welcome! This guide is designed to help you transition from a Senior Customer Support Executive to a Technical Support Analyst (L2) role at Brevo. This 7-day plan focuses on strengthening your technical knowledge in databases, APIs, monitoring tools, and general troubleshooting to prepare for interviews and the job responsibilities.

---

🗓️ Daily Breakdown

Day 1: MySQL Basics

Goals:

• Install MySQL or use an online sandbox
• Learn basic SQL operations: SELECT, INSERT, UPDATE, DELETE
• Understand joins and filtering
• Practice writing queries

Resources:

• W3Schools SQL Tutorial
• MySQL Sample Database
• DB Fiddle

---

Day 2: MongoDB Fundamentals

Goals:

• Understand NoSQL vs SQL
• Create and manage a MongoDB cluster (MongoDB Atlas or local)
• Practice basic commands: insertOne(), find(), updateOne()
• Learn to handle arrays and nested data

Resources:

• MongoDB University Free Courses
• MongoDB Atlas (Free Tier)
• Mongo Playground

---

Day 3: APIs & HTTP

Goals:

• Understand REST architecture and HTTP methods (GET, POST, PUT, DELETE)
• Learn status codes (2XX, 4XX, 5XX)
• Practice with public APIs using Postman or curl
• Read and send JSON data

Resources:

• Postman
• JSONPlaceholder (Free API)
• MDN HTTP Methods

---

Day 4: Git & Terminal Commands

Goals:

• Review core Git operations: clone, branch, commit, push, merge
• Learn terminal commands: cd, ls, cat, grep, rm, mv
• Practice using CLI tools for navigating and searching logs

Resources:

• Git Handbook
• OhMyGit Game
• Linux Command Cheat Sheet

---

Day 5: Monitoring Tools & DevTools

Goals:

• Understand basic monitoring concepts (metrics, alerts, uptime)
• Explore tools like Grafana or Datadog
• Use Chrome DevTools to inspect elements and debug web pages

Resources:

• Grafana Labs Playground
• Datadog Free Trial
• Chrome DevTools Overview

---

Day 6: SLAs, KPIs & Communication

Goals:

• Learn definitions and examples of SLAs and KPIs
• Practice explaining technical concepts clearly
• Prepare behavioral answers for interview scenarios
• Reflect on your customer-facing experience

Resources:

• SLAs & KPIs Explained
• STAR Method for Behavioral Interviews

---

Day 7: Mock Interview & Review

Goals:

• Self-quiz on SQL, MongoDB, APIs, Git, HTTP, monitoring tools
• Practice mock interview scenarios (technical + behavioral)
• Write down and rehearse answers to expected questions
• Final review of Brevo’s culture and products

Mock Scenario Ideas:

• "An API is failing with a 500 error. How would you troubleshoot?"
• "A client reports missing data in their CRM dashboard—what do you do?"
• "Describe a time you went above and beyond for a customer."

---

🧰 Tools You Should Set Up

• MySQL Workbench or DB Fiddle
• MongoDB Atlas (Free Cluster)
• Postman (for API testing)
• Git CLI or GitHub Desktop
• Chrome (with DevTools)
• Any Linux Terminal (WSL, VM, or web-based like JSLinux)

---

✅ Core Topics Checklist

Topic	Covered?
MySQL Queries & Joins	✅
MongoDB CRUD & Queries	✅
HTTP Methods & Status Codes	✅
JSON / XML Parsing	✅ / ❌
Git Commands	✅
Terminal Basics	✅
Monitoring Tools Overview	✅
SLAs / KPIs	✅ / ❌
DevTools Usage	✅ / ❌
Mock Interview Prep	✅ / ❌

---