Coding Exercise: Monitor Failed Job Counts by Server
Practice using SQL to join, aggregate, and sort operational data from a system log perspective.
We'll cover the following
Scenario
As a junior data engineer at a cloud services company, you monitor job performance across various servers. Your team wants a quick report showing which servers have the most failed jobs, so they can investigate potential issues and optimize workload distribution.
Dataset
You’ll be working with two tables:
Get hands-on with 1400+ tech skills courses.