Watch the new season of Amazon Original series The Wheel of Time now on Prime Video. New episode weekly.
Add Prime to get Fast, Free delivery
Amazon prime logo
$20.97 with 62 percent savings
List Price: $54.99
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Wednesday, March 26 on orders shipped by Amazon over $35
Or Prime members get FREE delivery Monday, March 24. Order within 8 hrs 32 mins.
In Stock
$$20.97 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$20.97
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Amazon.com
Sold by
Amazon.com
Returns
30-day refund/replacement
30-day refund/replacement
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Kim Berg Hansen
Follow
Something went wrong. Please try your request again later.

Practical Oracle SQL: Mastering the Full Power of Oracle Database First Edition

by Kim Berg Hansen (Author)
4.7 4.7 out of 5 stars 37 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$20.97","priceAmount":20.97,"currencySymbol":"$","integerValue":"20","decimalSeparator":".","fractionalValue":"97","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"dvP1NNf76WSfMlfiJhX%2FL9D89TIJwiRBOKmfYYYJVod6N8euseD%2FLgG6ZE6SUNB%2BQaDrQW3tX2a5p3RGulPTyjiG5%2FPgTAfBc9dVTXQxR2JgwbFoNOkvBgal%2BH1994CuhBvCF8DA6A8p4tjAzrmKRg%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}]}

Purchase options and add-ons

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.
Both standard SQL and Oracle’s own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:
  • Pivoting rows to columns and columns to rows
  • Recursion in SQL with MODEL and WITH clauses
  • Answering Top-N questions
  • Forecasting with linear regressions
  • Row pattern matching to group or distribute rows
  • Using MATCH_RECOGNIZE as a row processing engine
The process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complexstatements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors.

What You Will Learn
  • Take full advantage of advanced and modern features in Oracle SQL
  • Recognize when modern SQL constructs can help create better applications
  • Improve SQL query building skills through stepwise refinement
  • Apply set-based thinking to process more data in fewer queries
  • Make cross-row calculations with analytic functions
  • Search for patterns across multiple rows using row pattern matching
  • Break complex calculations into smaller steps with subquery factoring

Who This Book Is For
Oracle Database developers who already knowsome SQL, but rarely use features of the language beyond the SQL-92 standard. And it is for developers who would like to apply the more modern features of Oracle SQL, but don’t know where to start. The book also is for those who want to write increasingly complex queries in a stepwise and understandable manner. Experienced developers will use the book to develop more efficient queries using the advanced features of the Oracle SQL language.
Previous slide of product details
  1. ISBN-10
    1484256166
  2. ISBN-13
    978-1484256169
  3. Edition
    First Edition
  4. Publication date
    February 20, 2020
  5. Language
    English
  6. Dimensions
    7.01 x 1.09 x 10 inches
  7. Print length
    483 pages
Next slide of product details

Frequently bought together

Practical Oracle SQL: Mastering the Full Power of Oracle Database
This item: Practical Oracle SQL: Mastering the Full Power of Oracle Database
$20.97
Get it as soon as Wednesday, Mar 26
In Stock
Ships from and sold by Amazon.com.
+
Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and
$30.65
Get it as soon as Wednesday, Mar 26
In Stock
Ships from and sold by Amazon.com.
+
Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity
$56.81
Get it Apr 2 - 9
In stock
Usually ships within 4 to 5 days.
Ships from and sold by allnewbooks.
Total price: $00
To see our price, add these items to your cart.
Details
Added to Cart
spCSRF_Treatment
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Editorial Reviews

From the Author

I've been working with Oracle SQL since 2000, and if someone asks me where I learned SQL, the answer is many places: books by Tom Kyte (my guru) and others, the SQL Reference Manual (that I use daily), conference presentations by experienced developers, blogs, googling, and much more. But even all of that would not help if I didn't simultaneously simply try writing SQL myself, see where I went wrong, and then try again and again and again. One thing I have noticed in my learning process is that almost all teaching examples are nicely short and sweet in order to facilitate understanding. This is fine as such, but it also sometimes means that it can be harder to relate to daily work. Making the leap from having understood a small example to applying the same technique in a larger and real context is an acquired skill. As I started working as a developer, I had the good fortune of working for 16 years at a retail company where the philosophy was never to adapt business practice to whatever the software was capable of but instead always to customize the software to make the daily business go smarter and smoother. We always went by the philosophy "of course it is possible to solve; we just need to figure out how." In this atmosphere I had plenty of practical real tasks to work on, trying out SQL and changing it piece by piece until I had something that solved the task at hand. It was a time when I improved my SQL daily by using the skills of researching, finding examples, learning from them, and then applying them to real tasks. When I have presented at conferences about some of these solutions that I developed during those happy years, I have several times had audience members approach me afterwards, telling me that suddenly they saw the light and understood, for example, how analytic functions could help in their work. Until then, they had seen it as some SQL extension that was smart and fancy, but they couldn't relate it to their own tasks that they had to solve. And so it dawned on me that not everybody learns things the way I do. Quite a few would watch a presentation or read a book chapter or a blog post on how to use analytic functions to get a running total of salaries in SCOTT.EMP--but when they got back to work it didn't help them to figure out that this technique actually can help them to create a warehouse picking list by First-In-First-Out (FIFO) in a single SQL statement. The leap from the simple SCOTT.EMP example to real life was too great. Looking at the Oracle SQL book market, what I felt was missing was a book that assumes the reader already knows SQL basics and is ready to learn something more advanced than SQL-92 but needs to learn it in a form that relates to the reader's daily activities. Unfortunately I see quite a few developers chugging along with SQL-92 and never progressing to using analytic functions, let alone row pattern matching and other modern additions to the SQL language, and I want to push those developers further into modern SQL. So having had success with developers understanding more advanced concepts by presenting about the real solutions I had developed, I decided to use the same teaching concept in book form. The result is Practical Oracle SQL, published by Apress. You'll find loads of examples, based on a fictitious company called Good Beer Trading Co. (As a card-carrying member of Danish Beer Enthusiasts Association I couldn't resist the temptation to use beer in my example schema, but you can use the book even if you don't drink alcohol--there is no bottle included when you buy the book . . .) For this company I have created a schema with tables and data for inventory, orders, purchases, webshop, and more; all such tables might have been part of the application of a real company. In each chapter I have a task as it might have been put to the application developers of the Good Beer Trading Co; I then show how to solve that task with SQL, explaining in steps how I create that SQL, starting small and building on it until I have a working statement that most often does not fit on a single PowerPoint slide. The statements I demonstrate are not trivial examples, but they look more like something a developer might have to personally develop on the job. Maybe you are under the impression that if SQL is slightly more complex than a two-table join, then it is only for geniuses to attempt and you won't even try it. I assure you this is not the case. Expertise comes from practice. Confidence comes from familiarity. You should just go ahead and write slightly more complex SQL tomorrow, then slightly more the day after, and so on. Over time it will become as familiar to you as whatever other language you've worked in for years, and you will say to yourself, "What was I afraid of?" You need a slightly different mindset when coding SQL: you think about the whole set of data instead of just handling one row at a time. But it's not a mindset that only special minds can achieve; it's a mindset everybody can acquire. The requirement is merely to start practicing; without doing "wax on, wax off," the Karate Kid would never have learned to be good at what he did. And that's the core reason I wrote the book: I want more developers to acquire this mindset, and I am confident it will give developers (who already know some SQL) a jumpstart in their journey toward really using the power of SQL. If you end up with the attitude that "of course it is possible to solve in SQL," your bosses will be happy because they save a lot on cloud credits or licenses when the efficient SQL code uses much less CPU. And you will be happier because it is much more fun really exercising the brain cells to find a good solution. Then I will be happy too and can say, "Mission accomplished!"  [[This is an abstract of an interview given to the Northern California Oracle Users Group Journal: nocoug.org/Journal/NoCOUG_Journal_202002.pdf#page=4]] 

From the Back Cover

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.
Both standard SQL and Oracle’s own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:
  • Pivoting rows to columns and columns to rows
  • Recursion in SQL with MODEL and WITH clauses
  • Answering Top-N questions
  • Forecasting with linear regressions
  • Row pattern matching to group or distribute rows
  • Using MATCH_RECOGNIZE as a row processing engine
The process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complexstatements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors.
You will:
  • Take full advantage of advanced and modern features in Oracle SQL
  • Recognize when modern SQL constructs can help create better applications
  • Improve SQL query building skills through stepwise refinement
  • Apply set-based thinking to process more data in fewer queries
  • Make cross-row calculations with analytic functions
  • Search for patterns across multiple rows using row pattern matching
  • Break complex calculations into smaller steps with subquery factoring

Product details

  • Publisher ‏ : ‎ Apress; First Edition (February 20, 2020)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 483 pages
  • ISBN-10 ‏ : ‎ 1484256166
  • ISBN-13 ‏ : ‎ 978-1484256169
  • Item Weight ‏ : ‎ 1.8 pounds
  • Dimensions ‏ : ‎ 7.01 x 1.09 x 10 inches
  • Customer Reviews:
    4.7 4.7 out of 5 stars 37 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Kim Berg Hansen

Kim Berg Hansen

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Kim Berg Hansen is a database developer from Middelfart in Denmark.

As a youngster originally wanting to work with electronics, he tried computer programming and discovered that the programs he wrote worked well—unlike the electronics projects he soldered that often failed. This lead to a VIC-20 with 5 kilobytes RAM and many hours programming in Commodore Basic.

Having discovered his talent, Kim financed computer science studies at Odense University with a summer job as Sheriff of Legoredo, while learning methodology and programming in Modula-2 and C. From there he moved into consulting as a developer making customizations to ERP software. That gave him his first introduction to Oracle SQL and PL/SQL, with which he has worked extensively since the year 2000.

His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for his application users. With a background fitting programs into 5 KB RAM, Kim hates to waste computing resources unnecessarily.

Kim shares his experience and knowledge by blogging at www.kibeha.dk, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation comes from peers who say “now I understand” after his explanations, and from end users who “can’t live without” his application coding. He is a certified Oracle OCE in SQL, and an Oracle ACE Director.

Outside the coding world, Kim is married, loves to cook, and is a card-carrying member of the Danish Beer Enthusiasts Association.

Customer reviews

4.7 out of 5 stars
37 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Top reviews from the United States

  • A Reviewer
    5.0 out of 5 stars Excellent Real World Problems
    Reviewed in the United States on June 13, 2021
    Verified Purchase
    This is an excellent book for solving real world SQL problems one might encounter. It incorporates the latest Oracle SQL new features and provides multiple options, with pros/cons, to achieve a result. The examples are very well explained which is not an easy task.
    One person found this helpful
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • Andreas Gondorf
    5.0 out of 5 stars Gute Anregungen für SQL-Statement-Optimierungen
    Reviewed in Germany on January 25, 2024
    Verified Purchase
    Einige sehr coole SQL-Funktionen. Gerade die windowed functions können sehr nützlich sein.
    Wer ein Buch sucht, dass hilft SQL statements zu optimieren, wird mit dem Buch Spaß haben.
    Report
  • Marc Musette
    5.0 out of 5 stars SQL is not dead
    Reviewed in France on October 14, 2020
    Verified Purchase
    "While it takes two to three weeks to learn SQL basics, you can spend a life for mastering it or, at least, for learning new features added through new releases."

    This book helps advanced users to buy a bit of time through real-life complex examples and well-written explanations.

    One of the best books over Oracle SQL ever.
    Report
  • Mohamed Houri
    4.0 out of 5 stars Almost everything I wanted to know about Oracle SQL in this book
    Reviewed in France on January 27, 2023
    Verified Purchase
    As the title of my review suggests, if you want to have a book in which you will find the essentials of what you need to know about Oracle SQL then "Practical Oracle SQL" is just what you are looking for. Not only is it all there but, it is beautifully and elegantly explained; sometimes using 3 different ways to write a semantically equivalent query. That's what we call a job well done.
    Report
  • Botti
    5.0 out of 5 stars Fuer erfahrene sql entwickler ein extra impuls zu bessere loesungen
    Reviewed in Germany on January 10, 2021
    Verified Purchase
    Dieses Buch erwartet schon ein grosses sql wissen. Kapitel 1 geht gleich auf hohem nivo los: es gibt nur wenige saetze die nicht informativ sind. Fuer sql einsteiger absolut ungeeignet, aber fuer diejenigen die denken das sie sql technisch alles schon drauf haben ist es eine sehr schoene lektuere.
    So ein buch wuensche ich mir fuer oracle sql optimierung, aber dann auf basic level!
    Report
  • A. Olsen
    5.0 out of 5 stars Very useful and hits the spot
    Reviewed in Germany on March 9, 2020
    Verified Purchase
    As an experienced SQL developer I find this book amazingly good at introducing the application of new methods implemented in the latest versions of Oracle Database. This book is absolutely not for beginners, and as such, the author is not attempting to tire the reader with too much talk. If you are used to approaching a problem and finding the best suited solutions, then you’ll feel at home, so to speak, right away.
    Report