| |
May 06, 2024
|
|
|
|
|
2022-2023 Catalog [ARCHIVED CATALOG]
|
DBMS 235 - Oracle PL/SQL 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
Students will focus on developing applications in an Oracle Database environment. Students will build and test applications using the functionality of tools in Oracle. Students will develop and test application functionality across multiple platforms and environments, deploy to production code, and build and validate enterprise-ready solutions.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Identify the components and specifications of Oracle Database.
- Perform an installation and configuration of Oracle Database.
- Design and modify file groups, tables, views, and indexes.
- Create and alter stored procedures and user-defined functions (UDFs).
- Create and alter DML and DDL triggers.
- Create and deploy CLR-based objects and error handling.
- Perform transaction management and track data changes.
- Use Query Builder and SQL Developer to create, run, and save SQL queries.
- Construct an application using developer tools.
- 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.
- Implement subqueries and joins.
- Demonstrate mastery of PL/SQL through integration with queries and triggers and to automate database tasks such as backup.
- Integrate Database Mail.
- Utilize appropriate scripting with environment appropriate tools to automate database administration tasks.
- Utilize XML to retrieve, transform and manage data.
- Analyze performance information using EXPLAIN PLAN and Query Optimizer.
- Implement Security measures including authentication, authorization, access controls and session state protection and debugging.
- Verify, Deploy, manage and maintain a completed application using development tools.
COURSE CONTENT: Topical areas of study include -
- File Groups
- Transaction Management
- Query Builder
- Aggregate Queries
- Application Creation
- Subqueries and Joins
- Report and Form Creation
- Database Mail
- Tables, Views, Indexes, and Constraints
- Full-Text Search
- Partitioning
- Windows PowerShell
- Access Control
- Session State and Debugging
- Service Broker Solutions
- Error Handling
- Data Validation and Data Processing
- XML
- Data Definition Language (DDL)
- EXPLAIN PLAN
- Stored Procedures
- Query Optimizer
- CLR Objects
- Database Tuning Advisor
- User Defined Functions (UDFs)
- Catalog Views
Course Addendum - Syllabus (Click to expand)
|
|
