Contents

• Java
• Delphi
  • Question-answer
  • Practice
    • Delphi-7
    • Delphi-2010
• C#
  • Question-answer
  • Practical examples
  • Tasks solving
• C++
  • Question-answer
  • Practical examples
    • Borland C++ Builder
    • Microsoft Visual Studio
  • Tasks solving
• Databases

---

Java

• Data types
• Literals. Identifiers. Keywords. Comments
• Variables. Declaring variables. Initialization of variables
• Converting of types. Automatic type cast in expressions. Automatic advancement in expressions
• Arrays
  • 1. One-dimensional arrays
  • 2. Two-dimensional and multi-dimensional arrays
  • 3. Irregular arrays
• Operations
  • Arithmetic operations
  • Logical operations. Operations of relation. Bitwise logical operations
  • Assignment operation ‘=’. Ternary operation ?:. Priority of operations
  • Operations on objects. The operation of assigning object =. Object comparison operations ==, !=
• Strings
  • Strings. Part 1
  • Strings. Part 2
  • Arrays of strings. One-dimensional and two-dimensional arrays. Initialization. Examples
• Control operators (statements)
  • Conditional jump operator if
  • The selection operator ‘switch’. Nested ‘switch’ statements
  • The if-else-if statement
  • Loops for, while, do..while. Examples of use. Solving of tasks using loops
  • Extended for loop. General form. Examples. Processing arrays, collection of objects ArrayList, LinkedList
  • Operators break, continue. Examples of using
• Specifier final. Immutable (constant) data, methods, classes. Empty constants. Static immutable data. Inline methods
• Classes
  • 1. Classes and objects
    • 1.1. The use of classes in Java programs. Class and object definition. Examples
    • 1.2. Creating and saving the objects of classes. Areas of data storage in memory. Using an arrays of references to objects
    • 1.3. Scope of objects. Deleting objects. The advantages of using the “garbage collection” approach for objects
  • 2. Constructors
    • 2.1. Constructors. Parameterized constructors. The keyword ‘this’. Garbage collection. The finalize() method. Examples
    • 2.2. Default constructor. Calling class constructors from others constructors
  • 3. Initialization in classes
    • 3.1. Initialize variables in class methods. Initialization of data members of the class
    • 3.2. Initialization of static data members. Static block. Arrays initialization 
  • 4. Class methods
    • 4.1. The concept of the method. General form. Method parameters. Returning from method. Operator return. Return an object from a method. Examples of methods
    • 4.2. Methods. Passing parameters into methods of the class. Passing the primitive data types variables into a method as a parameter
    • 4.3. Overloading of methods in classes. Overloading of constructors
    • 4.4. Variable length arguments in methods
    • 4.5. Recursion
      • 4.5.1. Recursion. Examples of tasks solving. Advantages and disadvantages of recursion
      • 4.5.2. Examples of tasks solving on recursion in Java programming language
  • 5. Using the keyword ‘static’. Static data members of the class. Static methods of the class
• Nested classes
  • 1. Nested classes and inner classes. Static nested classes. Example
  • 2. Creating the objects of nested static and non-static classes. Constructions .this, .new
  • 3. Examples of use of inner classes in conjunction with interfaces. Downward and upward conversion. The advantages of using upward conversion
• Inheritance in classes
  • Reusing code in Java. The concept of composition, inheritance, delegation. The keyword extends. Examples
  • Inheritance. Basic concepts. Base class and derived class. The keyword ‘extends’. Hiding data in derived classes. Access modifiers private, protected, public
• Encapsulation. Access control. Packages
  • Encapsulation in class. Access control in class. Modifiers private, protected, public
  • Packages. Using packages in Java. Directives import and package. Compiled modules (.java). Intermediate .class files. Project structure. Using standard Java libraries
  • Controlling access to classes in packages. Package level access to the class. Public class access level
• Abstract classes. Interfaces
  • Abstract classes. Abstract methods. Keyword abstract. Examples
  • Interfaces. Features of use in combination with classes. The advantages of using interfaces. Keywords interface, implements. Examples

---

Delphi

Question-Answer

• Basic constructions of Pascal language
• The branching structure. Conditional statement if
• Loops
• The operator of variant case
• Enumerated and interval data types
• Arrays
• Records

Practice

1. Delphi 7

• 001 – Creating a database tables with the help of Database Desktop utility
• 002 – Creating a crosstabs in Delphi

2. Embarcadero RAD Studio – 2010.

• 001 – Programming any event in Delphi 2010.
• 002 – Calculation of the area of circle and volume of a sphere.
• 003 – Creating a new project in Embracadero RAD Studio 2010 (Delphi 2010).
• 004 – New form creating and connecting it to main form of application.
• 005 – Development the Application “Shop”.
• 006 – Setting tab order for components at the form.
• 007 – Creating a main menu. Component TMainMenu.
• 008 – An example of connecting database Microsoft Access to application.
• 009 – An example of creating of calculating fields in component of type TDBGrid in Delphi.
• 010 – Delphi. An example of sorting in database using component TADOQuery.
• 011 – Delphi. Development an application which forms SQL-queries to the database table.
• 012 – An example of calculating of sum in the table Microsoft Access without using the SQL-query
• 013 – An example  of calculation of sum in the table of database Microsoft Access using a SQL-query. The component TDBText
• 014 – Developing the application of program of drawing the graph of the two variables function z=f(x, y)
• 015 – Demonstration of methods which operate data in the table of database Microsoft Access using a component TADOTable
• 016 – Controlling the displaying of the current time in the program. Example of demonstration of TTimer component.
• 017 – The problem of N Queens. Solution using Delphi

---

C#

Question-Answer

• The basic concepts of .NET Framework technology
• Base types in C#
• Literals
• Variables and constants. Initialization. Dynamical initialization. Implicitly typed variables
• Basic operators
• Priority table
• Control operators
  • The if statement. Full form. Shortened form. The if-else-if statement
  • The switch statement
  • The while loop operator. Examples
  • The for loop operator. Examples
• Arrays
  • 1. One-dimensional arrays. Examples of solving problems on one-dimensional arrays. Arrays of structures. Arrays of classes. Arrays initialization
  • 2. Multidimensional arrays. Stepped arrays. Initialization of multidimensional arrays
  • 3. References to arrays. The Length property. Assignment of arrays
  • 4. Implicitly typed arrays. The var keyword
• Type string
• Indexers. One-dimensional and multidimensional indexers. Indexers without basic array. Overloading indexers
• Interfaces. The use of interfaces in C# programs
• Structures
  • 1. Structures. General concepts. Type of structure. Structural variable. Modifiers of access to structured variables. Examples of using the structures
  • 2. Structures and methods. Initialization of structures. Constructors in structures. Properties in structures
  • 3. Using arrays in structures. Arrays of structures. Nested structures. Copying structures
• Enumerations
• Classes
  • 1. Classes. Class definition. Object of class. Keyword this
  • 2. Special class functions
    • 2.1. Initialization of class data. Constructor. Constructor by default
    • 2.2. Destructor. “Garbage collection”
  • 3. Dynamic memory allocation. Operator ‘new’. Memory allocation for value types, structures, enumerations, objects of classes. Memory allocation for arrays
  • 4. Methods in classes
    • 4.1. The concept of the method. Examples of methods in classes. Return from method. The return statement. Methods without parameters. The void keyword
    • 4.2. Passing parameters to methods
      • 4.2.1. Passing parameters to a method. Arguments and formal parameters. Examples. Passing a reference to object of class into a method
      • 4.2.2. Modifiers ref and out. Examples. Differences between ref and out modifiers
      • 4.2.3. Variable numbers of arguments in methods. Modifier params. Advantages. Examples of methods with variable number of arguments
      • 4.2.4. Passing arrays to methods. Examples. Passing arrays of structures, classes, enumerations to methods. Passing two-dimensional arrays. Returning the array from method
      • 4.2.5. Optional arguments. Advantages. Examples of using optional arguments. Ambiguity when using optional arguments
      • 4.2.6. Named arguments. Advantages. Examples
    • 4.3. Overloading of methods in classes. Examples. Advantages. Overloading of constructors
    • 4.4. Recursion. Examples of recursive methods
  • 5. Static classes, methods, variables. Static constructors. Keyword static
  • 6. Nested classes. Nested static classes. Declaring and using nested classes. Examples
• Delegates
  • 1. The concept of delegate. Declaration of delegate type. Using a delegate in the program. Group transformation of methods
  • 2. Using delegates that reference the instance methods of the class. Example
  • 3. Delegates. Group addressing. Creating a chain of methods calling
  • 4. Anonymous functions. Anonymous methods. Returning the value. Passing parameters
  • 5. Examples of passing arrays, structures, classes to an anonymous method
• Lambda expressions
  • General concepts of lambda expressions. Lambda operator. Single and block lambda expressions
  • Examples of lambda expressions that receive as a parameter an arrays, structures, classes
• Events
  • Events and delegates. The concept of event. Interaction between events. Examples of using
  • Examples of using an anonymous method and a lambda expression as an event. Event handlers that are used in .NET environment
• Reflection
  • 1. Run-time type information (RTTI). Statements is, as. Examples
  • 2. Reflection of types. Getting type metadata. The System.Reflection namespace. Class System.Type. Ways to get information about types. Operator typeof
  • 3. Examples of obtaining information about methods, interfaces, classes, structures, enumerations, delegates, type fields, method parameters, type statistics
  • 4. Dynamically loadable assemblies. Class Assembly. Methods Load() and LoadFrom()
  • 5. Late binding. Method call. Example. Class System.Activator. Method Invoke()
• Collections
  • General concepts about collections
  • The ArrayList class
• Controls (Windows Forms Application)
  • DataGridView

Practice

• Microsoft Visual Studio 2017
  • Console App (.NET Framework) template
    • 001 – Example of creating a Unit-test in MS Visual Studio 2017
• Microsoft Visual Studio 2010
  • Windows Forms Application template
    • 001 – Windows Forms type Application Development in MS Visual Studio 2010.
    • 002 – How to show MS Access database table in dataGridView.
    • 003 – Connecting to MS Access Database in Visual Studio 2010.
    • 004 – How to convert a MS Access database into MS SQL Server format.
    • 005 – Example of event programming of button click in C#. Development of a program to determine the surface area of the sphere.
    • 006 – Example of creating and calling a new form in C# application
      
    • 007 – An example of creating of Web-application in MS Visual Studio.
    • 008 – An example of creating a menu in C#. Control menuStrip.
    • 009 – C# (term paper). Development of Automation Program of work of Manager.
    • 010 – C#. An example of demo application of copying files. Class FileStream.
    • 011 – C# – An example of creating of two-dimensional matrix on the form. The analogue of TStringGrid component in Delphi.
    • 012 – C# – Developing the application of reading and writing text files. Classes StreamReader and StreamWriter.
    • 013 – Developing the application of program of drawing the graph of the two variables function z = f(x,y).
    • 014 – An example of demo application which manipulates data in the table of database MS SQL Server (SQLEXPRESS).
    • 015 – Controlling the displaying the current time in the program. Example of demonstration of Timer component.
    • 016 – Example of the development of application, that demonstrates work with lists and associative arrays. Classes Dictionary, List, StreamReader.
    • 017 – The implementation of the concepts of “inheritance” and “polymorphism” in the object-oriented programming through the creation of two classes. The interfaces ICloneable and IEquatable.
    • 018 – Developing the program of demonstration of the queries at the LINQ language.
    • 019 – C# + Databases. An example of creating a report in application  created using Windows Forms Application template for a database of the Microsoft SQL Server type, which is located in the *.mdf-file
    • 020 – Term paper. Development of an environmental pollution monitoring program
    • 021 – An example of solving a task that calculates the characteristics of geometric figures using delegates
    • 022 – An example of using a delegate to call an anonymous method. The development of the program for finding the area of a triangle using the Heron’s formula
    • 023 – An example of creating a report in application. The Report Viewer control. The Microsoft Access database
    • 024 – Demonstration of the operation of the DataGridView control
    • 025 – Course work. Development of a program for accounting  of material assets. The Microsoft Access database
    • 026 – Example of creating a Unit-test in Microsoft Visual Studio 2010
    • 028 – Solving the problem of placing N queens on the board
  • WPF Application template
    • An example of creating a new application that supports WPF (Windows Presentation Foundation). Overview of the main project files
  • ASP .NET Web Application template
    • An example of creating of Web-application in MS Visual Studio
  • Distributed applications
    • 027 – An example of a distributed application that demonstrates remote interaction between computers on a network. Namespace System.Runtime.Remoting

Solving of tasks

• One-dimensional arrays. Loops for, while, do..while
• One-dimensional arrays. Combining the loops operators for, while, do…while with the condition operator if
• Recursion. Examples of tasks solving

---

C++

Question-Answer

• Base types in C++ (Visual C++)
• Identifiers, reserved words, literals, escape sequences
• The concept of variable. Declaration of variable. Memory allocation for variables. Constants
• The concept of expression. Assignment operation. Converting and casting of types
• Operations, basic operators
  • Arithmetic operations
  • Operations of relations
  • Logical operations. Bitwise logical operations. Shift operations
  • Operators of increment (++) and decrement (—). The complex assignment operators
  • The operation sizeof. The ternary operation ? :
  • The operation priority table in C++
• Control operators
  • Conditional jump operator ‘if’
  • Operator ‘switch’
  • Cycles. Operators of the cycle for, while, do…while
• Arrays
  • 1. Array definition. One-dimensional arrays. Initializing array
  • 2. Two-dimensional arrays. Arrays of strings. Multidimensional arrays
  • 3. Examples of solving the most common problems with one-dimensional arrays
  • 4. Examples of solving tasks using character strings
• Pointers
  • 1. General concepts. Pointer types. Managed and unmanaged pointers. Pointers to a function. Examples of the use of pointers
  • 2. Unmanaged pointers. Operation on pointers. Pointer to type void. Memory allocation. A null pointer. The operation of getting the address &
  • 3. Unmanaged pointers and arrays. Pointer to structure. Pointer to class
  • 4. Pointers and strings. Using pointers when converting strings (char, string, wchar_t, System::String)
  • 5. Memory allocation for the pointer. Arrays of pointers to basic types, functions, structures, classes
  • 6. Composite managed and native data types. Managed pointers (^) in CLR. Memory allocation. The ref and value qualifiers. Managed pointers to structures and classes
• References. Basic concepts. References to variables, structures, unions and class objects. Differences between references and pointers. Examples
• Functions
  • 1. Function declaration. Actual and formal parameters (arguments). Passing arguments to a function by value and by reference. Function prototype
  • 2. Functions and arrays. Passing a one-dimensional and multidimensional array to a function. Passing a structure and a class to a function
  • 3. Default arguments in functions
  • 4. Overloaded functions. Overloaded functions in classes. Overloading of class constructors. Access to the overloaded function using a pointer. Examples
  • 5. Passing a constant parameters to a function. The return of constant from function
  • 6. Generalization in functions. Template function. Keywords template, typename, class. Explicit specialization of template function. Overloading of template function
  • 7. Recursion. Examples of tasks solving. Advantages and disadvantages of recursion
• Structures
  • 1. Composite data types. The template of structure. Structural variable. Structures in the CLR. Declaring and initializing a structured variable
  • 2. Memory allocation for the structure. Nested structures. Arrays of native structures
  • 3. Working with managed-structures in CLR. Qualifiers ref and value. Declaring structural variables. Arrays of managed-structured variables. Initializing of managed-structures
  • 4. Structures and functions. Passing a structure to a function in the CLR. Returning a structure from a function
• Unions. The keyword ‘union’. Examples of declaring and using unions
• Dynamic and static allocation of memory
  • Dynamic and static allocation of memory. Advantages and disadvantages. Allocating memory for single variables by the operators new and delete. Initialization when allocating memory
  • Memory allocation for structural variables, class objects, arrays. Initialization of allocated memory. Reallocation of memory. Examples 
• Classes
  • 1. The concept of class. Class declaration. The object of the class. Classes in the CLR. Data encapsulation in the class
  • 2. Special functions in classes
    • 2.1. Class constructor. Features of use constructors in the classes. The default constructor. Parameterized constructor. Examples of calsses that contain constructors
    • 2.2. Copy constructor. Examples of using. Passing a class object to a function. Returning a class from a function
    • 2.3. Destructor. Definition of the destructor. Public and private destructos. Examples of destructors using. Differences between constructors and destructors
  • 3. Members of the class data
    • 3.1. Using the class data members. Static data members in the class. Static data members for native-classes and managed-classes
    • 3.2. Class objects as members of the class data. Examples
    • 3.3. References to the class object. Access to a class object by reference. References as members of class data. Examples
  • 4. Functions-members of class
    • 4.1. Types of functions of class members. Ordinary member functions. Static member functions. Examples
    • 4.2. Constant member functions. Member functions ‘volatile’
    • 4.3. Class functions that are declared with a constant (const) ‘this’ pointer and a volatile ‘this’ pointer
    • 4.4. Inline member functions of class. The inline keyword
  • 5. Classes of memory that can be declared when working with classes and class objects. Keywords register, extern, static, mutable
  • 6. Managed and unmanaged classes in Visual C++. Overview. Example of implementing managed and unmanaged classes
  • 7. “Friends” of the class. “Friendly” classes and functions. The keyword ‘friend’. Examples
  • 8. Class template. The ‘template’ keyword. Advantages of using templates. Arguments in templates. Examples
  • 9. Arrays in classes
    • 9.1. Arrays of objects in managed and unmanaged classes. Examples. Array of unmanaged pointers to a class
    • 9.2. Initializing arrays with data values from class objects. Examples
    • 9.3. Arrays of pointers to the class members methods. Examples
    • 9.4. A pointer to a static member of a class data. Arrays of static data members. Arrays of pointers to a static data members of class. Examples
• Working with strings
  • The string class. Class constructors. Examples
  • Class System::String
• Operator overloading
  • 1. Operator overloading in C++. Operator function. Keyword operator. Overload of basic arithmetic operators +, –, *, /. Examples of the implementation of built-in operator functions
  • 2. “Friendly” operator functions: differences, implementation. Overload of operators +, –, *, / with the help of friendly operator functions
  • 3. Overloading increment and decrement operators ++, – –. Examples
  • 4. Overloading of shortened assignment operators +=, -=, *=, /=, %=. Examples
  • 5. Overloading operators new and delete. Examples
  • 6. Overloading the assignment operator =. Examples

Practice

1. Borland C++ Builder 2007.

• 001 – Creating a Windows application in C++ Builder.
• 002 – How to sort data in the database table.
• 003 – Generating report of RaveReport type based on Microsoft Access table in Borland C++ Builder.
• 004 – Connecting the database to the Windows-based application.
• 005 – An example of displaying the table of database in component TDBGrid – C++ Builder.
• 006 – An example of event programming in C++ Builder.
• 007 – An example of application development of calculating of cylinder volume in C++ Builder.
• 008 – C++ Builder. An example of creating and calling a new form from main form of application.
• 011 – C++ Builder. Developing the application of solution of the system of linear algebraic equations by Gauss.
• 012  –  Development  of program of graphics drawing functions of one variable. The function is defined by the formula.

2. Microsoft Visual Studio 2010.

• 001 – Creating a simple dialog application Windows of type Dialog Based Application by using MFC library.
• 002 – An example of creation of dialog window in MS Visual Studio 2010 – C++ (MFC Application).
• 003 – Creating an application of Windows Forms Application type in MS Visual Studio – C++. Review of main files of project.
• 004 – An example of developing the simply application of Windows Forms Type in C++ by using MS Visual Studio.
• 005 – Example of application development of mathematical expressions with interception of possible exceptions. Using the “try…throw…catch” instruction
• 006 – Development of the program for problem solving use the operator conditional jump if.  Overview the main properties of the form
• 007 – Development the program where to solve the problem is used “switch” statement
• 008 – Demonstration of use “for” loop in program. Example of calculating the sum of series
• 009 – Development of a program for calculating the sum of negative elements of array. Demonstration of using methods and properties of DataGridView control
• 010 – Development of a program for calculating an expression implemented by a single function. The PictureBox control
• 011 – Example of Unit-test creating in Microsoft Visual Studio – C++
• 012 – Solution of the problem of placing N queens on a chessboard

Solving of tasks

• One-dimensional arrays. Loops for, while, do…while
• One-dimensional arrays. Combining the loops operators for, while, do..while with the condition operator if
• Recursion. Examples of task solving on recursion in C++

---

Databases

• Theory
  • Basic concepts
    • General information about databases. History of the development of Database Management Systems (DBMS)
    • Functions of Database Management Systems (DBMS)
    • The concept of a database system. Database schema. Data. Hardware and software. Database users
    • Persistent data. Transient data
    • The Entity-Relationship model (ER-model)
      • The concept of ER-model. The concept of entity. Attributes. Attribute type
      • Entity subtypes. Supertype. Example. Advantages and disadvantages of using subtypes of entities
      • ER-model. The concept of relationship. The relationship capacity. Types of relationships. Examples
  • Relational data model
    • Basic concepts of the relational data model
    • Relational databases. The concept of a key. Types of keys. Relations. Master table and detail table
• Practice
  • Working with the Microsoft SQL Server database server in Microsoft Visual Studio
    • 001 – An Example of creating the local Microsoft SQL Server (SQLEXPRESS) database in Microsoft Visual Studio
  • The databases of Microsoft SQL Server, which are located in the “*.mdf” files
    • 001 – An example of creating/connecting local Microsoft SQL Server database located in the “*.mdf” file
    • 002 – An example of creating a table in the local Microsoft SQL Server database located in the “*.mdf” file
    • 003 – Creating an autoincrement field (counter) in the MS SQL Server database table, which is located in the “*.mdf” file
    • 004 – Creating a “one-to-many” relationship between tables in Microsoft SQL Server database
    • 005 – An example of creating the “*.mdf” file of local database Microsoft SQL Server in MS Visual Studio
    • 006 – The “Connection String” string of connection with database. An example of using in applications
    • 007 – An example of creating a query in the database
    • 008 – An example of creating a view in a database. Creating a calculated field
  • The Microsoft Access databases
    • Creating a database in Microsoft Access 2016. Creating a table with calculation field