Home » Teaching » BINF 697 - Spring 2022
Databases for Bioinformatics (BINF 697 - Spring 2022)
This course provides a hands-on introduction data modeling and databases for bioinformatics.
Course Director
Nathan Edwards, PhDnje5@georgetown.edu
(202) 687-7042
2115 Wisconsin Ave, NW, Suite G1-040A
Time and Place
Lectures:
2115 Wisconsin Ave, NW, Room G1-001Friday 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 Software
- Data Directory
- Canvas (Announcements, Assignments)
Syllabus
| Date | Room | Description | Resources |
|---|---|---|---|
| Fri 1/14/2022 10-1pm | Zoom Only | Conceptual Data Modeling | Administrivia, Lecture 1: Slides, Recording (mp4) |
| Fri 1/21/2022 10-1pm | Zoom Only | Logical Data Modeling Attributes, Primary Keys, and Identity | Lecture 2: Slides, Recording (mp4) |
| Fri 1/28/2022 10-1pm | Zoom Only | Logical Data Modeling Normalization | Lecture 3: Slides, Recording (mp4) |
| Fri 2/4/2022 10-1pm | WIS2115 G1-001 | Physical Data Modeling | Lecture 4: Slides, Recording (mp4) |
| Fri 2/11/2022 10-1pm | WIS2115 G1-001 | Extract, Transform, Load (ETL) | Lecture 5: Slides, Recording (mp4) |
| Fri 2/18/2022 10-1pm | WIS2115 G1-001 | SQL Basics select, insert, update | Lecture 6: Slides, Recording (mp4) |
| Fri 2/25/2022 10-1pm | WIS2115 G1-001 | Advanced SQL joins, group by, subqueries | Lecture 7: Slides, Recording (mp4) |
| Fri 3/4/2022 10-1pm | WIS2115 G1-001 | Indexes and Performance | Lecture 8: Slides, Recording (mp4) |
| Fri 3/11/2022 | Spring Break No class. | ||
| Fri 3/18/2022 10-1pm | WIS2115 G1-001 | NoSQL and Document Stores | Lecture 9: Slides, Recording (mp4) |
| Fri 3/25/2022 10-1pm | WIS2115 G1-001 | Web-Services and REST APIs | Lecture 10: Slides, Recording (mp4) |
| Fri 4/1/2022 10-1pm | WIS2115 G1-001 | HTML, Forms, Tables, CSS | Lecture 11: Slides, Recording (mp4) |
| Fri 4/8/2022 10-1pm | WIS2115 G1-001 | Web-Applications and AJAX | Lecture 12: Slides, Recording (mp4) |
| Fri 4/15/2022 | Easter Break No class. | ||
| Fri 4/22/2022 10-1pm | WIS2115 G1-001 | Semantic-Web, Triple-Stores, and SPARQL | Lecture 13: Slides, Recording (mp4) |
| Fri 4/29/2022 10-1pm | WIS2115 G1-001 | Introduction to Semantic Media Wiki | Lecture 14: Slides, Recording (mp4) |
| Fri 5/13/2021 | Project Deadline |