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
Fred Hutchinson Cancer Research Center