BIT – Page 2 – Technology, Teaching and Learning

Relational Databases – SQL and selection

Materials for the second part of Databases – keys, ordering and selection in RA and SQL

Lecture slides database 2

SQL notes on ordering and selection SQL Session 2

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

code for lab (zip file)

The following material is available for Business Internet Systems and was used in the first session