The course "Databases" is at the heart of information technology. It aims to familiarize future professionals with the theory and practice of databases. Discussed are the physical and logical foundations of databases. The relational data model is subject to in-depth study. The properties of relational information structures, methods for their analysis and synthesis (design) are given. Other approaches are also included in building databases such as Object, NoSQL, and others. Data access languages and description of conceptual schema databases are considered. Here the basic standard is the SQL standard. Learning methods for database programming such as PL/SQL are studied. The structure of information systems built on different databases is given. A link has been made between databases, information systems and information technology. The basics of complex information environments are also introduced.The course includes programming systems with databases based on PL/SQL - structure of language data types and control structures and focuses on specific databases objects such as cursors, functions, procedures, packages, triggers and more.
Main issues of the syllabus content:
- Data bases - models, relational model.
- Design of relational databases, normalization
- SQL language – DDL, DML, TCL, DCL
- Database programming - PL / SQL
- Other types of databases - (ORDB, NoSQL, OLAP) and systems (CRM, ERP, SCM)