Beginning Oracle SQL: For Oracle Database 12c and over 2 million other books are available for Amazon Kindle . Learn more
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
Beginning Oracle SQL: For... has been added to your Basket
Condition: Used: Very Good
Comment: Medium mark / wear on the back cover. Small wrinkle / bend on back cover. All purchases eligible for Amazon customer service and a 30-day return policy.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Beginning Oracle SQL: For Oracle Database 12c Paperback – 10 Mar 2014

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£22.86 £22.86
£29.50 FREE Delivery in the UK. In stock. Dispatched from and sold by Amazon. Gift-wrap available.

Product details

More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Tim Gorman began his information technology career in 1984 as a C programmer on UNIX and VMS systems, working on medical and financial systems as an application developer, systems programmer, and systems administrator. He joined Oracle Corporation in 1990 as a consultant, then became an independent consultant in 1998, and has worked for SageLogix since 2000. Gorman is the coauthor of Essential Oracle8i Data Warehousing and Oracle8 Data Warehousing. He specializes in performance tuning applications, databases, and systems, as well as data warehouse design and implementation, backup and recovery, architecture and infrastructure, and database administration. Gorman still considers himself a pretty good coder, although the market for C programs has dried up somewhat lately.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) 1 review
1 of 1 people found the following review helpful
Really good introduction to using Oracle's dialect of SQL language 30 Sept. 2014
By Lukasz Kubicki - Published on
Format: Paperback
First of all - I've received this as a review title from Apress, but following review is my personal opinion.

"Beginning Oracle SQL for Oracle Database 12c" is one of the best books about SQL programming in Oracle Database I've read. Authors did a really good job teaching this really wide topic. Everything is clear, there's a lot of examples for each of the feature that is mentioned in the book.
Although it is targeted as a book for beginners, also more experienced programmers can learn (or refresh their knowledge) using this book. Especially when they haven't used Oracle Database 12c features yet.

This book starts with an introduction to information systems, databases and database management systems. There is also a description of relational model along with 12 Codd's rules which describe requirements, RDBMS system should follow. You'll find there also an information about relational operators.
Next chapter contains an overview of SQL language. You'll learn the difference between data definition and data manipulation statements, about privileges and a difference between system and object ones. Chapter 2 provides also an introduction to SQL Developer (SQL*Plus is also covered in this book, but in chapter 11, which covers also some scripting using this tool).
After this introduction we move along to basics of data definition, which is then continued in more detail in Chapter 7. Chapter 3 provides enough information to get started - teaches what is a schema, what are built-in datatypes that can be used in table definition and how to create a table. Chapter 7 which goes into more details about this topic, teaches about modifying table structure, clearing all the data and droping the tables. You will find also what are indexes and how to use them. Sequences and synonyms are covered in this chapter too.
Chapter 4 and 5 cover data retrieval from single table. Chapter 4 teaches you the basics of SELECT statement, about projection and restriction operators. You'll find there also a nice description about what are NULL values, about what's so special about them and how they differ from other values you can find in the database. Chapter 5 provides information about functions and how and where you can use them in your statements.
Chapter 6 provides many information about INSERT, UPDATE, DELETE and MERGE commands. You'll learn also what is a transaction and how Oracle Database processes them and how it provides you consistent data.
Chapters 8 and 9 go into more detail about data retrieval - you'll learn how to join tables to retrieve the data you want, what are inner joins and what are outer joins. Chapter 9 goes further and provides information about subqueries, hierarchical queries, analytic functions and flashback queries.
In chapter 10 there are informations about views and the difference between inline, standard and materialized views. You will even learn how to manipulate data using views and why it is sometimes more convenient solution.
The last chapter covering SQL language is chapter 12 in which you can read about collections and objects in SQL - how to define them and how to use them.

Each chapter covering SQL language features ends with exercises helping you to understand better the topics that were covered. At the end of the book, you can find solutions to this exercises.
Also, when there is an new command introduced, it is briefly described and you will find a nice diagram, on which you can find the syntax. After that there's an example of how to use this command, so everything is explained really clearly. You can also find an information about common problems and mistakes you can make - the description of differences WHERE and HAVING clauses deserves special notice.
The only thing I missed was at least an overview of XMLType.

If you would like to start programming Oracle's dialect of SQL language, I think this is the book to start from. If you are more experienced, the book is still worth reading - you may find some interesting informations, especially some features that were inroduced in Oracle Database 12c.
Was this review helpful? Let us know