LAYER 2 · DATA & INTEGRATION · STAGE 2
SQL for FDEs
Quick answer
The language of the customer's data warehouse and application databases. The first question on any deployment is what is in the data, and SQL answers it.
Practise it
- 1. Join three tables and explain the row counts
- 2. Write a window-function report
- 3. Spot and fix a fan-out join
Where it sits
Stage 2 of the roadmap: Data and APIs. You can move data between two systems and keep it correct.
Field problems
Map a client's CRM fields to a warehouse schema [ EASY ]Portfolio projects
Weekly KPI report from a messy databaseA gap skill for: frontend engineers, web developers, deployment strategists