Subject syllabus:
1.Subject introduction
-Subject relations, exam requirements, literature
2.System ORACLE.
-Oracle10g database product fami
- Allocating and managing space for the objects
-Block, extent, segment, tablespace as elements of memory organisation
3.SQL Plus.
-Formatting and editing reports, Column statement, Ttitle, Btitle statement
-Calculating Summary lines, Break statement, Compute statement
4.Introduction to PL/SQL language
-The Declaration section, Executable commands section
5.Oracle database security.
-Database system privileges-Create user, Alter user, Drop use statement
-Roles and privileges, standard roles, Grant statement, Revoke statement
-Database object privileges – Grant statement, revoke statement
6.Transaction Processing
-Basic features, a multiversion consistency model in Oracle, Set transaction command
7.Connection to remote database, DML lock, materialized view
-Sharing data, statement Lock
-Creating and using database link
8.Database management system
-Third generation database systems, features of the object-relational databases
9.Object features implemented in Oracle
-Object data type,methods, varying arrays, nested tables
10.Object features implemented in Oracle
-object tables, references, inheritance and a type hierarchy
11.Object oriented databases
-ODMG object model, ODL Language
12.Physical data organisation
-Types, sequential structure, indexes, pointer chain structure, hashing
13.Physical data organisation
-Bitmap indexes, B-trees indexes, examples and implementation in DBMS
1.Subject introduction
-Subject relations, exam requirements, literature
2.System ORACLE.
-Oracle10g database product fami
- Allocating and managing space for the objects
-Block, extent, segment, tablespace as elements of memory organisation
3.SQL Plus.
-Formatting and editing reports, Column statement, Ttitle, Btitle statement
-Calculating Summary lines, Break statement, Compute statement
4.Introduction to PL/SQL language
-The Declaration section, Executable commands section
5.Oracle database security.
-Database system privileges-Create user, Alter user, Drop use statement
-Roles and privileges, standard roles, Grant statement, Revoke statement
-Database object privileges – Grant statement, revoke statement
6.Transaction Processing
-Basic features, a multiversion consistency model in Oracle, Set transaction command
7.Connection to remote database, DML lock, materialized view
-Sharing data, statement Lock
-Creating and using database link
8.Database management system
-Third generation database systems, features of the object-relational databases
9.Object features implemented in Oracle
-Object data type,methods, varying arrays, nested tables
10.Object features implemented in Oracle
-object tables, references, inheritance and a type hierarchy
11.Object oriented databases
-ODMG object model, ODL Language
12.Physical data organisation
-Types, sequential structure, indexes, pointer chain structure, hashing
13.Physical data organisation
-Bitmap indexes, B-trees indexes, examples and implementation in DBMS