Oracle SQL jumpstart with examples

Gavin JT Powell, Carol McCullough-Dieter1555583237, 9781555583231, 9781417549764

As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single source as this book.One comes across very few books that make a significant difference in your fundamental understanding of the subject. This is one such book if you want to understand a core database skill SQL. This book deserves a place in your library and you will find it a great reference not only for learning SQL but also for learning data relationships, data organization, data analysis possibilities and so forth. I feel that the title, Oracle SQL: Jumpstart with Examples, might be too simplistic to describe the content. Read on, you will find the real value hidden inside this book.

---

Table of contents :
Team DDU……Page 1
Table of Contents……Page 8
Foreword……Page 20
Preface……Page 22
Acknowledgements……Page 30
1 Introduction to Oracle SQL……Page 32
2 New Features of Oracle SQL……Page 70
3 Oracle Database Architecture……Page 82
4 The SELECT Statement……Page 104
5 Filtering Rows……Page 128
6 Sorting Rows……Page 140
7 Operators, Conditions, and Pseudocolumns……Page 154
8 Using SQL*Plus……Page 168
9 Single-Row Functions……Page 206
10 Joining Tables……Page 236
11 Grouping and Summarizing Data……Page 266
12 Subqueries……Page 298
13 Unusual Query Types……Page 316
14 Expressions……Page 332
15 Data Manipulation Language (DML)……Page 346
16 Datatypes and Collections……Page 370
17 XML in Oracle……Page 388
18 Tables……Page 414
19 Views……Page 456
20 Constraints……Page 478
21 Indexes and Clusters……Page 502
22 Sequences and Synonyms……Page 520
23 Security……Page 534
24 Basic PL/SQL……Page 562
Appendix A……Page 600
Appendix B……Page 654
Appendix C……Page 656
Index……Page 658