SQL 1st level



The course is intended for
  • Junior programmers and students studying information technologies, data and business analysts.

    • Required knowledge:
  • Basic knowledge of mathematics and mathematical thinking.

    • Program
    1. 1. Introduction, simple SQL queries
    2. 2. Grouping and Aggregation
    3. 3. Joins
    4. 4. Subqueries
    5. 5. Union, intersect, except operators
    6. 6. Creating tables : (Permanent and temporary)
    7. 7. Insert, update, delete operators
    8. 8. Stored procedures
    9. 9. Indexes, Views
    10. 10. User-defined functions
    11. 11. APPLY operator
    12. 12. Triggers
    13. 13. Transactions and isolation levels
    14. 14. Ranking Functions, Rollup, Cube
    15. 15. Separation action (multitudes comparison)
    16. 16. Creation of Databases, physical structure, files: Performing queries in Databases: Execution plan
    17. 17. Linked Servers (Database Engine)

    Start



    Duration


    12 weeks, 2 lessons per week


    Level


    1-st level



    Lecturers
    Mihran Simonyan

    Senior software engineer at Armsoft since 2011

    Mesrop Melikyan

    Software engineer at Armsoft since2017


    Prerequisite for attending the course: written or online test on the following topics: multitudes theory, combinatorics, basics of logic.