Home » Teaching » BINF 697 - Spring 2023

Databases for Bioinformatics (BINF 697 - Spring 2023)

This course provides a hands-on introduction data modeling and databases for bioinformatics.

Course Director

Nathan Edwards, PhD
nje5@georgetown.edu
2115 Wisconsin Ave, NW, Suite G1-040A

Time and Place

Lectures:

2115 Wisconsin Ave, NW, Room G1-001
Friday 10:00am - 1:00pm.

Important Links

• Course Software
• Data Directory
• Canvas (Announcements, Assignments)

Syllabus

Date	Room	Description	Resources
Fri 1/13/2023 10-1pm	WIS2115 G1-001	Conceptual Data Modeling	Administrivia, Lecture 1: Slides, Recording (mp4)
Fri 1/20/2023 10-1pm	WIS2115 G1-001	Logical Data Modeling Attributes, Primary Keys, and Identity	Lecture 2: Slides, Recording (mp4)
Fri 1/27/2023 10-1pm	WIS2115 G1-001	Logical Data Modeling Normalization	Lecture 3: Slides, Recording (mp4)
Fri 2/3/2023 10-1pm	WIS2115 G1-001	Physical Data Modeling	Lecture 4: Slides, Recording (mp4)
Fri 2/10/2023 10-1pm	WIS2115 G1-001	Extract, Transform, Load (ETL)	Lecture 5: Slides, Recording (mp4)
Fri 2/17/2023 10-1pm	WIS2115 G1-001	SQL Basics select, insert, update	Lecture 6: Slides, Recording (mp4)
Fri 2/24/2023 10-1pm	WIS2115 G1-001	Advanced SQL joins, group by, subqueries	Lecture 7: Slides, Recording (mp4)
Fri 3/3/2023 10-1pm	WIS2115 G1-001	Indexes and Performance	Lecture 8: Slides, Recording (mp4)
Fri 3/10/2023		Spring Break No class.
Fri 3/17/2023 10-1pm	WIS2115 G1-001	NoSQL and Document Stores	Lecture 9: Slides, Recording (mp4)
Fri 3/24/2023 10-1pm	WIS2115 G1-001	Web-Services and REST APIs	Lecture 10: Slides, Recording (mp4)
Fri 3/31/2023 10-1pm	WIS2115 G1-220	HTML, Forms, Tables, CSS	Lecture 11: Slides, Recording (mp4)
Fri 4/7/2023		Easter Break No class.
Fri 4/14/2023 10-1pm	WIS2115 G1-001	Web-Applications and AJAX	Lecture 12: Slides, Recording (mp4)
Fri 4/21/2023		No class
Fri 4/28/2023 10-1pm	WIS2115 G1-001	Semantic-Web, Triple-Stores, and SPARQL	Lecture 13: Slides, Recording (mp4)
Fri 5/12/2021		Project Deadline