Muutke küpsiste eelistusi

Oracle Application Express: Build Powerful Data-Centric Web Apps with APEX [Pehme köide]

  • Formaat: Paperback / softback, 496 pages, kõrgus x laius x paksus: 231x183x25 mm, kaal: 848 g, 150 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Jun-2017
  • Kirjastus: McGraw-Hill Professional
  • ISBN-10: 0071843043
  • ISBN-13: 9780071843041
Teised raamatud teemal:
  • Formaat: Paperback / softback, 496 pages, kõrgus x laius x paksus: 231x183x25 mm, kaal: 848 g, 150 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Jun-2017
  • Kirjastus: McGraw-Hill Professional
  • ISBN-10: 0071843043
  • ISBN-13: 9780071843041
Teised raamatud teemal:
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.







Develop Robust Modern Web Applications with Oracle Application Express. Covers APEX 5.1.

Easily create data-reliant web applications that are reliable, scalable, dynamic, responsive, and secure using the detailed information contained in this Oracle Press guide. Oracle Application Express (APEX): Build Powerful Data-Centric Web Apps with APEX features step-by-step application development techniques, real-world coding examples, and best practices. You will find out how to work with the App Builder and Page Designer, use APEX themes (responsive and mobile included), templates and wizards, and design and deploy custom web apps. New and updated features in APEX 5.0/5.1 are thoroughly covered and explained.

 Understand APEX concepts and programming fundamentals  Plan and control the development cycle, using HLD techniques  Use APEX themes and templates, including Universal Theme  Use APEX wizards to rapidly build forms and reports on database tables  Build modern, dynamic, and interactive user interface using the Page Designer  Increase user experience using Dynamic Actions (Ajax included)  Build and utilize the new APEX 5.1 Interactive Grid  Implement App Logic with APEX computations, validations, and processes  Use (automatic) built-in and manual DML to manipulate your data  Handle security at browser, application, and database levels  Successfully deploy the developed APEX apps
Acknowledgments xv
Introduction xvii
1 Introduction to Oracle Application Express 1(26)
A Native Web Tool for Developing Web Applications
2(3)
Native to the Web World
3(1)
Client-Side Platform Independent
4(1)
Effortless Deployment to Clients
5(1)
A Declarative RAD IDE
5(2)
Oracle Database Data-Centric Applications Tool
7(1)
Oracle Database Tool
7(1)
Data-Centric Applications
8(1)
APEX Architecture
8(14)
The APEX Engine
11(6)
Everything in Between
17(5)
Installation, Configuration, and Upgrade
22(3)
The Installation Process
22(2)
APEX Upgrade
24(1)
Summary
25(2)
2 Getting Ready 27(24)
Recommended Prerequisite Knowledge
28(2)
SQL and PL/SQL
28(1)
HTML/HTML5, CSS, and JavaScript
29(1)
jQuery
29(1)
Ajax
29(1)
Application Planning
30(9)
High Level Design
31(8)
Best Practice: Document Your Work
39(1)
The Book Demo Application: Contacts in the Cloud
40(9)
Application Business Logic and QA Scenarios
41(2)
Designing the Data Structures
43(3)
Data Modeling
46(3)
Summary
49(2)
3 APEX IDE: Quick Tour and Basic Concepts 51(30)
Working with the APEX IDE
52(11)
Main Menu
54(1)
Developer Navigation Tools
55(6)
Other Elements on the Workspace Home Page
61(2)
Major Modules of the APEX IDE
63(17)
App Builder Module
63(10)
SQL Workshop Module
73(4)
Team Development Module
77(2)
Packaged Apps Module
79(1)
Instance Administration Module
79(1)
Summary
80(1)
4 APEX Applications: Concepts and Building Blocks 81(62)
The APEX Instance
82(1)
The APEX Workspace
82(5)
Workspace Users
86(1)
APEX Applications
87(8)
Desktop Applications
87(3)
Mobile Applications
90(1)
Application-Level Features and Shared Components
90(1)
Websheet Applications
91(4)
APEX Themes (Concepts)
95(6)
APEX Themes: Evolution and Revolution
95(3)
APEX Templates
98(3)
APEX Pages
101(7)
APEX Page Types
102(4)
APEX Page Mode
106(2)
APEX Regions
108(3)
APEX Items
111(25)
APEX Application Items
111(2)
APEX Page Items
113(23)
APEX Buttons
136(6)
Button Properties
136(6)
Summary
142(1)
5 The Page Designer 143(32)
Installing the Sample Database Application
144(1)
Navigating the New Page Designer
144(23)
The Toolbar
145(7)
The Three Panes
152(15)
Laying Out Items on a Page
167(3)
Layout Properties
167(3)
Keyboard Shortcuts
170(3)
Summary
173(2)
6 APEX Wizards 175(78)
The Application Wizard
176(6)
The Report Region
182(4)
The Form Wizard
186(6)
Form Wizard Review
190(2)
Customizing a Report
192(6)
Testing the Report Link
194(2)
Creating a Button
196(2)
Creating a Contact Record
198(3)
Creating Interactive Reports
201(19)
Column Headings
202(1)
Reports Toolbar
203(14)
Behind the Interactive Report Properties
217(2)
Behind the Interactive Report Columns
219(1)
Interactive Grids
220(22)
Create an Interactive Grid
220(6)
The Interactive Grid Toolbar
226(7)
Row Actions Menu
233(2)
Edit and Save Buttons
235(1)
Other Features of Interactive Grids
235(1)
Editing Data with the Interactive Grid
236(1)
Interactive Grid Validations
237(1)
Advanced Interactive Grid Options
238(2)
Allowed Row Operations Column
240(2)
Master Detail Form and User Interface Defaults
242(9)
Creating a Master Detail Form
243(5)
User Interface Defaults for a Table
248(3)
Summary
251(2)
7 Computations, Validations, Processes, and Branches 253(32)
Computations
254(8)
Computation Types
254(1)
Page Execution Points
255(1)
Creating a Computation
256(6)
Validations
262(9)
Item-Level Validation
262(3)
Page-Level Validation
265(1)
Interactive Grid Validations
266(5)
Processes
271(6)
Process Types
271(2)
Working with Processes
273(4)
Branches
277(6)
Branch Execution Points
277(1)
Branch Types
278(1)
Creating Branches
279(4)
Summary
283(2)
8 Crafting a Powerful UI 285(70)
Themes and Templates
286(28)
User Interface Attributes
286(9)
Themes
295(4)
Templates
299(15)
Using the Universal Theme in Your Application
314(35)
Pages
314(2)
Regions
316(7)
Lists
323(12)
Reports
335(6)
Buttons
341(1)
Forms
342(4)
Calendars
346(3)
Theme Roller
349(4)
Live Template Options
353(1)
Summary
354(1)
9 Dynamic Actions 355(28)
About Dynamic Actions
356(6)
Benefits of Dynamic Actions
356(1)
Getting Started
356(1)
Bind Events
357(3)
Actions
360(1)
Anatomy of a Dynamic Action
361(1)
Creating a Dynamic Action
362(19)
Simple Show/Hide
362(3)
Dynamic Actions Affecting Multiple Items
365(5)
Dynamic Actions Using PL/SQL
370(3)
Advanced Dynamic Actions-Putting It All Together
373(8)
Summary
381(2)
10 APEX Security 383(50)
Application Attack Points
384(1)
Instance-Level Security
385(9)
Security Section
386(1)
HTTP Protocol Section
387(1)
Session Timeout Section
388(1)
Workspace Isolation Section
388(1)
Region and Web Service Excluded Domains Section
389(1)
Authentication Control Section
389(3)
Password Policy Section
392(1)
REST Administration Interface Section
392(2)
Workspace-Level Security
394(6)
Workspace Groups
396(1)
Managing Workspace Users
397(3)
Application-Level Security
400(7)
Application-Level Authentication and Authorization Sections
400(2)
Application Session
402(2)
Session State Protection Section
404(1)
Browser Security Section
404(3)
Page-Level Security
407(2)
Security Properties
407(1)
Advanced Properties
408(1)
Server Cache Properties
408(1)
Region and Item-Level Security
409(2)
Regions Properties
409(1)
Items Properties
409(2)
Conditional Statements
411(3)
Authentication Schemes
414(2)
Authorization Schemes
416(2)
Access Control
418(2)
Security in Action
420(12)
Authorization Schemes
421(2)
Session State Protection and Item Encryption
423(3)
Conditions
426(1)
Application Context and Views
426(6)
Security Reporting
432(1)
Summary
432(1)
11 Packaging and Deployment 433(24)
Packaging Overview
434(9)
Packaged Applications
434(9)
Application Exports
443(4)
Copy Your Application in the Same Workspace
443(1)
Move to a New Workspace that Uses the Same or a Different Schema
444(3)
Application Import/Export Strategies
447(8)
Exporting Components
447(4)
Importing an Application or Component
451(4)
Summary
455(2)
Index 457
Arie Geller is an independent IT consultant and software developer with more than 35 years of experience with systems analysis, software development, and IT infrastructure. He is an active member of the APEX community who frequently shares his knowledge and expertise.





Brian Spendolini has worked at Oracle for over 12 years and has been using Oracle Application Express since its inception. He is presently a Senior Principal Product Manager for Oracle's Database Cloud Services.