Home » Teaching » BINF 697 - Spring 2021
Databases for Bioinformatics (BINF 697 - Spring 2021)
This course provides a hands-on introduction data modeling and databases for bioinformatics.
Course Director
Nathan Edwards, PhDnje5@georgetown.edu
(202) 687-7042
3300 Whitehaven St NW, Suite 1200
Time and Place
Friday 10:00am - 1:00pm. Join Zoom Meeting(A password is needed to join this meeting).
Check Canvas for details.
Virtual Instruction Details
- Lectures will be conducted synchronously via Zoom and recorded for asynchronous viewing.
- Students are not required to join the synchronous lectures, especially if time-zones or other logistical obstacles make this difficult, but attendance is recommended.
- Students are generally expected to leave their cameras on to promote active participation and engagement.
- Students are encouraged to speak up during lectures and ask questions verbally or in the chat.
- Zoom meeting links are password protected.
Important Links
- Course Homepage Short URL: http://grg.tn/binf697
- Course Software
- Data Directory
- Canvas (Announcements, Assignments)
Syllabus
| Date | Room | Description | Resources |
|---|---|---|---|
| Fri 1/29/2021 10-1pm | Zoom | Conceptual Data Modeling | Administrivia, Lecture 1: Slides, Recording (mp4) |
| Fri 2/5/2021 10-1pm | Zoom | Logical Data Modeling Attributes, Primary Keys, and Identity | Lecture 2: Slides, Recording (mp4) |
| Fri 2/12/2021 10-1pm | Zoom | Logical Data Modeling Normalization | Lecture 3: Slides, Recording (mp4) |
| Fri 2/19/2021 10-1pm | Zoom | Physical Data Modeling | Lecture 4: Slides, Recording (mp4) |
| Fri 2/26/2021 10-1pm | Zoom | Extract, Transform, Load (ETL) | Lecture 5: Slides, Recording (mp4) |
| Fri 3/5/2021 10-1pm | Zoom | SQL Basics select, insert, update | Lecture 6: Slides, Recording (mp4) |
| Fri 3/12/2021 10-1pm | Zoom | Advanced SQL joins, group by, subqueries | Lecture 7: Slides, Recording (mp4) |
| Fri 3/19/2021 10-1pm | Zoom | Indexes and Performance | Lecture 8: Slides, Recording (mp4) |
| Fri 3/26/2021 10-1pm | Zoom | NoSQL and Document Stores | Lecture 9: Slides, Recording (mp4) |
| Fri 4/2/2021 | Spring Break No class. | ||
| Fri 4/9/2021 10-1pm | Zoom | Web-Services and REST APIs | Lecture 10: Slides, Recording (mp4) |
| Fri 4/16/2021 10-1pm | Zoom | HTML, Forms, Tables, CSS | Lecture 11: Slides, Recording (mp4) |
| Fri 4/23/2021 10-1pm | Zoom | Web-Applications and AJAX | Lecture 12: Slides, Recording (mp4) |
| Fri 4/30/2021 10-1pm | Zoom | Semantic-Web, Triple-Stores, and SPARQL | Lecture 13: Slides, Recording (mp4) |
| Fri 5/7/2021 10-1pm | Zoom | Introduction to Semantic Media Wiki | Lecture 14: Slides |
| Fri 5/14/2021 | Office Hours | ||
| Fri 5/19/2021 | Project Deadline |