|
|
| |
|
|
| |
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 comprised of 20 sessions.
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. |
|
| |
|
|
|
|
