- Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)
Beginning Oracle Application Express 4 Paperback – Apr 18 2011
|New from||Used from|
There is a newer edition of this item:
Special Offers and Product Promotions
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
About the Author
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.
Inside This Book(Learn More)
Most Helpful Customer Reviews on Amazon.com (beta)
A ticket system for a help desk is created from scratch. In every chapter of the book, a part of the help system is built.
The book starts by making a description of the requirements of the help desk system and to create a database design. This book also covers the steps of creating an entity relationship diagram. Good database design is the key to creating a successful application, especially with Application Express in mind. The necessary database tables used in the ERD are created in Sql*workshop. Sql*workshop and not the ERD tool is used because the objects are created from scratch.
With the basic data created, a shell is generated for the ticket system. This will be done with the options available in Application Express. After the shell is created for the application, the application is extended with forms, reports, and charts. The strength of this book is that the theoretical part is completely integrated in the exercises. This makes the book even more valuable.
When the basic part of the application is built, there is also a chapter about more advanced techniques within forms and reports. It helps to understand Application Express even better and look behind the scenes.
Programmatic elements in Application Express can provide both simple and complex features to the Application Express framework. So the helpdesk application is extended with conditions, validations on item level and page level, tabular form validations, computations and processes and dynamic actions.
Security in an application is often an afterthought. This book covers this very important topic. The key features of security available within Application Express are added to the application. Authentication is added to the help desk application by making use of a customized authentication scheme. The scheme is used to allow control over users who access the sensitive parts of the application. User access is controlled by access control lists. In the help desk application a check sum is added to the URL. This prevents URL tampering.
Once the application is ready, it needs to be deployed. So you learn how to get an application out of the system and to deploy in the production system. Techniques like export, import, and supporting objects are covered.
Websheets is a new feature in Application Express 4. In the book, you will use the features to build a websheet application from scratch. With the application you can manage your corporate soccer team. Websheets is a very nice feature to manage the soccer team. A complete example how to manage the soccer team is covered in this book.
Advanced development features are also highlighted in this book. These tools help when dealing with large applications. Features like page locks, application and page groups are covered.
Of course, your Application Express side needs to be monitored as well. Each time a page is accessed, a log entry is stored. Subjects like activity logging, login attempts, and managing workspaces are covered in the book.
The last chapter in the book is about the team development feature. Team development is a tool for managing Application Express projects. All features like milestones, to-dos, bugs, feedback and features are discussed.
This book is a `must' for people starting to work and develop applications in Application Express.
Timeliness is of the essence in the fast-paced software field and I can understand the drive to be first to market, but if my code had this many errors, it would never run. I suggest you wait until a new, corrected version is released. I wish I could recommend this book more highly as I think it has a good core and sensible flow.
However (you knew this was coming), I couldn't give it 5 stars for two main reasons.
1. Too many simple editing mistakes. Although, for the most part, they don't impact the overall quality, they are at a minimum annoying, and at their worst confusing to the reader. I found 7 simple errors in the first 30 pages.
2. The exercises needed somebody (not an author) to go through once and identify all the problems. Is the column in the TICKETS table DESCR or DESCRIPTION? Really needs one more look by a technical editor.
All that said, I would still highly recommend it. I plan on using the book as the basis for my APEX 4 classes that I teach. I am hopeful that the errors can be easily fixed in the pdf or kindle versions.
I spent my time trying to follow the instructions on [...], but instructions was not clear and had not relation with my screen.
I had to return it next day!
Readers, not buy this book. It is not ready to publishing.
Authors, reviewing this book could become it in a great book. Please, do it.
Look for similar items by category
- Books > Computers & Technology > Computer Science > Information Theory
- Books > Computers & Technology > Databases > Beginning & Introductory
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Oracle
- Books > Computers & Technology > Internet & Social Media
- Books > Computers & Technology > Networking & Cloud Computing > Internet, Groupware, & Telecommunications
- Books > Computers & Technology > Programming > Algorithms
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Object-Oriented Design
- Books > Computers & Technology > Web Development > Programming
- Books > Deals in Books
- Books > Textbooks > Computer Science & Information Systems > Computer Science
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design