Home » Teaching » BINF 697 - Spring 2020

Databases for Bioinformatics (BINF 697 - Spring 2020)

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

Course Director

Nathan Edwards, PhD
nje5@georgetown.edu
(202) 687-7042
3300 Whitehaven St NW, Suite 1200

Time and Place

Friday 10:00am - 1:00pm.
Join Zoom Meeting
Note that a password is necessary to join this meeting.
Check Canvas for the details.

Important Links

Syllabus

Date Room Description Resources
Fri 1/10/2020
10-1pm
Harris 1300Conceptual Data ModelingAdministrivia, Lecture 1: Slides, Recording (mp4)
Fri 1/17/2020
10-1pm
Harris 1300Logical Data Modeling
Attributes, Primary Keys, and Identity
Lecture 2: Slides, Recording (mp4)
Fri 1/24/2020
10-1pm
Harris 1300Logical Data Modeling
Normalization
Lecture 3: Slides, Recording (mp4)
Fri 1/31/2020
10-1pm
Harris 1300Physical Data ModelingLecture 4: Slides, Recording (mp4)
Fri 2/7/2020
10-1pm
Harris 1300Extract, Transform, Load (ETL)Lecture 5: Slides, Recording (mp4)
Fri 2/14/2020
10-1pm
Harris 1300SQL Basics
select, insert, update
Lecture 6: Slides, Recording (mp4)
Fri 2/21/2020
10-1pm
Harris 1300Advanced SQL
joins, group by, subqueries
Lecture 7: Slides, Recording (mp4)
Fri 2/28/2020
No class
 
Fri 3/6/2020
10-1pm
Harris 1300Indexes and PerformanceLecture 8: Slides, Recording (mp4)
Fri 3/13/2020
Spring Break
No class.
Fri 3/20/2020
10-1pm
ZoomNoSQL and Document StoresLecture 9: Slides, Recording (mp4)
Fri 3/27/2020
10-1pm
ZoomWeb-Services and REST APIsLecture 10: Slides, Recording (mp4)
Fri 4/3/2020
10-1pm
ZoomHTML, Forms, Tables, CSSLecture 11: Slides, Recording (mp4)
Fri 4/10/2020
Easter Break
No class.
Fri 4/17/2020
10-1pm
ZoomWeb-Applications and AJAXLecture 12: Slides, Recording (mp4)
Fri 4/24/2020
10-1pm
ZoomSemantic-Web, Triple-Strores, and SPARQLLecture 13: Slides, Recording (mp4)
Fri 4/24/2020
Introduction to Semantic Media WikiLecture 14: Slides, Recording (mp4)
Fri 5/1/2020
10-1pm
ZoomOffice Hours
Fri 5/8/2020
Project Deadline