May 2013
Advanced
284 pages
6h 51m
English
Content preview from Relational Theory for Computer ProfessionalsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 10. SQL Tables
[The] natural sequel of an unnatural beginning
—Jane Austen: Persuasion (1818)
Recall from Chapter 1 that my plan for this book (for Parts I and III, at least) looked like this:
First, I wanted to explain the relational model as such, using a language expressly designed for that purpose called Tutorial D.
Then I wanted to show how terms and concepts from the relational model are realized in concrete form in the SQL language specifically.[78] (Please note, therefore, that I’m not trying to cover the whole of SQL in this book; rather, I just want to cover what might be called the relational aspects—what I referred to in the preface as the core features—of that language.)
I also claimed in Chapter 1 that, precisely because of the foregoing plan, this book wasn’t going to look much like most of the books and presentations currently available in the marketplace that purport to be an introduction to relational databases. What’s more, I don’t think the chapters in this part of the book are going to look much like the usual introductory books and presentations on SQL either, come to that.
Incidentally, I do believe that learning the relational model first and SQL second is much easier than doing it the other way around. Part of the reason for this state of affairs is that doing it the other way around typically requires rather a lot of unlearning (and as I said in the preface, unlearning can be very difficult, as we all know).
A little history
The SQL language was originally ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.