 |
|
Course Main Module : Relational Database Management System - ORACLE
Duration
Full time : 4 weeks full time
Course days : Monday - Friday
Course Structure
The course aims at covering all the facilities provided by modern Relational Database Management Systems and their 4GL development tools.
The RDBMS
- Structure
- Concept of Client - Server Architecture
- Data storage and database files
- Journals and other log files
- Database initialisation and sizing
- Tunable system parameters
- Hardware specific settings
- General system tables
Data design for RDBMS
- Data normalisation
- Entity modelling
- Primary, relational key fields and Indexes
SQL - Structured Query language
- SQL Language constructs
- Data Definition Statements
- Data Manipulation Statements
- Functions
- Tables, Fields, Data Types, Constraints
- Joins, Views
Database Administration
- Access Control
- Resource allocation
- Backup, Export and Import of data
- Data recovery
Procedural Language
- Language constructs
- Data Definition Statements
- Data manipulation Statements
- Functions
- Selection and Loop control statements
- Exception handling
- User defined Procedures and Functions
Interactive SQL Utility
- Commands
- Format settings
Form Design utility
- Forms painter
- Form block and field definition
- Table linking and update
- Field attribute setting
- Data validation
- Event based form control techniques
Report Design Utility
- Report layout design
- Report query structure
- Field attributes setting
- Page control settings
- Printer control setting
Menu Design Utility
- Menu Design
- Linking Forms, reports, Menus and other facilities
- Access Control
Language Support - Embedded SQL Programming
- Using SQL statements in C programs
- Use of RDBMS Pre-Compilers