insideout Get Pro

07 · Logs as data: SQL, time and joins

Pro

Computing Foundations, lesson 7

Logs as data: SQL, time and joins

Query logs with SQL, and line events up across time zones.

An incident rarely sits in one log. A VPN, an app and a help desk each saw part of it, each wrote time its own way, and one clock was wrong. This lesson loads their lines into tables you question with SQL, puts every time on one clock, and joins the sources into one account. You need the previous lesson's Python.

Part of Pro

In this lesson
  1. Logs as tables
  2. One clock for every log
  3. When a clock is wrong
  4. Joining two logs

Cybersecurity comes with Pro: every lesson in every module.

Computing Foundations overviewSpotted a mistake? Tell us.