Hands-on Introduction to Database Design and Implementation + BYO data/problem

Workshops providing an introduction to
database design and query. Using a relational database can help you store and
analyze your research data and results more efficiently.

September 26, 2017
2 pm - 5 pm
Location
37 Dewey Field Rd, Instructional Center (1st floor)
Sponsored by
Information Technology Services
Audience
Alumni, Faculty, Public, Staff, Students-Graduate, Students-Undergraduate
Registration required
More information
Christian Darabos

In the first workshop, we will be using the relational database paradigm, the
Unified Modeling Language (UML), the Entity-Relationship (ER) model, and
implement a simple MySQL database. In the second workshop, 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 Design will be followed by an
Introduction to Database Query and Analytics.
Course Length: 2 hours + instructor will be available after the course to
answer your specific questions and requests

Free registration required and more information: rc.dartmouth.edu > Training


Required free registration and more info: rc.dartmouth.edu > Training
 

DB design: http://libcal.dartmouth.edu/event/3431329
DB query: http://libcal.dartmouth.edu/event/3431330

 

Location
37 Dewey Field Rd, Instructional Center (1st floor)
Sponsored by
Information Technology Services
Audience
Alumni, Faculty, Public, Staff, Students-Graduate, Students-Undergraduate
Registration required
More information
Christian Darabos