# Introduction to SQL and Research Databases Text files are fine when you have thousands of observations, but what do you do when you have millions (or billions)? In this workshop, participants will learn about choices in database technology that support data at scale; the building blocks of schema design; how to write SQL queries to retrieve, delete, insert, and update data in a SQLite database; and how to connect their database with an R or Python script. This workshop will cover: * Tools of the trade: Creating and accessing a database using software tools * Basic database design: What are tables, relations, indices, etc. * SQL and all that CRUD * Create (or import): Tables and data * Retrieve: Querying and exporting data in a way that makes sense * Update: Changing table structure and data they house * Delete: Deleting rows of data, truncating tables, deleting tables * Scripting and SQL: Writing scripts to access, view and manipulate data To be successful, you should have: * A laptop to bring to the workshop * Optional: Install Python and SQLite on your laptop (we recommend Anaconda). There will be an online environment available for using Python or R, so local installation is not required. * Some familiarity with the concept of a relational database An intro-level familiarity with the Python programming language and/or R April 2022