Learning outcomes:
to know: types and properties of modern information systems and technologies, the possibility of their use for data processing, database language, including the Transact-SQL language;
to be able: apply modern information systems and technologies to automate work related to information processing, including work with modern information systems, use modern methods of search and information analysis, presentation of results and analysis of information security. To be able to create and use objects DBMS MS SQL SERVER;

Prerequisites: programming (part 1 and part 2), object-oriented programming, system programming;
Corequisites: visual programming;

Information, data, knowledge, aspects of the data. The concept of information technology. Features and Tasks IS. File information systems (FIS). The idea of ??the database. The life cycle engineering products. Models IS development life cycle (task model cascade model, spiral model). Concept data model (DM). Strong and semi DM. The model "entity-relationship". Communication. Integrity constraints and business rules. Data models. Relational data model. Relational algebra and its operations. Relational calculus on tuples and domains. Anomalies and their types. 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Description language data and data manipulation. History, role and importance of SQL language. Relational operations as data manipulation language commands. Virtual attributes and tables. Operators Select, Insert, Update and Delete. Triggers, stored procedures, functions, cursors. The structure of the database. The structure of external memory. Storage tables. Indices and B-tree. The hash-function and service information. Types of tables. Tables, organized in a heap. Table, organized by the index. Tables in the index cluster. Tables hash cluster. The attached table. Temporary table. Representation. Using concepts in SQL-queries. Transactions and integrity of the database. Transaction isolation levels. Serialization of transactions. Conflicts between transactions. Synchronization capture. Granular synchronization capture. Predicative synchronization capture. The concept deadlock (Deadlock), Earl expectations transaction method timestamps. Data security. User registration. Managing access rights. Mandatory protection methods. Logging access.

1. V. Pasichnyk. Orhanizatsiya baz danykh ta znan'. Pidruchnyk. Vydavnytstvo Pyter, 2006 r. 384 s.
2. Kannoli T., Behh K., Strachan A. Bazy danykh. Proektuvannya, realizatsiya i suprovid. Teoriya i praktyka. Druhe vydannya. /Vyl'yams. – 2001.-1120s.
3. K. Dzh. Deyt. Vvedenye v systemы baz dannykh – 7-e yzd. — M.: Vyl'yams, 2001. — S. 1072. — ISBN 5-8459-0138-3.
4. K. Dzh. Deyt. Vvedenye v systemy baz dannykh – 8-e yzd. — M.: Vyl'yams, 2006. — S. 1328. — ISBN 5-8459-0788-8.
5. Robert Vyeyra. SQL Server 2005. Prohrammyrovanye (1,2 chast'). Bynom. Laboratoryya znanyy.: –2004. ISBN: 5-94774-108-3.
6. Robert Vyeyra. Prohrammyrovanye baz dannykh Microsoft SQL Server 2008. –Dyalektyka.
7. Ul'man D., Uydom D. Proektuvannya baz danykh. K. - Lory.- 2000.- 347.
8. Kuznetsov D. Osnovy sovremennykh baz dannykh. –Materyaly Tsentra Ynformatsyonnykh Tekhnolohyy MHU 1997, 300 s.
9. Dzh. Bouman,S.Emerson. Praktycheskoe rukovodstvo po SQL.
10. Dzheyms Hroff, Pol Vaynberh. SQL polnoe rukovodstvo, 2-e yzd.

Current control: practical employments, laboratory employments , verbal questioning, two control works (totally 40 %);
Final control: (60%): examination in writing.

Learning outcomes:
to know: types and properties of modern information systems and technologies, the possibility of their use for data processing, database language, including the Transact-SQL language;
to be able: apply modern information systems and technologies to automate work related to information processing, including work with modern information systems, use modern methods of search and information analysis, presentation of results and analysis of information security. To be able to create and use objects DBMS MS SQL SERVER;

Prerequisites: programming (part 1 and part 2), object-oriented programming, system programming;
Corequisites: visual programming;

Information, data, knowledge, aspects of the data. The concept of information technology. Features and Tasks IS. File information systems (FIS). The idea of ??the database. The life cycle engineering products. Models IS development life cycle (task model cascade model, spiral model). Concept data model (DM). Strong and semi DM. The model "entity-relationship". Communication. Integrity constraints and business rules. Data models. Relational data model. Relational algebra and its operations. Relational calculus on tuples and domains. Anomalies and their types. 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Description language data and data manipulation. History, role and importance of SQL language. Relational operations as data manipulation language commands. Virtual attributes and tables. Operators Select, Insert, Update and Delete. Triggers, stored procedures, functions, cursors. The structure of the database. The structure of external memory. Storage tables. Indices and B-tree. The hash-function and service information. Types of tables. Tables, organized in a heap. Table, organized by the index. Tables in the index cluster. Tables hash cluster. The attached table. Temporary table. Representation. Using concepts in SQL-queries. Transactions and integrity of the database. Transaction isolation levels. Serialization of transactions. Conflicts between transactions. Synchronization capture. Granular synchronization capture. Predicative synchronization capture. The concept deadlock (Deadlock), Earl expectations transaction method timestamps. Data security. User registration. Managing access rights. Mandatory protection methods. Logging access.

1. V. Pasichnyk. Orhanizatsiya baz danykh ta znan'. Pidruchnyk. Vydavnytstvo Pyter, 2006 r. 384 s.
2. Kannoli T., Behh K., Strachan A. Bazy danykh. Proektuvannya, realizatsiya i suprovid. Teoriya i praktyka. Druhe vydannya. /Vyl'yams. – 2001.-1120s.
3. K. Dzh. Deyt. Vvedenye v systemы baz dannykh – 7-e yzd. — M.: Vyl'yams, 2001. — S. 1072. — ISBN 5-8459-0138-3.
4. K. Dzh. Deyt. Vvedenye v systemy baz dannykh – 8-e yzd. — M.: Vyl'yams, 2006. — S. 1328. — ISBN 5-8459-0788-8.
5. Robert Vyeyra. SQL Server 2005. Prohrammyrovanye (1,2 chast'). Bynom. Laboratoryya znanyy.: –2004. ISBN: 5-94774-108-3.
6. Robert Vyeyra. Prohrammyrovanye baz dannykh Microsoft SQL Server 2008. –Dyalektyka.
7. Ul'man D., Uydom D. Proektuvannya baz danykh. K. - Lory.- 2000.- 347.
8. Kuznetsov D. Osnovy sovremennykh baz dannykh. –Materyaly Tsentra Ynformatsyonnykh Tekhnolohyy MHU 1997, 300 s.
9. Dzh. Bouman,S.Emerson. Praktycheskoe rukovodstvo po SQL.
10. Dzheyms Hroff, Pol Vaynberh. SQL polnoe rukovodstvo, 2-e yzd.

Current control: practical employments, laboratory employments , verbal questioning, two control works (totally 40 %);
Final control: (60%): examination in writing.