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

Anybody can read Kindle books even without a Kindle device-with the FREE Kindle app for smartphones and tablets.
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
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: 44.99
Kindle Price: 21.54 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: 23.45 (52%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition 21.54  
Paperback 33.74  
Kid's and Teen books from £0.99 on Kindle
Browse our selection of top children's and teen title in our one week sale, with top titles from only £0.99.Browse the sale here


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:
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #49,157 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
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
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?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.2 out of 5 stars  24 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!
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.
5 of 6 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!
2 of 2 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.
2 of 2 people found the following review helpful
4.0 out of 5 stars Orcle books is good 7 Mar 2013
By Jawid - Published on Amazon.com
Format:Paperback|Verified Purchase
It is supplemntal reading for my class. I like the contents and good source for beginner of Oracle.
Thanks ;
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Popular Highlights

 (What's this?)
&quote;
For a table to be in first normal form, all repeating groups must be removed and placed in a new table. &quote;
Highlighted by 17 Kindle users
&quote;
The objective of normalization is to eliminate redundancy in tables, therefore avoiding any future data manipulation problems. &quote;
Highlighted by 14 Kindle users
&quote;
The third normal form goes a step further than the second normal form: It states that every nonkey column must be a fact about the primary key. &quote;
Highlighted by 13 Kindle users

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


ARRAY(0x113b8f0c)