Ghost in the SQL Data
115 ratings
Description
Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.
Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.
Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.
Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!
System requirements
WINDOWS:
Minimum:
- OS: Windows 10 (64-bit)
- Processor: Dual Core 2,0 GHz (Intel Core i3)
- Memory: 4 GB RAM
- Graphics: Intel HD Graphics 4000 (support WebGL / DirectX 11)
- Storage: 1 GB available space
Recommended:
- OS: Windows 10/11 (64-bit)
- Processor: Quad Core 2,5 GHz or more
- Memory: 8 GB RAM
- Graphics: GPU (Intel Iris Xe / AMD Vega 8)
- Storage: 1 GB available space
MACOS:
Minimum:
- OS: macOS 11
- Processor: Apple M1 or Intel Core i5
- Memory: 4 GB RAM
Recommended:
- OS: macOS 11+
- Processor: Apple M1 or Intel Core i5
- Memory: 8 GB RAM
