Main content



Loading wiki pages...

Wiki Version:
# 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
OSF does not support the use of Internet Explorer. For optimal performance, please switch to another browser.
This website relies on cookies to help provide a better user experience. By clicking Accept or continuing to use the site, you agree. For more information, see our Privacy Policy and information on cookie use.

Start managing your projects on the OSF today.

Free and easy to use, the Open Science Framework supports the entire research lifecycle: planning, execution, reporting, archiving, and discovery.