| |
May 06, 2024
|
|
|
|
|
2022-2023 Catalog [ARCHIVED CATALOG]
|
DBMS 255 - Advanced Database Application Development
PREREQUISITES: DBMS 130 - Data Management using Structured Query Language .
PROGRAM: Data Analytics
CREDIT HOURS MIN: 3
LECTURE HOURS MIN: 2
LAB HOURS MIN: 2
DATE OF LAST REVISION: Fall, 2020
Oracle Database Development students will develop applications in an Oracle database environment. Students will utilize an integrated platform that supports Structured Query Language, Extensible Markup Language, and procedural languages in a simple fashion with high performance and scalability. Oracle Database Development students will use many of the features of database application development including languages, tools, connectivity and technologies in a culminating database application development project.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Identify the components and specifications of Oracle Application Express (APEX).
- Perform an installation and configuration of APEX.
- Create and administer a workspace and a workspace administrator and developer user.
- Use Object Browser to browse, create, and modify objects in the schema.
- Use Query Builder to create, run, and save SQL queries.
- Construct an application using APEX.
- Generate data definition language (DDL) statements.
- Create, manipulate and customize interactive reports manually and using wizards.
- Design and modify multiple types of forms manually or with themes and templates.
- Develop and view page and region attributes.
- Create a web sheet application including forms and reports including items and buttons.
- Explain the difference between page rendering and page processing.
- Utilize computations, data validation, and data processing in your application.
- Apply application branching, navigation, and shared components, such as tabs and lists.
- Produce Dynamic Content and Dynamic actions including charts and calendars.
- Implement Security measures including authentication, authorization, and access control and session state protection and debugging.
- Verify, deploy, manage, and maintain a completed application using the Application Development Process and Advisor.
COURSE CONTENT: Topical areas of study include -
- Oracle Application Express (APEX)
- SQL Workshop
- Workspace and Workspace Users
- Application Creation
- Query Builder
- Page and Region Attributes
- Report and Form Creation
- Data Grid and Report
- Web Based Applications
- Session State and Debugging
- Page Processing
- Data Validation and Data Processing
- Application Branching and Navigation
- Dynamic Content and Dynamic Action
- Imports and Plugins
- Themes and Templates
- Schema or Storage Requests
- Authentication versus Authorization
- Attribute Dictionary
- Session State Protection
- Data Definition Language (DDL)
- Application and Page Utilities
- Object Browser
Course Addendum - Syllabus (Click to expand)
|
|
