Educational program "Methods and tools for processing large amounts of data (using Oracle 11 DBMS)"

Section I. INTRODUCTION TO DATABASES
Topic 1.1. Fundamental Concepts of the Relational Model
Topic 1.2. Database management systems

Section II. DATABASE INFORMATION STRUCTURES
Topic 2.1. Concept of a data model
Topic 2.2. Data integrity
Topic 2.3. Ensuring data integrity using Oracle DBMS

Section III. MANAGING DATABASE OBJECTS
Topic 3.1. Data Schema Definition Language (DDL)
Topic 3.2. Displaying data in the Oracle DBMS environment
Topic 3.3. Filtering and organizing data
Topic 3.4. Changing data. Update command

Section IV. DESIGNING QUERIES
Topic 4.1. Using the SELECT Command to Output Data
Topic 4.2. Single-table data retrieval operators
Topic 4.3. Single-table data retrieval operators
Topic 4.4. Multi-table query queries
Topic 4.5. Aggregate and analytical functions
Topic 4.6. Complex queries. Using Subqueries
Topic 4.7. Using regular expressions in string search criteria

Requirements:

1. System Requirements:
   1. operating system MS Windows 7 or higher;
   2. RAM volume – not less than 2 GB;
   3. free disk space – at least 20 GB;
   4. processor architecture x86 64 bit
2. Software requirements:
   1. browser Google Chrome, Mozilla Firefox or Opera (one of them to choose from);
   2. virtual machine player Oracle VirtualBox 6.1 (or higher);
   3. ZOOM video conferencing application.
3. Other requirements:
   1. constant Internet connection at a speed of at least 5 Mb/s;
   2. availability of an email address.
       

Preliminary class schedule:

______ - 10.00 - 16.30 (8 academic hours);
______ - 10.00 - 16.30 (8 academic hours);
______ - 10.00 - 16.30 (8 academic hours);
______ - 10.00 - 16.30 (8 academic hours);
______ - 10.00 - 13.00 (4 academic hours), test.