Course title ECTS Credits Semester Annotation
Databases 6 Spring The aim of the databases course are to provide the basics of database design, methods of conceptual design, work with database management systems, principles of relational database design, ways and methods of database application in business.

Students are introduced to the main database (DB) concepts, their development and use principles. The focus is on the relational data processing. The course also provides knowledge on database management systems (DBMS), their purpose, the main functions and components; overviews various DB consumer opportunities, tools of application programs development, query language SQL, etc. During the workshops, students master one of the most popular DBMS – SQL.
Course content:

  1. Basic concepts of database systems
  2. DB and DBMS conception, purpose and functions
  3. Main concepts of relational database model
  4. Principles of database design
  5. Database normalization
  6. Creation of a database in SQL.
  7. Data selection methods, their application in database systems
  8. Forms of data input
  9. Ensuring of data integrity
  10. Basics of the SQL query language and its application in databases.
  11. Complex structures in queries.
Object- Oriented Programming 6 Spring The goals of the Object-Oriented Programming are to provide the knowledge and practical skills of object-oriented programming in Java language necessary for working with a variety of data and creating applications; to apply basic data structures, static and dynamic variables, to create data structures and classes and use them in problem solving programs.
The course introduces students to the programming terminology; discusses the significance of programming; explains the principles of programming culture, programming language syntax and rules, stages of application development; provides the requirements for program documentation. The course aims to teach students to create applications that perform operations with multiple sets of data, use conditional statements, loops, functions, objects and their methods; to form the system of object-oriented programming knowledge, abilities and skills which is necessary for a student to master the selected program of studies and to satisfy the real-life needs. The acquired knowledge can be applied in practice by identifying the tasks, creating their algorithms and recording the algorithms by corresponding programs.
Course content:

  1. Operators, methods, packages.
  2. Constants, variables, and operators.
  3. Conditionals in Java programming. If Else Statement, Nested If Else, Java Switch Statement, Java Ternary Operation.
  4. Java Methods: Predefined Methods, User-defined Methods.
  5. Loops in Java programming. For Loop, While Loop, Do While Loop, Break and Continue.
  6. Reference type in Java Programming. Reference types, String class, Java wrapper class, Java Dates.
  7. Arrays and ArrayLists. Arrays, arrays of objects, primitive data types. Variable arguments, String arrays. Problem with arrays.
  8. Terminology – Class, Object. Understanding basics of Encapsulation with Setter methods. Getters and Generating Getters and Setters. Abstraction. Constructors.
  9. Class, Object, State and Behavior. Object Composition. Inheritance. Object is at top of Inheritance. Inheritance and Overriding – with toString() method. Java Abstract. Java. Polymorphism.

Collections in Java Programming. Set Interface. List and ArrayList. Data Structures – Array, LinkedList and Hashing
Programming PHP 6 Spring The goal of the course is to provide skills of programming by using PHP language in creation of online systems of different complexity that use databases.
The course aims at training to use theoretical knowledge and practical skills for creation of websites and online information systems. The course introduces PHP language and its application for creation of websites and online systems. It also introduces the database control system MySQL which is widely used in online information systems and PHP scripts.
Course content:

  1. Basics of PHP language
  2. Work with forms
  3. Work with file systems and arrays
  4. Introduction of objects
  5. Using cookies and sessions
  6. Work with MySQL databases
Applied Programming 6 Spring The goal of the course is to provide practical programming skills in Java programming language, creating applications and information systems of various complexity.
The course trains to apply theoretical knowledge and practical skills for programming in JAVA language. It introduces object oriented programming, data structures and creation of interactive user‘s environment. The main attention is paid to strong bases of programming, data structures, algorithm programming. The course reveals basic principles of designing information systems and programming for mobile devices, the students learn to create user‘s databases and administrate their users.