|
| |
|
|
| |
Oracle Database Development
|
| |
|
|
| |
Course Benefits:
Oracle is a complex object-relational DBMS that enables high-speed transactions, better business
decisions and sophisticated applications. An understanding of its internal functions is essential to
maintain integrity, enforce security and improve performance. In this hands-on course, students will
gain a comprehensive introduction to Oracle, providing them the skills needed to take advantage of critical
database features. The hands-on exercises provide practical experience developing robust, high-performance
and scalable applications.
Time Allocation:
Oracle is an 80 hour course.
This course will include:
Client-Server Application basics
Designing Relational Databases
Data Types
Data Modeling
Normalization Techniques
Introduction into SQL language
SQL Plus Line Editor
SQL Queries, Retrieving Data
SQL Plus Reporting Tools
Data Manipulation Language
Oracle Functions
Transaction Control
Security in Oracle, Data Control Language
Data Definition Language
Integrity Constraints
SQL Plus Host Variables
SQL Plus Code Generator
Introduction into PL / SQL Language
Creating Triggers using PL / SQL
Who Should Attend:
This course is valuable for Programmers and
Software Developers as well as System Analysts
and other computer professionals.
Prerequisite:
Experience with macros and / or a scripting language. |
|
| |
|
|
|
|
