6001 structure & interpretation of computer programs recitation 8/ october 10, 1997

11/19/97


Click here to start


Table of Contents

6001 structure & interpretation of computer programs recitation 8/ october 10, 1997

overview

history

what’s a database?

the big idea

tables

queries

queries on a single table

simple queries, continued

combining queries

relational join

example of a join

queries involving two tables

more example queries

query optimization

join of tables with shared column names

query optimizations

puzzles for student presentations

Author: Daniel Jackson

Email: dnj@lcs.mit.edu

Home Page: http://www.pdos.lcs.mit.edu/~dnj

Download presentation source