Schedule for Databases For Biologists

Week 1: Introduction, Creating Databases, Adding Data

Material:

• Introduction

Week 2: Selecting, Filtering, Sorting, and Aggregating Data

Material:

• Selecting
• Filtering
• Sorting
• Aggregation
• Nulls

Assignment 1

Week 3: Joins, Database Structure, Nested Queries

Material:

• Joins
• Nested Queries

Assignment 2

Week 4: Controlling Input and Output: Forms, QA/QC, Reports + SQL

Material:

• Forms
• Reports
• Databases using SQL

Assignment 3