Databases are powerful systems that can help you to manage, explore, and get value out of your data. They’re particularly useful if you’ve got multiple data files with relationships between them. Databases allow you to impose constraints on your data, generate insightful reports, transform data, and ask complex questions. This two hour workshop gives you an introduction to the basic concepts required to start using databases for your next project.
Material covered in the workshop will include:
- Background: Learn when to use a database and which database software to use for your project
- Principles of database design: Learn to structure your data in a way that provides the most flexibility while avoiding common pitfalls
- Queries: Use SQL to search, subset, combine and manipulate your data
Please bring a laptop computer for your own use during the workshop. No specialized software is required to participate in this workshop.
This workshop is part of the the Data Skills series.