SQL 2nd level



The course is intended for
  • Programmers and individuals with 2+ years of work experience in the IT field.

    • Program
    1. Database physical structure
    2. 2. Indexes
    3. 3. B-trees
    4. 4. Query execution plan
    5. 5. Concurrency control & crash recovery
    6. 6. Transaction theory
    7. 7. Two-Phase Locking (2PL) scheduler
    8. 8. Concurrency control via SQL
    9. 9. Concurrency in distributed DB systems
    10. 10.Types of DB system failures
    11. 11. Recovery after system crashes
    12. 12. Recovery after disk/storage failures
    13. 13. Distributed recovery & Two-Phase Commit (2PC)
    14. 14. Data replication

    Start



    Duration


    8 weeks, 16 lessons, 1.5 hours


    Level


    2nd level



    Lecturer
    Ashot Vasilyan

    Head of Chief Engineer Department
    at ArmSoft
    CTO, Assistant Professor,
    YSU IT Educational and Research Center Ph.D.


    Prerequisite for attending the course: interview.