Thurs

Lab: Writing R Packages

Lab: Writing R Packages (code)

Lab: Annotation Package to DB

Walks through extraction of data from the hgu95av2 annotation data package into text files suitable for import into SQLite or other RDBMS.

Lab: Annotation Package to DB (code)

Lab: How to use DBI

Demonstrates use of DBI using SQLite. You will also want to download the hgu95av2-sqlite database.

Lab: How to use DBI (code)

Lab: How to use SQLite

Introduces RDBMS concepts and SQL using SQLite. You will need a sqlite command line program for this lab. See the Software section.

hgu95av2 SQLite example database

You will need this for the DBI lab

hgu95av2 text files

These are the outputs of the Annotation 2 DB lab. They can be used to import data into SQLite and create a database equivalent to the example SQLite database posted on this page

SQL Schema for annotation DB

Example package DNAHelperUSER