CST 363 Intro to Database Systems Module 5: Indexing and Transactions

5.1 Review

CST 363 Intro to Database Systems Module 4 : Java Web Programs and DB

 

4.0 Review

CST 363 Intro to Database Systems Module 3: DB Design

3.0 Review

CST 363 Intro to Database Systems Module 2: Advanced SQL

2.1 SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).  As long the column(s) are type compatible 98% of the time, the join uses the primary key of one table, the foreign key of the other table and equal predicate.  Think of example where joining on something other than keys would be needed.  Write the query both as English sentence and SQL.  If you can't think of your own example, search the internet for an example.

CST363 Intro to Database Systems Module 1: Relational DB and SQL

1.1 Relational tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two?