Relational Database for Computer Professionals
a technical introduction to relational databases
ABOUT THIS SEMINAR
Chris Date is the world’s best known specialist in relational databases. In this seminar, he explains exactly what a relational database is, and describes the underlying theory of such databases (“the relational model”) in considerable depth. He also discusses the standard database language SQL.
The relational model is one of the great technical inventions of the last hundred years. It’s the foundation of everything we do in the database field; in fact, the relational model is what turned database management into a truly scientific discipline instead of (as it was formerly) just an ad hoc collection of tricks and techniques. Thus, everyone technically involved in database management, even to the smallest degree, owes it to himself or herself to acquire a reasonable knowledge and understanding of the relational model?for without it, fully effective and productive job performance is impossible.
Unfortunately, it isn’t as easy as it should be to come by that knowledge and understanding. There are several reasons for this state of affairs, but one of the biggest is the official standard language SQL (which is supported in some shape or form by just about every database product on the market today). It’s widely known-or at least, it should be widely known-that, considered as a concrete realization of the abstract ideas of the relational model, SQL is very deeply flawed. And since for obvious practical reasons everyone in the database world has to learn SQL, the emphasis in almost all “relational” education is on SQL as such, instead of on the underlying theory. As a consequence, it’s all too common for people to know SQL and therefore think they know the underlying theory; in fact, however, if they know only SQL as such, then they most certainly don’t know that theory. And what you don’t know can hurt you.
The purpose of this seminar, then, is to teach that theory, very carefully. It also discusses the practical question of how to use SQL in accordance with that theory. Note: Classroom exercises are an integral part of the seminar, and attendee discussion and interaction are strongly encouraged.
Part I : Foundations
3. Keys and foreign keys
4. Relational operators I
5. Relational operators II
6. Constraints and predicates
7. The relational model
9. Database design
10. SQL tables
11. SQL operators I
12. SQL operators II
13. SQL constraints
14. SQL vs. the relational model
Three days (18 classroom hours). Note: A slightly compressed version, omitting the sessions on SQL (Sessions 10-14) can be taught as a two-day seminar. A compressed (one-day) version of Sessions 1-7 is also available.WHO SHOULD ATTEND
The seminar is meant for anyone who has a technical interest in database systems. Attendees will be expected to have at least an elementary familiarity with programming and programming languages, but will not be expected to have any detailed prior knowledge of database systems.OBJECTIVES
On completion of this seminar, attendees will:
Attendees will receive a workbook containing copies of the speaker’s slides.(Download this seminar description in PDF format for printing from here)