Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Oracle SQL by Example (4th Edition) (Prentice Hall Professional Oracle Series)
 
 

Oracle SQL by Example (4th Edition) (Prentice Hall Professional Oracle Series) [Kindle Edition]

Alice Rischert
3.7 out of 5 stars  See all reviews (3 customer reviews)

Print List Price: £43.99
Kindle Price: £27.80 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £16.19 (37%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £27.80  
Paperback £29.26  
Earn a Free Kindle Book
Earn a Free Kindle Book
Buy a Kindle book between now and 31 March and receive a promotional code good for one free Kindle book. Terms and conditions apply. Learn more


Product Description

Product Description

The World’s #1 Hands-On Oracle SQL Workbook–Fully Updated for Oracle 11g

 

Crafted for hands-on learning and tested in classrooms worldwide, this book illuminates in-depth every Oracle SQL technique you’ll need. From the simplest query fundamentals to regular expressions and with newly added coverage of Oracle’s powerful new SQL Developer tool, you will focus on the tasks that matter most. Hundreds of step-by-step, guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you’ll acquire a powerful arsenal of useful skills–and an extraordinary library of solutions for your real-world challenges with Oracle SQL.

 

Coverage includes

 

  • 100% focused on Oracle SQL for Oracle 11g, today’s #1 database platform–not “generic” SQL!
  • Master all core SQL techniques including every type of join such as equijoins, self joins, and outer joins
  • Understand Oracle functions in depth, especially character, number, date, timestamp, interval, conversion, aggregate, regular expressions, analytical, and more
  • Practice all types of subqueries, such as correlated and scalar subqueries, and learn about set operators and hierarchical queries
  • Build effective queries and learn fundamental Oracle SQL Developer and SQL*Plus skills
  • Make the most of the Data Dictionary and create tables, views, indexes, and sequences
  • Secure databases using Oracle privileges, roles, and synonyms
  • Explore Oracle 11g’s advanced data warehousing features
  • Learn many practical tips about performance optimization, security, and architectural solutions
  • Avoid common pitfalls and understand and solve common mistakes
  • For every database developer, administrator, designer, or architect, regardless of experience!

From the Back Cover

“The book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book

many times over.”

–Dr. Paul Dorsey, President, Dulcian, Inc., Oracle Magazine PL/SQL Developer of the Year 2007, and President

Emeritus, New York Oracle Users Group 

 

“This is a fascinating guide into the world of Oracle SQL with an abundance of well-collected examples. Without a doubt, this

book is helpful to beginners and experts alike who seek alternative ways to resolve advanced scenarios.”–Oleg Voskoboynikov, Ph.D., Database Architect

 

The World’s #1 Hands-On Oracle SQL Workbook–Fully Updated for Oracle 11g

 

Crafted for hands-on learning and tested in classrooms worldwide, this book illuminates in-depth every Oracle SQL technique you’ll need. From the simplest query fundamentals to regular expressions and with newly added coverage of Oracle’s powerful new SQL Developer tool, you will focus on the tasks that matter most. Hundreds of step-by-step, guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you’ll acquire a powerful arsenal of useful skills–and an extraordinary library of solutions for your real-world challenges with Oracle SQL.

 

Coverage includes

 

  • 100% focused on Oracle SQL for Oracle 11g, today’s #1 database platform–not “generic” SQL!
  • Master all core SQL techniques including every type of join such as equijoins, self joins, and outer joins
  • Understand Oracle functions in depth, especially character, number, date, timestamp, interval, conversion, aggregate, regular expressions, analytical, and more
  • Practice all types of subqueries, such as correlated and scalar subqueries, and learn about set operators and hierarchical queries
  • Build effective queries and learn fundamental Oracle SQL Developer and SQL*Plus skills
  • Make the most of the Data Dictionary and create tables, views, indexes, and sequences
  • Secure databases using Oracle privileges, roles, and synonyms
  • Explore Oracle 11g’s advanced data warehousing features
  • Learn many practical tips about performance optimization, security, and architectural solutions
  • Avoid common pitfalls and understand and solve common mistakes
  • For every database developer, administrator, designer, or architect, regardless of experience!

Product details

  • Format: Kindle Edition
  • File Size: 42235 KB
  • Print Length: 960 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: Prentice Hall; 4 edition (12 Aug 2009)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B002MK0W4A
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: #474,152 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

4 star
0
3 star
0
2 star
0
3.7 out of 5 stars
3.7 out of 5 stars
Most Helpful Customer Reviews
1.0 out of 5 stars waste of time 6 Jun 2014
Format:Kindle Edition|Verified Purchase
If your an Mac user don't waste your time. The exercise files come in a .exe file so you cannot load them. Also even if you have bought software for mac that opens windows files like Crossover, when you copy the exercise files to Oracle some do not work. A complete waste of money for me
Comment | 
Was this review helpful to you?
By Chunky
Format:Paperback|Verified Purchase
I bought this book about a month ago and so far I'm very pleased with the whole content and idea behind the book. You are supplied with a script from the corresponding website which allows you to create the tables that enable you to run the examples and exercises on SQL *Plus or SQL Developer. The topics and concepts are very well explained and not too technical. Very useful for a beginner. Quite an expensive book, but I thought it was value for money.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Well-written and pretty comprehensive. 26 Aug 2014
Format:Paperback|Verified Purchase
Well-written and pretty comprehensive.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.2 out of 5 stars  30 reviews
6 of 6 people found the following review helpful
5.0 out of 5 stars Over the Top 24 July 2010
By Riccardo Audano - Published on Amazon.com
Format:Paperback|Verified Purchase
I rarely find a techical book that has just everything I would want.. this one has it, and more. It's "hands on" and example based, but the theory is clearly and orderly introduced. Presentation style is neither boring nor distracting. The author's tech skill are awe inspiring but she still manages to write excellent material for beginners. She really cares to teach, not to show off her skills and knowledge...
So if you really want to learn SQL, want to do it with no pain, lots and lots of practical examples and *solved exercises*, and also get some practice with on of the most used database platforms available.. well this is the book you want. Do yourself a favour and start here.
You might want to check out also:
Beginning Oracle SQL
especially if you would like to read something a little more "compact" and "theory oriented" that still has solved exercises.. but I really think that when it comes to learning SQL nothing is more valuable than lots and lots of practice and examples..my advice is read them both, you won't regret it.
The only reproach I can make to to author is that she still has not written an intermediate level text as a follow up of this awesome text!
5 of 5 people found the following review helpful
4.0 out of 5 stars Good reference book 23 Mar 2013
By X. Liu - Published on Amazon.com
Format:Paperback|Verified Purchase
I registed a SQL class at my local community college. The textbook recommeded by the college was over $200 and had a one and half star review. I decided to use this book for my SQL class. The teacher told me that without any IT background and without using the school's textbook I wouldn't be able to make it through the class. I not only made it through, but also got 4.0 for the class with skipping half of the classes. I relied on this book and self-study.
6 of 7 people found the following review helpful
5.0 out of 5 stars Excellent Book to Learn Oracle SQL 22 July 2010
By Michael D. Valverde - Published on Amazon.com
Format:Paperback
This is a great book to pick up and start learning Oracle SQL. I am an Adjunct Profressor and this it the book I use in my Intro to Oracle Programming. What has made this book such a success for me is the pace of the book. It is task oriented which is great for self-paced or classroom learning. She covers the topics in the right order to continue building on previous topics. It is a great book to start you off and you will find it very valuable resource.

Also, the "Student" database provided via the books website is really usefull. Students immediately understand the data model because Courses, Sections, Enrollment, Grades, etc makes since to them. If you want to learn Oracle SQL this is the best place to start! I can't say enough about how great it is!
3 of 3 people found the following review helpful
5.0 out of 5 stars Good 3 Oct 2012
By Nicholas W. Giaimo - Published on Amazon.com
Format:Paperback|Verified Purchase
Useful and easy to digest. Provides enough detail and practice to enable a firm grasp on concepts and everything is presented in a way that does not leave you confused.
2 of 2 people found the following review helpful
5.0 out of 5 stars Very Good Book for Oracle SQL 15 Oct 2010
By Mr. Steven J. Reed - Published on Amazon.com
Format:Paperback|Verified Purchase
This book is nicely laid out and easy to follow. There are lots of examples of syntax and many of the common functions are discussed. There is also a good amount of information about SQL Developer and SQL+. It is valuable to know about those tools when using SQL with Oracle. This book has kept my interest and I have learned some new tricks. There are lots of quizzes and plenty of information that pertains to Oracle SQL exams.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category