Lead by Timo Grossenbacher, Project Lead Automated Journalism at Tamedia
You can model different phenomena in your data, as well as the relationships between them. This gives your data structure and consistency, which results in better data quality. In this course, you'll experience this firsthand by working with a real-life dataset that was used to investigate questionable university affiliations. You'll learn how to create tables and specify their relationships, as well as how to enforce data integrity. You'll also discover other unique features of database systems, such as constraints.
Create your very first database with a set of simple SQL commands. Next, migrate data from existing flat tables into that database. Learn how meta-information about a database can be queried.
Specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.
Add primary and foreign keys to the tables.
Leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. Run ad hoc analyses on your new database.