Re: Materials for an Advanced Database course

> --CELKO-- wrote:

>>What materials (books, software, etc.) would you recommend for such a >>course?

Steve Kass wrote:

> I used SQL Server 7.0 as software last year, since it has fairly modest
> system requirements. It may not be exactly SQL-92, but it is easy to
> install and has excellent development tools. It's strictly a back-end,
> which I liked, "purer" than say PL/SQL, which certainly is more versatile.
> But students who have a good background in SQL and in an imperative
> language can learn something like PL/SQL on their own later if they
> need to, I think. I'm told DB2 is a good product, and it has a free
> development version, but the installation was too daunting for me.
>
> If the computers available to students are up to it, use SQL Server 2000,
> but even if they aren't, you can probably still find books that have the
> 7.0 120-day (conveniently just about a semester) evaluation copy inside.
> Depending on the kind of school and the kind of students, the Microsoft
> Developers Network Academic Alliance can be a real help - look into
> it at msdnaa.com.

For database software unencumbered by licensing I'd consider PostgreSQL. It implements a fair bit of SQL-92 and it is not at all taxing on a system.

There are graphical front ends, it does support ODBC, it does run on Windows.

http://advocacy.postgresql.org/

Alan Gutierrez - ajglist_at_izzy.net Received on Sat Jan 18 2003 - 19:30:33 CET