Corporative data base managing systems

1
Corporative data base managing systems

• 5.5 ECTS
• Course description
• Person in charge Kuznetsova Maria

2
Annotation

• This course is devoted to study of particular
  features of DBMS (data base managing system) on a
  large enterprises scale. It provides knowledge of
  requirements to corporative DBMS, contemporary
  corporative DBMS review.

3
Annotation

• Use of DBMS Oracle (creating triggers, stored
  programs and procedures, PL/SQL, data base
  security, etc.) is presented more detailed.
• Practical lessons are devoted to creating a
  training database using DBMS Oracle.

4
Contents

• Basic definitions
• Introduction into DBMS Oracle
• Data security and integrity
• Database language PL/SQL
• Transactions managing
• Distributed databases

5
Contents (cont.)

• Database restoration and reserve copying
• Complicated data types
• Data warehouses
• DBMS Oracle administration

6
Methods

• Lectures
• Exercises
• Assignments
• Examination

7
Literature

• Oracle 8. First steps. Abby M., Cory M. (2002),
  Publisher LORI.
• Oracle 9i. PL/SQL Programming. Scott Urman.
  (2004), Publisher LORI.
• Oracle SQL secrets, Sanjei Mishra, Alan Bewly,
  (2003)
• Corporative Databases servers. Analytical
  materials of Information technologies center.
  www.citforum.ru