Archive

Archive for November, 2013

BITS week 8 and 9

November 18th, 2013 No comments

Lecture slides on Cartesian Product and Join – database 3 2011 handouts

Lab exercise on CP and Join – SQL Session 3

 

More advanced Joins –database 3 join extra 2007 3 slides handouts

Lab exercises on more advanced Joins –SQL SESSION OUTER

 

Lecture slides on writing queries for dummies – database 4 2007 handouts

Lab exercises on DDL/DML – SQL Session 4

Categories: BIS, BIT, Databases Tags:

BITS week 7

November 11th, 2013 No comments

Material for BITS week 7

Slides onĀ  TCP/IP

Slides on selection in RA and SQL database 2 2007 handouts 3 slides

Lab notes and exercises SQL Session 2

Categories: BIT, Databases Tags:

BITS week 6

November 4th, 2013 No comments

This weeks materials are an introduction to database systems and the relational model

The lecture slides used for the first session on databases relational database handout slides

SQL file required to set up the EMP database in mySQL empDB

SQL notes on using mySQL and the projection statement SQL Session 1

Notes on setting up your own version of MAMP (mac) Installing and using MAMP

Notes on setting up your own version of XAMPP (Windows 7) Installing and using XAMPP

Categories: BIT, Databases Tags: ,