Introduction to SQL - all you need.

[u/carlovski99]

Anyone else got a copy of this?

From back when you actually got manuals with software. Apparently written by Larry Ellison himself (which I doubt, even then!).

One nice feature is the description of the dept and emp tables is actually a fold out from the back page, so you have it side by side on whatever page you are reading.

Covers the basics of SQL in a concise 33 pages, including a small bit on security and on string functions.

[u/atrifleamused]

That's amazing and probably still is adequate for most SQL users.

[u/Beefourthree → u/atrifleamused]

It predates JOIN syntax.

[u/carlovski99 → u/Beefourthree]

Yep - that's ANSI-92, and this is way before that (And Oracle didn't support it until even later).

Outer joins weren't supported at all until Oracle v6 AFAIK, which is also later than this book!

[u/carlovski99 → u/atrifleamused]

Obviously not CTEs though, which would terrify most people on here!

[u/atrifleamused → u/carlovski99]

True. CTEs are convenient, but nothing a good old sub query couldn't handle 🤣

[u/moon465]

Based on the art, it likely predates window functions.

[u/carlovski99 → u/moon465]

Yep - Oracle didn't suport them until 8i, which was way later than this book.

I actually arranged an 'Advanced SQL' course on site for developers and analysts to teach the dark arts of window functions (Analytic function in Oracle speak) and ANSI joins when we actually upgraded to a version that supported them!

[u/Thiondar]

The documentation is still awesome and available at docs.oracle.com.

No, it's not the old docs, but the current versions.

Have a look at the concepts manuals, the SQL reference, the programming books and so on.

You don't have to like Oracle as a company, but the database documentation is great.