| ||||||||||||||||||
 Trade In this Item for up to £16.50
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Oracle SQL by Example (Prentice Hall PTR Oracle) for an Amazon.co.uk gift card of up to £16.50, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
“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!
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!
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
I don't pick up languages easily or memorize syntax
or vocabulary be it French, Spanish or SQL.
So, several times a day I pick up this book
to reference how to do something with SQL that I need
to know NOW before moving on to my next 20
emergency du jures.
.
This is a great book........ the best that I have found.
.
Now the downside: I would say the only confusing part is uploading the tutorial database (which you have to do from the author's website. It will take a little brainpower and a few aspirin because the directions on the author's website assume some previous knowledge. But trust me; you will eventually get it to work. I should tell you that it would be helpful, not necessary, but helpful to know a little bit about relational databases (like MS Access) before you tackle Oracle. Anther thing to know is that the author tells you that you need the Standard or Professional full editions, which would be very expensive and only necessary if you own a Fortune 500 company! But, thankfully, you do not need the full versions. All you need is the Express Edition to practice on and the book tutorials are well suited to it. The Express Edition is free software downloadable from Oracle's website, and really, it's all the casual hobbyist needs anyway and it's plenty powerful. Now, for those who are not familiar with Oracle, it has a completely different look and feel from ...like MS Access, for example. Oracle looks like DOS and initially feels just as clunky. But, it will grow on you. You also can apply the SQL concepts to Microsoft SQL Server if you want to learn another DB.
So if you are really serious and dedicated about learning databases, and don't mind a difficult initial set up, buy this book.
Since then, I have become a strong believer of "Learning by doing". Last year, I had bought this book with the same philosophy in mind. Needless to say, I was not disappointed. As the other reviewers have pointed out, the author starts with simple examples and builds on the material. Every concept is followed by at least one example.
The questions at the end of each chapter reinforce the concepts covered in the chapter. The answers (to the questions) introduce more concepts followed by more examples, and the learning process goes on and on ...
All in all, an excellent resource to learn Oracle's sqlplus.
Having said that, what this book is not is a certification guide. For those aspiring to write the Oracle certification exams will have to go an extra mile of investing time & money in another text that is specifically geared towards certifications. And this is where I am heading next.
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
