SQL 1st level



The course is intended for
  • Junior programmers and students studying information technology, 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


    October


    Duration


    8 weeks, 16 lessons, 1.5 hours


    Level


    1-st level



    Lecturers
    Mihran Simonyan

    Head of programming team at Armsoft

    Mesrop Melikyan

    Software engineer at Armsoft


    Prerequisite for attending the course: interview.