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