Links

The Future of SQL Server — by torp — last modified Jan 21, 2009 07:18 PM

"ACM Turing Award winner and Microsoft Distinguished engineer Dr Jim Gray discussing the Future of SQL Server. In this show, Jim (a database industry legend) gives his thoughts on the future directions for database products, LINQ, T-SQL and discusses his interests in spatial data." [www.sqldownunder.com] MP3 audio interview with Jim Gray from November 22th, 2005.

Introduction to ER Modeling — by torp — last modified Jan 21, 2009 07:18 PM

A introduction to ER modeling. Covers many aspects and uses the same notation as we use in the course. There is a list of questions after where you can test your skills.

Oracle/SQL Tutorial — by torp — last modified Jan 21, 2009 07:18 PM

An Oracle specific SQL tutorial. SQL is a standard, however, there are unfortunately many SQL dialects. This document gives a basic introduction to Oracle's SQL.

Data Access — by torp — last modified Jan 21, 2009 07:18 PM

How to gain access to the data stored in a relational database from a programming language such as C# or Java.

Query Optimization — by torp — last modified Jan 21, 2009 07:18 PM

Links to material on query optimization.

Spatial — by torp — last modified Jan 21, 2009 07:18 PM

Links to papers and presentation on storing spatial data in a DBMS. Most links are Oracle specific.

SQL — by torp — last modified Jan 21, 2009 07:18 PM

Links to material on SQL.

Logical Design — by torp — last modified Jan 21, 2009 07:18 PM

Links to resources on logical design, i.e., functional dependencies, BCNF, 3NF and so on.

Courses — by torp — last modified Jan 21, 2009 07:18 PM

Other coures on database systems. Some are with video recorded lectures.

Oracle — by padm — last modified Feb 08, 2009 09:29 AM

Various stuff related to the Oracle DBMS.