Amazon.com: Expert Oracle Application Express (9781430235125): Dietmar Aust, Martin Giffy D'Souza, Doug Gault, Dimitri Gielis, Roel Hartman, Michael Hichwa, Sharon Kennedy, Denes Kubicek, Raj Mattamal, Dan McGhan, Francis Mignault, Anton Nielsen, John Scott: Books
Expert Oracle Application Express and over one million other books are available for Amazon Kindle. Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Kindle Edition
 
   
Sell Back Your Copy
For a $9.50 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Expert Oracle Application Express
 
 
Start reading Expert Oracle Application Express on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Expert Oracle Application Express [Paperback]

Dietmar Aust (Author), Martin Giffy D'Souza (Author), Doug Gault (Author), Dimitri Gielis (Author), Roel Hartman (Author), Michael Hichwa (Author), Sharon Kennedy (Author), Denes Kubicek (Author), Raj Mattamal (Author), Dan McGhan (Author), Francis Mignault (Author), Anton Nielsen (Author), John Scott (Author)
5.0 out of 5 stars  See all reviews (5 customer reviews)

List Price: $59.99
Price: $48.34 & this item ships for FREE with Super Saver Shipping. Details
You Save: $11.65 (19%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Friday, February 24? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for students on millions of items. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $36.96  
Paperback $48.34  

Book Description

June 13, 2011 1430235128 978-1430235125 1

Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle’s enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle’s powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users.  

The 13 authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product sing—developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding scalability, globalization, configuration and lifecycle management, and more. You’ll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development.

  • Presents best-practices and development insights from leading experts in the field
  • Addresses globalization, scalability, security, and other concerns of enterprise-level development
  • Shows how to customize APEX for your own application needs

What you’ll learn

  • Solve tough problems in scalability in order to serve thousands of users
  • Design applications to sidestep performance problems and easily scale upwards
  • Deploy applications globally while respecting linguistic and cultural differences
  • Customize applications by exploiting APEX’s roots in PL/SQL
  • Reduce the stress of managing application lifecycle and configuration
  • Secure outwardly-facing applications and their data from intrusion

Who this book is for

Expert Oracle Application Express is aimed at APEX developers who seek the deepest possible knowledge of Oracle Application Express and how to develop with it. Readers should know and be proficient with APEX, and be prepared to expend some mental energy in absorbing the high-end material in this book.

Table of Contents

  1. OHS, EPG, and APEX Listener Compared
  2. Oracle APEX 4.0 Charts Inside Out
  3. Tabular Forms
  4. Team Development
  5. Globalization
  6. Debugging
  7. Dynamic Actions
  8. Security
  9. Lifecycle Management
  10. Working with APEX Collections
  11. Plug-Ins
  12. Architecture
  13. Advanced Interactive Reporting

Frequently Bought Together

Expert Oracle Application Express + Pro Oracle Application Express 4 + Beginning Oracle Application Express 4
Price For All Three: $131.67

Show availability and shipping details

Buy the selected items together
  • In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Pro Oracle Application Express 4 $48.34

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Beginning Oracle Application Express 4 $34.99

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details



Editorial Reviews

About the Author

John Edward Scott has been using Oracle since version 7 (around 1993), and has used pretty much every release since then. He has had the good fortune to work on a wide range of projects for a varied group of clients. He was lucky enough to start working with Oracle Application Express when it was first publicly released, and has worked with it nearly every day since (and loves it). John is an Oracle ACE Director and was named Application Express Developer of the Year in 2006 by Oracle Magazine. He is also the cofounder of ApexEvangelists (Apex-Evangelists.com), a company that specializes in providing training, development, and consulting specifically for the Oracle Application Express product. You can contact John at john.scott@apex-evangelists.com.

Doug Gault is director and co-founder of Sumneva, a world-class Oracle Application Express (APEX) consulting, training & solutions firm founded in 2010. He has been working with Oracle since 1988 starting with version 5.1B, SQL*Forms 2.0, and RPT/RPF. Since then, he has focused his career on Oracle's development technologies, spending the last decade on web based technologies, and the last six years specifically on APEX.

Prior to co-founding Sumneva, Gault was vice president of Sumner Technologies, which also focused on Oracle APEX consulting, training & solutions. Before that, he served as product development director for Hotsos Enterprises, during which time he was the lead architect/developer and product manager for two commercial products written exclusively in APEX. His 21 years of Oracle experience have taken him all over the world and involved him in some truly groundbreaking projects.

Gault has presented and participated in round table discussions at a number of conferences, including Oracle OpenWorld, UKOUG and ODTUG's APEXposed. He holds an associate's degree in computer science, and an honorary master's degree from the School of Hard Knocks, believing there is no replacement for hard-earned, real-world experience.



Raj Mattamal is co-president of Niantic Systems, LLC (NianticSystems.com). He started developing web applications at Oracle in 1995 with the very same people who came to create Oracle Application Express (APEX). In his more than 10 years with the company, he helped customers in a wide range of industries to deliver web-based solutions on the Oracle Database. In addition to helping customers with their applications, Raj developed numerous web applications for use internally at Oracle. Outside of database application development, Raj spent much remaining time with Oracle evangelizing Oracle Application Express. This entailed teaching Oracle software development and APEX classes globally, writing articles for Oracle Magazine, writing Technotes for the Oracle Technology Network, and assisting with the development of training material and workshops.

Having earned a bachelor's degree in decision and information studies, and another in marketing, from the University of Maryland, Raj continues to apply his knowledge of and passion for technology and business to real-world issues. Since leaving Oracle in 2006, Raj offers his services and training to customers in a wide range of business lines to help them get the most out of their Oracle environments. In recent years, Raj has been recognized by his Oracle professional colleagues as an Oracle ACE Director—an honor, indeed, to be earned among so many knowledgeable colleagues.

Anton Nielsen is president of C2 Consulting, a technology solutions firm specializing in Oracle technologies. Anton is an Oracle Fusion Middleware ACE Director and has presented at ODTUG Kaleidoscope, Oracle OpenWorld, and APEXposed. Prior to founding C2 Consulting, he was technical director at Oracle and an officer and scientist in the U.S. Air Force. Anton has a bachelor's degree in mathematics from the University of Chicago and a master's from Northeastern University, where he concentrated in combinatorics, encryption and error correction codes. He has worked with Oracle Application Express since its inception and with various aspects of software security since 1982.

Martin Giffy D’Souza is co-founder and chief technology officer at ClariFit, Inc., a consulting firm and custom solutions provider which specializes in APEX and PL/SQL development. Martin’s experience in the technology industry has been focused on developing database-centric web applications using the Oracle APEX technology stack.
Prior to co-founding ClariFit, Martin’s career has seen him hold a range of positions within award-winning companies. Martin is also the author of the highly recognized blog, TalkApex.com, which boasts a multitude of posts on a wide array of APEX topics. He has also presented at numerous international conferences such as ODTUG, APEXposed, and COUG. Martin is an Oracle ACE and holds a computer engineering degree from Queen’s University in Kingston, Ontario.

Dimitri Gielis has been working with Oracle Database since he began his career in 2000 with Oracle in Belgium. Dimitri was an early adopter and supporter of HTML DB, and later of Application Express. After many years honing his expertise with Oracle Database and Application Express, Dimitri joined with John Scott in 2007 to co-found APEX Evangelists. There, he focuses on training and development on the Oracle Application Express platform. Dimitri is an active member of the Application Express community. He routinely posts insights into Application Express on his blog at http://dgielis.blogspot.com. He is a frequent presenter at the Oracle Benelux User Group (OBUG) Connect conference, IOUG collaborate, UDTUG Kaleidoscope, the UKOUG conference, and Oracle OpenWorld. He is president of the OBUG APEX SIG. He is an Oracle ACE Director since 2008. He received the “APEX Developer of the Year” award from Oracle Magazine in 2009.

Roel Hartman has been using Oracle Database since version 5. At that time, he used Oracle Case*Designer, Oracle Forms 2.3, and other tools of the day. He has used all versions of those tools as they have evolved during the intervening years, giving him great depth of experience as an Oracle Database developer. Today he is a fierce advocate and user of Oracle Application Express. Roel holds a master's degree in business informatics from the University of Twente in the Netherlands. He is an Oracle ACE Director. He works for Logica in the Netherlands as a lead technical architect. Roel has presented at all major Oracle conferences, such as ODTUG, Oracle Open World, and UKOUG. He is a regular contributer to the OakTable Network APEX Forum.

Francis Mignault is chief technology officer and co-founder of Insum Solutions. He has been working with Oracle Database for more than 23 years and is a certified Oracle database administrator. Francis began his work with APEX in 2004, when it was called HTML DB. He and his team have developed bilingual software as a service application that is now used by over 60,000 active users. Francis is deeply involved in the APEX community. His first-rate PL/SQL and APEX expertise led to becoming the first APEX instructor in Quebec. He has presented at several APEX seminars and conferences in the United States and Canada, including Oracle Open World, IOUG Collaborate, ODTUG Apexposed, ODTUG Kaleidoscope, and Ora*GEC.

Dietmar Aust is a freelance consultant in Germany, focusing on Oracle Application Express and Oracle XE. Starting in 1997, he worked for three years as a consultant for Oracle in Germany. Since then, he has helped numerous leading companies in Germany successfully deliver Web-based applications based on the Oracle product stack, especially involving the Internet application server, Oracle Portal, and Oracle Reports. Dietmar is a regular presenter at various Oracle conferences (ODTUG, OOW, DOAG), conducts training classes on APEX, and recently co-authored a book on APEX best practices in German (Oracle APEX und Oracle XE in der Praxis). You can reach him at Opal-Consulting.com or http://daust.blogspot.com.

Michael Hichwa is the original developer and architect of Oracle Application Express (APEX), aka HTML DB. Michael created APEX as a 100% rewrite of an earlier browser-based application development tool he also created, called Oracle WebDB. He had invaluable technical assistance and guidance from Tom Kyte and the addition of Joel Kallman as a co-developer. Michael and Joel have led APEX developments efforts since 1999. Michael remains committed and fully engaged in Oracle APEX design and development efforts. He also leads the development teams responsible for Oracle SQL Developer, SQL Developer Data Modeler, Migration Tools, the Oracle development tools for Visual Studio .NET and other data access technologies. Michael also leads APEX-driven Oracle internal system development efforts, including the Oracle online store.

Denes Kubicek is chief executive officer and founder of bi-Cubes. He has been working with Oracle more than 12 years. Denes is an Oracle ACE Director, and was APEX Developer of the Year in 2008. Denes is also a coauthor of the first APEX book in German, Oracle APEX und Oracle XE in der Praxis. You can reach him at bi-Cubes.com.

Dan McGhan is a senior developer and instructor with SkillBuilders. He suffers from Compulsive Programming Disorder, which is believed to be linked to his balding. Having started his development career in the land of MySQL and PHP, he was only too happy to have stumbled upon APEX. Since then, he’s dedicated his programming efforts to learning more about Oracle and web-based technologies in general. Dan is an Oracle Application Express Certified Expert, an Oracle PL/SQL Developer Certified Associate, as well as an Oracle ACE. In addition to his "day job," he is one of the top contributors to the APEX forum, maintains his own Oracle and APEX blog, and is a regular presenter at various events, including ODTUG Kaleidoscope and APEXposed. He also presents at meetings of the New York, New England, and Suncoast Oracle User Groups. His most recent addiction, as you may have guessed, is developing plug-ins for APEX. When not programming, Dan may be found studying languages other than those used for development, notably Spanish and Italian. He’s also been sighted at various venues dancing salsa with his fiancée, Sonia, and even enjoying an occasional cigar, a time when Sonia prefers not to be around.

Sharon Kennedy is part of the Application Express development team. She likes to stay behind the scenes, working on release management isues, supporting early adopter releases, and working on special projects (both internally and externally). She also has a hand in core development and bug fixing. Sharon has been with Oracle for more than 20 years, and has been part of the APEX team for more than 10. Prior to her work on APEX, she was part of Oracle Consulting and responsible for delivering custom applications to the healthcare, navy, and intelligence industries. Her working life before Oracle began at Grumman Data Systems, which is where she got handed an Oracle 5 reference manual one day while being asked to "help out" on a project.

Product Details

  • Paperback: 620 pages
  • Publisher: Apress; 1 edition (June 13, 2011)
  • Language: English
  • ISBN-10: 1430235128
  • ISBN-13: 978-1430235125
  • Product Dimensions: 9.2 x 7.5 x 1.3 inches
  • Shipping Weight: 2.4 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #149,024 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

5 Reviews
5 star:
 (5)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (5 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

4 of 4 people found the following review helpful:
5.0 out of 5 stars Real world information that you can use including why you'd want to, August 29, 2011
Amazon Verified Purchase(What's this?)
This review is from: Expert Oracle Application Express (Paperback)
One of the fundamental problems with most documentation from most technology companies is that the documentation usually contains a bunch of assumed knowledge.

Take for example, the Oracle Application Express Installation Guide for Release 4.1. This document has the following line in Section 1.4 About Choosing an HTTP server. "In order to run, Oracle Application Express must have access to Oracle Application Express Listener, Oracle HTTP Server and mod_plsql or the embedded PL/SQL gateway." Yep. That's right... sort of. As an experienced installer of APEX, I know that they mean: There are three different ways to connect to Oracle Application Express:

The Oracle Application Express Listener
An Oracle HTTP Server and mod_plsql
The embedded PL/SQL gateway

But, if I was a brand new person with no experience, I might wonder if I need the Oracle Application Express Listener + an Oracle HTTP Server + mod_plsql, or the embedded PL/SQL gateway. Reading the rest of the guide might give me an idea, but for a while I might be confused.

However, I often waffle back and forth between what the biggest problem with technology documentation is: Is it assumed knowledge? Or is it the fact that almost all technology documentation tells you what some setting or button does, but it almost always leaves out the `and here is why you would want to do this' information. You could make the argument that they are one in the same, but I usually see them as different problems. The second problem really comes into play when there are choices. If there are no choices then just telling me what I have to do is fine. Just make sure I know how to do it. I once saw a step in an installation guide that was "Configure SQL/Net". No links to other documentation. No explanation on how to do it. Just "Configure SQL/Net". Ummm... Aren't you kind of assuming that I know how to do that? (And lest it seem like I'm picking on Oracle here, I've seen this in all types of documentation from other technology companies like Microsoft and Dell to even simple things like power tools.) But when I have choices, let me know what those choices mean to me and why I'd choose one over the other.

While it would be great if all the documentation from technology vendors addressed both problems, I doubt it will happen soon. Until then we have books like Expert Oracle Application Express.

This book is 13 chapters long and each chapter was written by a different author. At first that sounds like a recipe for disaster. But when you realize that each author is a pillar of the APEX community and a subject matter expert on their chapter and (most importantly) each of the chapters is excellent, you suddenly realize you're holding a treasure in your hands.

Each chapter contains real world experience including the all important `and here is why you would want to do this'. If fact chapter 1 by John Scott addresses the above connection to Oracle Application Express issue. Sure there are three ways to do it, but why would I want to use one way or the other? Well, read chapter 1 and you will know.

I spent 14 years at Oracle and taught hundreds of people how to use Oracle Application Express and I thought at least some of the chapters would be a bit of a review for me, but I can truly say that I learned valuable information from each and every chapter.

I highly recommend this book to anyone who is going to be using Oracle Application Express.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


2 of 2 people found the following review helpful:
5.0 out of 5 stars APEX Deep Dives, July 15, 2011
This review is from: Expert Oracle Application Express (Paperback)
I am not normally one who likes books with multiple authors, but in this case, that's the best way for this book to be written. 13 authors each write a chapter about different aspects of APEX, giving you a deeper understanding of their chosen subject.

With the way the book is written there is no dependency on reading one chapter before the others and you can easily read the sections that interest you most first and then move on to the other chapters at your leisure.

Here is a breakdown of the chapters:

Chapter 1: OHS, EPG and APEX Listener Compared. In this chapter John Edward Scott looks at the different web server choices and the pros and cons of each. He also shows you how to help make the server as efficient as possible.

Chapter 2: Oracle APEX 4.0 Charts Inside Out. In this chapter Dimitri Gielis talks about the options available for charting (HTML and Flash based). He talks about what goes on behind the scenes with charting and how to customize the XML generated that is used by the AnyChart engine to tweak your charts.

Chapter 3: Tabular Forms. In this chapter Denes Kubicek talks about what has changed with tabular forms in APEX 4.0 and how to code around "missing" functionality that he would like to see implemented in future versions.

Chapter 4: Team Development. In this chapter Roel Hartman talks about using the team development functionality built into APEX to track your projects bugs and development. While not a true project management tool, Roel gives some examples of how you can extend to the tool to add some missing functionality, and how to work with the feedback functionality.

Chapter 5: Globalization. In today's world applications and web sites are being accessed from all over the world. If your company deals with international clients, or you want to reach as many people as you can with your website, then globalization is important. In this chapter Francis Mignault takes you through the steps necessary to help set up your application for globalization and how to use translation to help users of your non-native language be able to interact with your application.

Chapter 6: Debugging. Doug Gault shows you how to use tools (both internal to APEX and external) to help you debug your application. He also mentions using debugging information to help spot performance trends over time, and what debugging information might not be captured and why.

Chapter 7: Dynamic Actions. Martin Giffy D'Souza talks about one of the most popular new features to be found in APEX 4.0. He talks about what dynamic actions are, how to create them and how they can be used.

Chapter 8: Security. In this chapter Anton Nielsen talks about how to help secure your application. In today's world more and more hackers are out there trying to get unauthorized access to your system whether for fun or profit. Anton talks about different types of attacks that can be used and ways to help close the security holes.

Chapter 9: Lifecycle Management. In this chapter Dietmar Aust shows us how to handle your project as it goes through its various changes. He talks about best practices and shows why it's necessary to have a standard process in place for handling releases.

Chapter 10: Working with APEX Collections. In this chapter Raj Mattamal shows us what APEX collections are and how/where to use them to extend APEX's native session state functionality.

Chapter 11: Plug-Ins. In this chapter Dan McGhan shows us the different types of plug-ins that available for creation, shows us the plug-in architecture and walks us through examples of creating each of the different types.

Chapter 12: Architecture. In this chapter Michael Hichwa gives a brief overview of APEX and provides some insight into what goes on behind the scenes.

Chapter 13: Advanced Interactive Reporting. Here Sharon Kennedy shows us how to take the data stored in our databases and present it nicely with APEX's built in reporting tool.

This is an excellent book that I feel will help take someone with a good understanding of APEX development to the next level. I feel the authors did what they set out to accomplish with this book, and I highly recommend it to anyone using APEX for web development.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 1 people found the following review helpful:
5.0 out of 5 stars Well, Written, July 23, 2011
By 
jtv (REXBURG, ID, US) - See all my reviews
This review is from: Expert Oracle Application Express (Paperback)
This book is one the best well written tech books I have seen. It is easy to really and follow. It goes into details that other books have left out. The small fact sometime make understanding a product that much easier. Out of all the chapters I think I enjoyed chapter one the best because it gives information about oracle database and application express that other books left out such as the different types of web-servers that are included in the Oracle Database and it gives examples of which of the servers would be best for what type of environment. These include the following: OHS, EPG and the APEX Listener.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews



Only search this product's reviews



Inside This Book (learn more)
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:

What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(3)

Your tags: Add your first tag
 

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
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums


Listmania!


So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject