Research Computing offers this hands-on workshop providing an introduction to database query in Structured Query Language (SQL). Using a relational database can help you store and analyze your research data and results more efficiently (than flat/text files). We will be using SQL on a pre-populated database to extract, filter and answer simple analytics questions. If time permits, we will explore ways of programmatically accessing databases from tools such as R or Python in order to automate the analytical process.

In order to actively participate, please bring your own laptop (Mac/Win) and install the following software:

• MAMP : https://www.mamp.info/en/downloads/
• MySQL Workbench: https://dev.mysql.com/downloads/workbench/

Please do not hesitate to come 15 minutes early if you need trouble shooting with the software installation.

Please note that this Introduction to Database Query and Analytics is preceded by an Introduction to Database Design.

Limited seating available, please register at: http://libcal.dartmouth.edu/event/3077102