Shop Khloud Popcorn

Customers who viewed this item also viewed

  1. Mastering Oracle SQL, 2nd Edition
    Mastering Oracle SQL, 2nd Edition
    4.5103
    $21.76
  2. Oracle Database 12c SQL
    Oracle Database 12c SQL
    4.670
    $31.57
  3. Oracle PL/SQL by Example (The Oracle Press Database and Data Science)
    Oracle PL/SQL by Example (The Oracle Press Database and Data Science)
    4.86
    $56.92
Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows.
Buy New
-28% $39.46
FREE delivery Monday, April 27
Ships from: Amazon
Sold by: Books & Bauble
$39.46 with 28 percent savings
List Price: $54.99 Image
FREE delivery Monday, April 27
Or Prime members get FREE delivery Friday, April 24. Order within 9 hrs 22 mins. Join Prime
Only 8 left in stock - order soon.
$$39.46 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$39.46
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon
Amazon
Ships from
Amazon
Returns
FREE 30-day refund/replacement
FREE 30-day refund/replacement
Quick refund
Usually issued within 24 hours. See exceptions
FREE return
At least one free return option available.
Convenient dropoff
At any of our 50,000 US locations.
See return policy
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
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
Seller Certifications:Minority-Owned Business
$24.01
Book has minor to some wear to front and back covers. All interior pages are clean with no marks or highlighting. Not a former rental or library copy. Book has minor to some wear to front and back covers. All interior pages are clean with no marks or highlighting. Not a former rental or library copy. See less
$3.99 delivery Tuesday, April 28. Details
Only 1 left in stock - order soon.
$$39.46 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$39.46
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by Bill's Retro Media.
Seller Certifications:Minority-Owned Business
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
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

  • Practical Oracle SQL: Mastering the Full Power of Oracle Database

Follow the author

Get new release updates & improved recommendations
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 out of 5 stars (42)
{"desktop_buybox_group_1":[{"displayPrice":"$39.46","priceAmount":39.46,"currencySymbol":"$","integerValue":"39","decimalSeparator":".","fractionalValue":"46","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"uNf3j%2Bub%2BAYBvzy9d9ganKG8pLXmq2nG464bXuG14HUlz1ITlTKAQXM%2FVarJ3K7ifelBH%2BqntDP9IW3U%2F3FGczdUCFC0%2BcbytudEbltx5WQOEy57toEpY96ZEpLBEwsE%2BJrHlm4yIlXYkE1zAsBy8oXaxo%2BIsdJ36NmaO9qh081kLH3CtcVDSOaJVwKEkTIO","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$24.01","priceAmount":24.01,"currencySymbol":"$","integerValue":"24","decimalSeparator":".","fractionalValue":"01","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"uNf3j%2Bub%2BAYBvzy9d9ganKG8pLXmq2nGatSff%2BskEt0QrfN40nXoFhVsBcQwEBX%2F%2B%2BhoB0qmzhlbtyp0XbfQQF9Ihd0np8Zbn6H14gcvS7JAvRaogeh5N4BIGaUXQVLHxx13tIWuV7KE%2BjIU377cnvGZC9gj%2F1ziKWaOfNLKGpsG7GkeTTBeGA%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

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.
Read more
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
Sponsored

Frequently bought together

Image
This item: Practical Oracle SQL: Mastering the Full Power of Oracle Database
$39.46
Get it as soon as Monday, Apr 27
Only 8 left in stock - order soon.
Sold by Books & Bauble and ships from Amazon Fulfillment.
+
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 Tuesday, Apr 28
In Stock
Ships from and sold by Amazon.com.
+
Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity
$71.24
In stock
Usually ships within 3 to 4 days.
Ships from and sold by Publisher Direct.
Total price: $00
To see our price, add these items to your cart.
Details
Added to Cart
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
  • Publication date ‏ : ‎ February 20, 2020
  • Edition ‏ : ‎ First Edition
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 483 pages
  • ISBN-10 ‏ : ‎ 1484256166
  • ISBN-13 ‏ : ‎ 978-1484256169
  • Item Weight ‏ : ‎ 1.8 pounds
  • Dimensions ‏ : ‎ 7.01 x 1.09 x 10 inches
  • Best Sellers Rank: #2,083,908 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.7 out of 5 stars (42)

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.

Sponsored

Related books

Page 1 of 1Start Over
Sponsored
Previous page
  1. Image
    Shop the Store on Amazon ›
    The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
    The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
    4.44.4 out of 5 stars3,400
    $37.97 List:$60.97
  2. Image
    Shop the Store on Amazon ›
    HTML and CSS QuickStart Guide: The Simplified Beginners Guide to Developing a Strong Coding Foundation, Building Responsive Websites, and Mastering ... (Coding & Programming - QuickStart Guides)
    HTML and CSS QuickStart Guide: The Simplified Beginners Guide to Developing a Strong Coding Foundation, Building Responsive Websites, and Mastering ... (Coding & Programming - QuickStart Guides)
    4.54.5 out of 5 stars684
    $24.49 List:$34.99
  3. Image
    Shop the Store on Amazon ›
    Python Programming for Beginners: The Complete Python Coding Crash Course - Boost Your Growth with an Innovative Ultra-Fast Learning Framework and Exclusive Hands-On Interactive Exercises & Projects
    Python Programming for Beginners: The Complete Python Coding Crash Course - Boost Your Growth with an Innovative Ultra-Fast Learning Framework and Exclusive Hands-On Interactive Exercises & Projects
    4.54.5 out of 5 stars1,018
    $19.90
  4. Image
    Shop the Store on Amazon ›
    Workflow Automation with Microsoft Power Automate: Design and scale AI-powered cloud and desktop workflows using low-code automation
    Workflow Automation with Microsoft Power Automate: Design and scale AI-powered cloud and desktop workflows using low-code automation
    4.84.8 out of 5 stars17
    $18.34 List:$44.99
  5. Image
    Shop the Store on Amazon ›
    Microsoft Office 365 Bible 10 Books in 1: A Comprehensive Guide for Beginners to Excel, Word, Team, One Note, SharePoint, Outlook, PowerPoint, Access, Publisher, Visio. + n. 6 Bonus included
    Microsoft Office 365 Bible 10 Books in 1: A Comprehensive Guide for Beginners to Excel, Word, Team, One Note, SharePoint, Outlook, PowerPoint, Access, Publisher, Visio. + n. 6 Bonus included
    3.93.9 out of 5 stars98
    $31.00
Next page

Customer reviews

4.7 out of 5 stars
42 global ratings
Sponsored

Top review 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
    Format: PaperbackVerified 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
    Format: PaperbackVerified 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
    Format: PaperbackVerified 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
    Format: PaperbackVerified 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
    Format: PaperbackVerified 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
    Format: PaperbackVerified 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
See more reviews