SQL 1: Intro
Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called structured query language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use the (free) database manager SQLite for this class.
This session is good for: People who have some experience working with data in columns and rows, in spreadsheets or database managers.
Lauryn Schroeder (@laurynschroed) is an investigative data reporter for the San Diego Union-Tribune. She previously worked for The Associated Press and took part in major data investigations with The Washington Post. She won an IRE award in 2013 for a series on shaken-baby syndrome, a controversial diagnosis that has led to hundreds of questionable, child abuse and murder convictions nationwide.
Digging Deep Into Data with SQL
Structured Query Language, SQL for short and pronounced “sequel,” is the secret sauce of relational databases. Whether you’re talking high cost database engines such as Oracle and SQL Server or open-source products such as MySQL and PostgreSQL, they all rely on dialects of this same powerful language. Some of them have complex features that take months or years to master. But at their core is something remarkably simple: SQL.