1 / 96

Progressive Skill

Progressive Skill. Who Are We?. We are a full services Business Consulting and Internet Technology Company. Our mission is to improve business process and or generate net income for our customers.

Antony
Download Presentation

Progressive Skill

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Progressive Skill

  2. Who Are We? We are a full services Business Consulting and Internet Technology Company. Our mission is to improve business process and or generate net income for our customers. We focus on database driven solutions leveraging ‘open source code’ models so that our customers are not ‘Hostage’ to the technology.

  3. Projects/Clients

  4. Rapid Application Development • Quick Development of Software Applications • Visual Tools for Development • Very Little Custom Coding/Programming • Easier to Manage Code and Functionality • Faster Testing and Debugging • Simpler Collaboration among multiple skill sets • Shorter Timelines Lower Budgets • Greater Flexibility with changing/adding requirements

  5. Introduction to Application Express(formerly HTML DB)

  6. Agenda • APEX Defined • Uses – who, what, when, where, why • Building applications with APEX • APEX Administration and Monitoring • Tips and Techniques

  7. APEX Defined

  8. Oracle’s answer to “Wizards” Meta Data (lots of it!) Dynamic HTML (fast!) PL/SQL - No Java Does anything you can do in SQL or PL/SQL Nice Web-based team development environment What is APEX?

  9. It’s Origin • Originated from Tom Kyte’s “ASK TOM” site • Used mod_plsql to develop • Became “Project Marvel” then HTML DB • Now it’s APEX • Also referred to as Einstein

  10. You’re a good candidate for APEX if you fit the following profile • You are, or have developers who are, skilled in SQL and PL/SQL • Your application is database-centric • Your application can be developed using a hosted service • You are comfortable with a declarative/4GL programming model • You want to migrate an Access / Excel application to Oracle

  11. APEX.oracle 5,500 active workspaces Dell 6550 4x2.0 Ghz Xeon Processors 6 GB RAM Red Hat AS 2.1 5,500+ schemas DB Size ~75 GB SGA(System Global Area) Size ~1.5GB Average Unique Page Views: 25,000+ per weekday Average Page View Time: <.5 seconds 1 DBA – manages 15 other DBs Scalable?

  12. Major Components • Administration • SQL Workshop • Application Builder

  13. SQL Workshop Interact with your database as with SQL*Plus, but visual Data dictionary and object browsing, query by example Administration Manage users Manage services Monitor activity Application Builder Centerpiece of APEX Loaded with wizards Reports, forms and charts Connect pages using branches 75 pre-defined widgets Basic HTML, pop-up lists, calendars, etc. Full data entry validation Components

  14. Session and State Management Each user has a session Valid username/password is required User Interface Control Look-and-feel is separate from application logic Extensive templates Flexible Authentication and Authorization Schemes Can use pre-built / built-in methods or custom More Features

  15. Apply for a free account at apex.oracle.com Set up other developers / users for testing Can optionally download and install locally Run the script on your 9iR2 or better database (also need Apache listener) Down / Upload your applications to your home system Continue development on your home system Oracle 10g Companion CD Oracle Express Edition Develop your application (read the Help messages – they really do help!) Excellent support via OTN discussion forum “Installing” APEX

  16. Architecture Browser Oracle HTTP Server Oracle Database APEX

  17. Architecture B Browser Firewall Oracle HTTP Server Oracle Database APEX Instead of the Oracle HTTP Server, you can use the HTTP Server supplied with Oracle Application Server 9i or 10g

  18. APEXUses Who, What, When, Where, Why…

  19. What can you do with APEX? • Select Journal Article review system (developed in 2 weeks) • Web Collaboration application (developed in 2 days) • General purpose Customer Survey (developed in 1 day) • Survey Administration screens (developed in 2 hours)

  20. Select Journal Article review

  21. Web Collaboration application

  22. Customer Survey

  23. Survey Administration

  24. Testing Application

  25. Creating an APEX Application Generally speaking

  26. Log into Workspace • Use the Workspace you chose, the username and password emailed to you

  27. Home Menu • You’re ready to begin • Build Applications • Work in SQL • Work with Data • Manage users

  28. Migrate Data • Import data from Spreadsheets, XML or Delimited Files

  29. Load Northwinds? • I loaded the Northwinds Database from SQL Server • Used Periscope to load/copy data • Once loaded, view data using SQL Workshop

  30. Drill and Create • Can • Drill into data • Count rows • Insert/Edit rows • Query by Example • View components • Much more…

  31. Use the Wizards • APEX’s many wizards will simplify your life – use them! • Reports, Charts, Forms, Calendars, Trees, etc.

  32. Create a Hardware Inventory Application

  33. Building an application “from scratch” – in 5 simple steps • Login with developer privileges • Use the SQL tools to make your tables, constraints, triggers, procedures etc. • Start a new application (use the wizard) • Customize the application (check each change as you make it) • Deploy to the users!

  34. ExampleHardware Inventory App • Record and view hardware inventory • Searchable report • Present analysis graphically as well as numerically • Design for novice users • Remote users with access to Internet

  35. Main Menu

  36. Import Data (SQL Workshop)

  37. Converting Data • Previously, data was stored in an Excel spreadsheet • Conveniently, this can be made into an Oracle table by simply copying and pasting into the APEX create table wizard • Select Region • Copy from Excel

  38. Import Data Wizard

  39. Paste Your Data In…

  40. Set Column Preferences

  41. Create a Primary Keyand sequence

  42. Object Detail for Table Created (in Object Browser)

  43. Create Lookup Table • Select column for look up • Specify lookup table specifics

  44. Create an Application

  45. Create the application form scratch (this time)

  46. Add Report and Form based on Hardware table • Notice inclusion of Analysis pages

  47. Specify Details for Analysis

  48. Could add as many pages as you want

  49. Select Levels of Tabs

  50. Can Share Components for other applications

More Related