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
- Logs as tables
- One clock for every log
- When a clock is wrong
- Joining two logs
Cybersecurity comes with Pro: every lesson in every module.
Computing Foundations overviewSpotted a mistake? Tell us.