Java Programming Language Duration of the course and training schedule

Module 1. Introduction to the database theory

1 .  Introduction to the database theory .

2 .  History of the Oracle DBMS .

3 .  Architecture of the Oracle DBMS .

4 .  Versions of the Oracle DBMS .

5 . Utilities .

6 .  Demonstration: Oracle DBMS installation . 

7 .  Architecture of a database being under the control of Oracle .  

  Comparison with other DBMSs .

8 . Demonstration .

9 .  Practice: creation of a database using the configuration file .

10 . Basics of interaction with Oracle .

11 . Queries .

Module 2. SELECT, INSERT, UPDATE, and DELETE queries

1 .  The SELECT operator . 

2 .  IN, BETWEEN, and LIKE keywords .

3 .  The INSERT operator .

4 .  The UPDATE operator .

5 .  The DELETE operator .

Module 3. Multi-table databases

1 .  Abnormalities in the interaction with a single-table database . 

2 .  Principles of creation of a multi-table database . 

3 .  Multi-table queries .