Contents

• Java
• Pascal/Delphi
  • Pascal. Theory
  • Delphi. Practice
    • Delphi-7
    • Delphi-2010
• C#
  • Theory
  • Practice
  • Tasks solving
• C++
  • Theory
  • Practice
    • Borland C++ Builder
    • Microsoft Visual Studio 2010-2019
  • Tasks solving
• Databases

---

Java

Theory

• I. Basic course Java

  • 1. Java. General concepts
  • 2. Data types. Literals. Keywords. Variables
    • 2.1. Data types. Primitive data types. Wrapper types
    • 2.2. Literals. Identifiers. Keywords. Comments
    • 2.3. Variables. Declaring variables. Initialization of variables
    • 2.4. Converting of types. Automatic type cast in expressions. Automatic advancement in expressions
  • 3. Operations
    • 3.1. Arithmetic operations
    • 3.2. Logical operations. Operation of relation. Bitwise logical operations
    • 3.3. Assignment operation ‘=’. Ternary operation ?:. Priority of operations
    • 3.4. Operations on objects. The operation of assigning object =. Object comparison operations ==, !=
  • 4. Control operators (statements)
    • 4.1. Conditional jump operator if
    • 4.2. The selection operator ‘switch’. Nested ‘switch’ statements
    • 4.3. The if-else-if statement
    • 4.4. Loops for, while, do..while. Examples of use. Solving of tasks using loops
    • 4.5. Extended for loop. General form. Examples. Processing arrays, collection of objects ArrayList, LinkedList
    • 4.6. Operators break, continue. Examples of using
  • 5. Arrays
    • 5.1. One-dimensional arrays
    • 5.2. Two-dimensional and multi-dimensional arrays
    • 5.3. Irregular arrays
  • 6. Strings
    • 6.1. Strings. Part 1
    • 6.2. Strings. Part 2
    • 6.3. Arrays of strings. One-dimensional and two-dimensional arrays. Initialization. Examples
  • 7. Classes. Methods in classes
    • 7.1. Classes and objects
      • 7.1.1. The use of classes in Java programs. Class and object definition. Examples
      • 7.1.2. Creating and saving the objects of classes. Areas of data storage in memory. Using an arrays of references to objects
      • 7.1.3. Scope of objects. Deleting objects. The advantages of using the “garbage collection” approach for objects
    • 7.2. Constructors
      • 7.2.1. Constructors. Parameterized constructors. The keyword ‘this’. Garbage collection. The finalize() method. Examples
      • 7.2.2. Default constructor. Calling class constructors from others constructors
    • 7.3. Initialization in classes
      • 7.3.1. Initialize variables in class methods. Initialization of data members of the class
      • 7.3.2. Initialization of static data members. Static block. Arrays initialization 
    • 7.4. Class methods
      • 7.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
      • 7.4.2. Methods. Passing parameters into methods of the class. Passing the primitive data types variables into a method as a parameter
      • 7.4.3. Overloading of methods in classes. Overloading of constructors
      • 7.4.4. Variable length arguments in methods
      • 7.4.5. Recursion
        • 1. Recursion. Examples of tasks solving. Advantages and disadvantages of recursion
        • 2. Examples of tasks solving on recursion in Java programming language
    • 7.5. Using the keyword ‘static’. Static data members of the class. Static methods of the class
    • 7.6. Specifier final. Immutable (constant) data, methods, classes. Empty constants. Static immutable data. Inline methods
  • 8. Nested classes
    • 8.1. Nested classes and inner classes. Static nested classes. Example
    • 8.2. Creating the objects of nested static and non-static classes. Constructions .this, .new
    • 8.3. Examples of use of inner classes in conjunction with interfaces. Downward and upward conversion. The advantages of using upward conversion
  • 9. Encapsulation. Access control. Packages
    • 9.1. Encapsulation in class. Access control in class. Modifiers private, protected, public
    • 9.2. Packages. Using packages in Java. Directives import and package. Compiled modules (.java). Intermediate .class files. Project structure. Using standard Java libraries
    • 9.3. Controlling access to classes in packages. Package level access to the class. Public class access level
  • 10. Inheritance in classes. Polymorphism
    • 10.1. Reusing code in Java. The concept of composition, inheritance, delegation. The keyword extends. Examples
    • 10.2. Inheritance. Basic concepts. Superclass and subclass. The keyword ‘extends’. Hiding data in derived classes. Access modifiers private, protected, public
    • 10.3. Inheritance. A reference to a subclass object. Calling the superclass constructor. The keyword super
    • 10.4. Overriding and overloading inherited methods. Examples. Dynamic dispatch of methods. Polymorphism
  • 11. Abstract classes. Interfaces
    • 11.1. Abstract classes. Abstract methods. Keyword abstract. Examples
    • 11.2. Interfaces. Features of use in combination with classes. The advantages of using interfaces. Keywords interface, implements. Examples
  • 12. Exceptions
    • 12.1. Exceptions. Keywords try, catch, finally. Examples
    • 12.2. Operators throw, throws. Examples
    • 12.3. Java classes for handling exceptions from the java.lang package. Methods of Throwable class. Examples
    • 12.4. Class Exception. Create custom exception classes. Examples
  • 13. Enumerations. Autoboxing. Annotations
    • 13.1. Enumerations. Keyword enum. Examples
    • 13.2. Using enums as classes. Examples of declaring enumerations containing constructors, internal fields, methods
    • 13.3. Autoboxing and unboxing. General concepts. Using in assignment (=) and in methods. Examples
    • 13.4. Autoboxing and unboxing in expressions and the switch statement. Using autoboxing and unboxing values for boolean and char types
  • 14. I/O System in Java. Working with files
    • 14.1. Java I/O system. Streams. Byte streams. Character streams. Standard streams
    • 14.2. Work with the console. Classes InputStreamReader, PrintStream. Creating an input/output stream associated with the console. Redirecting input/output streams
    • 14.3. Work with files in Java. Class File. Basic working methods
    • 14.4. Byte streams. Classes DataInputStream, DataOutputStream, FileInputStream, FileOutputStream. Examples of using
    • 14.5. Examples of implementation of operations that modify text files. Classes FileReader, FileOutputStream, PrintStream
    • 14.6. Automatic file closure. The statement try with resources. Examples
    • 14.7. Serialization of objects. The transient keyword. Examples
  • 15. Generalizations
    • 15.1. Generalizations. Parameterized types. Generic classes, interfaces, methods
    • 15.2. Ensuring type safety by using generalizations. Generalized interfaces. Examples
    • 15.3. Limited types. Metacharacter arguments. Examples
  • 16. Additional Java features
    • 16.1. The instanceof operator. Determining the type of object. Examples
  • 17. Lambda expressions. Functional interface. Method references
    • 17.1. Lambda expressions. Basic concepts. Functional interface. Examples
    • 17.2. Lambda expressions for generic functional interfaces. Examples
    • 17.3. Passing a lambda-expression to a method as a parameter. Examples
    • 17.4. Throwing exceptions in lambda expressions. Examples
    • 17.5. Accessing class members from a lambda expression. Capturing variables in lambda expressions. Examples
    • 17.6. Types of method references. Reference to static method. Reference to instance method
    • 17.7. Reference to the class constructor
    • 17.8. Standard (predefined) functional interfaces of Java language
  • 18. Data streams. Stream API
    • 18.1. Data streams. Stream API. General information
    • 18.2. The concept of final and intermediate operations. Examples. Methods stream(), parallelStream()
    • 18.3. The BaseStream interface. Examples of using interface methods
    • 18.4. Interface Stream<T>. Intermediate interface methods: filter(), map(), mapToDouble(), mapToInt(), mapToLong(), sorted(). Examples
    • 18.5. Interface Stream<T>. Final methods collect(), count(), forEach(), max(), min(), reduce(), toArray()
  • 19. Threads
    • 19.1. Multitasking. Threads of execution. Basic concepts
    • 19.2. Java language tools for working with threads of execution. Thread class. Runnable interface. Main thread of execution. Creating a child thread
    • 19.3. Methods of the Thread class: getName(), start(), run(), sleep(). Examples
    • 19.4. Methods of the Thread class: join(), isAlive(), getPriority(), setPriority(). Examples
    • 19.5. Synchronization. Monitor. General concepts. The synchronized keyword
    • 19.6. Interaction between threads. Methods wait(), notify(), notifyAll(). Examples
    • 19.7. The state of the thread of execution. The getState() method. Example

• II. Java library

  • 1. The java.lang package
    • 1.1. The java.lang package. General information. Overview of classes and interfaces
    • 1.2. Methods of java.lang package
      • 1.2.5. Class Character
        • 1.2.5.1. Class Character. Review of methods and constants. Class constructor
        • 1.2.5.2. Class methods determine whether a symbol belongs to a given category. Methods isDigit(), isIdentifierIgnorable(), isLowerCase(), isSpace(), isUpperCase(), isWhiteSpace()
      • 1.2.11. Class Enum. Methods: clone(), compareTo(), getDeclaringClass(), hashCode(), name(), ordinal(), toString()
  • 2. The java.util package
    • 2.1. Java Collection Framework
      • 2.1.1. Introduction to Java Collection Framework
      • 2.1.2. Class ArrayList
        • 2.1.2.1. Class ArrayList. Dynamic array. General information. Creating an array
        • 2.1.2.2. Methods that change data in the array. Methods add(), addAll(), clear(), remove(), removeAll(), removeIf(), replaceAll(), set(), sort()
        • 2.1.2.3. Methods that define information about array elements. Methods get(), contains(), containsAll(), indexOf(), lastIndexOf(), iterator(), listIterator()
        • 2.1.2.4. Methods that determine general characteristics of the array. Methods ensureCapacity(), isEmpty(), size(), trimToSize()
        • 2.1.2.5. Methods that transform the array as whole. Methods clone(), sublist(), toArray(), retainAll()

Practice

• 1. Developing classes
  • 1.1. Developing a generic class that contains tools for implementing linear search
  • 1.2. Developing a generic class that implements the selection sorting algorithm
• 2. Stream API
  • 2.1. Examples of solving tasks on data streams
  • 2.2. Examples of solving tasks on data streams, which are objects of the developed classes
• 3. Solving tasks. Examples
  • Examples of solving tasks on threads of execution (Threads). Working with files in streams. Sorting in streams
• 4. JUnit
  • JUnit testing. Examples

---

Pascal/Delphi

Pascal. Theory

• I. Structural programming. Basic course
  • 1. Development of programs on the PC. Algorithms
    • 1.1. Development of programs on the PC. Stage of preparing a program on a PC. Compilers and Interpreters
    • 1.2. The concept of algorithm. Ways to write algorithms. Classification of algorithms by structure. Algorithm properties
    • 1.3. Principles of structured programming. Modular software development
    • 1.4. Algorithmic language. The composition of algorithmic language. Description of the language
  • 2. Basic concepts of the Pascal language. Data types. Variables, constants
    • 2.1. The structure of Pascal program
      • 2.1.1. The structure of Pascal program in Delphi and Lazarus programming systems. Console application
      • 2.1.2. The application of VCL Forms Application in Delphi. The Application project in Lazarus
    • 2.2. Data types. Standard data types
      • 2.2.1. Standard data types. Integer types. Ordinal types. Functions Ord, Pred, Succ. Function SizeOf
      • 2.2.2. Boolean types. Character types. String types
      • 2.2.3. Pointer types Pointer, ^. Text type
    • 2.3. User-defined data types
      • 2.3.1. Enumerated and interval data types
  • 3. Basic syntactic constructions of the Pascal language
    • 3.1. Basic constructions of Pascal language
    • 3.2. Computing Process Control Operators
      • 3.2.1. The branching structure. Conditional statement if
      • 3.2.2. Loops. Loop operators for, while-do, repeat-until. Operators break, continue
      • 3.2.6. The operator of variant case
    • 3.4. Arrays
    • 3.5. Character strings. The String type
      • 3.5.1. Strings of characters of type String. Operations on character strings
      • 3.5.2. Functions for working with character strings. Functions Concat, Copy, Delete, Insert, Length, Pos, Val, Str
    • 3.6. Records

Delphi. 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#

Theory

• 1. C#. Overview
  • 1.1. The history of emergence the C# programming language and Microsoft .NET technology
  • 1.2. The basic concepts of .NET Framework technology
  • 1.3. Metadata of types. Purpose and features of use. The need for metadata. Ways to get type information
• 2. C#. Basic units. Elements of the language. Data types. Keywords. Literals
  • 2.1. Keywords in C#. Reserved words. Context words
  • 2.2. Categories of data in C#. Value types. Reference types
  • 2.3. Base types in C#
  • 2.4. Literals
  • 2.5. Variables and constants. Initialization. Dynamical initialization. Implicitly typed variables
  • 2.6. Type string
  • 2.7. Data type char. Structure System.Char. Methods
  • 2.8. The value of null. Nullable data types. Operations ?, ??
• 3. Operations
  • 3.1. Basic operations
  • 3.2. Priority table
  • 3.3. Ternary operator ?:
• 4. Control operators
  • 4.1. The if statement. Full form. Shortened form. The if-else-if statement
  • 4.2. The switch statement. Nested switch statements
  • 4.3. The while loop operator. Examples
  • 4.4. The for loop operator. Examples
  • 4.5. The do-while loop. Examples
  • 4.6. The foreach loop. Examples
  • 4.7. Statements break, continue, goto
• 5. Arrays
  • 5.1. One-dimensional arrays. Examples of solving problems on one-dimensional arrays. Arrays of structures. Arrays of classes. Arrays initialization
  • 5.2. Multidimensional arrays. Stepped arrays. Initialization of multidimensional arrays
  • 5.3. References to arrays. The Length property. Assignment of arrays
  • 5.4. Implicitly typed arrays. The var keyword
  • 5.5. Arrays of strings. Examples of solving the most common tasks 
• 6. Structures. Enumerations
  • 6.1. Structures. General concepts. Type of structure. Structural variable. Modifiers of access to structured variables. Examples of using the structures
  • 6.2. Structures and methods. Initialization of structures. Constructors in structures. Properties in structures
  • 6.3. Using arrays in structures. Arrays of structures. Nested structures. Copying structures
  • 6.4. Enumerations
• 7. Indexers. Properties
  • 7.1. Indexers. One-dimensional and multidimensional indexers. Indexers without basic array. Overloading indexers
  • 7.2. Properties. Accessors get, set. Examples of classes containing properties
• 8. Interfaces. The use of interfaces in C# programs
• 9. Classes
  • 9.1. General concepts. Objects. The data and methods of the class 
    • 9.1.1. Classes. Class definition. Object of class. Keyword this
    • 9.1.2. Constant fields in classes. Keywords readonly, const
    • 9.1.3. Keyword this. Cases of using this in classes. Examples
    • 9.1.4. Initialization data in classes. Ways to initialize data in the class. The object initializer
  • 9.2. Special class functions
    • 9.2.1. Initialization of class data. Constructor. Constructor by default
    • 9.2.2. Destructor. “Garbage collection”
  • 9.3. Dynamic memory allocation. Operator ‘new’. Memory allocation for value types, structures, enumerations, objects of classes. Memory allocation for arrays
  • 9.4. Methods in classes
    • 9.4.1. The concept of the method. Examples of methods in classes. Return from method. The return statement. Methods without parameters. The void keyword
    • 9.4.2. Passing parameters to methods
      • 1. Passing parameters to a method. Arguments and formal parameters. Examples. Passing a reference to object of class into a method
      • 2. Modifiers ref and out. Examples. Differences between ref and out modifiers
      • 3. Variable numbers of arguments in methods. Modifier params. Advantages. Examples of methods with variable number of arguments
      • 4. Passing arrays to methods by value. Examples. Passing arrays of structures, classes, enumerations to methods. Passing two-dimensional arrays. Returning the array from method
      • 5. Passing in the method one-dimensional and multidimensional arrays of class instances as ref and out parameters
      • 6. Optional arguments. Advantages. Examples of using optional arguments. Ambiguity when using optional arguments
      • 7. Named arguments. Advantages. Examples
    • 9.4.3. Overloading of methods in classes. Examples. Advantages. Overloading of constructors
    • 9.4.4. Recursion. Examples of recursive methods
    • 9.4.5. Function Main(). Ways of declaration. Passing arguments to Main()
  • 9.5. Encapsulation in classes. Keywords private, protected, public, internal
  • 9.6. Static classes, methods, variables. Static constructors. Keyword static
  • 9.7. Nested classes. Nested static classes. Declaring and using nested classes. Examples
• 10. Relationship between classes
  • 10.1. Types of relationship between classes: is-a, has-a, uses. Examples. Aggregation. Composition
  • 10.2. The relationship between classes of type uses (the class uses another class). Examples
• 11. Inheritance. Polymorphism. Abstract classes
  • 11.1. Inheritance. Basic concepts. Advantages and disadvantages. General form. The simplest examples. Access modifier protected
  • 11.2. Using constructors in classes for inheritance. The base keyword. Examples
  • 11.3. Access to elements of a base class from an inherited class. Keywords base, new. Examples
  • 11.4. Examples of creating class hierarchies using inheritance
  • 11.5. Polymorphism
    • 11.5.1. Features of using reference to the base class. Keywords as, is. Ways to call methods with the same name in inheritance hierarchies
    • 11.5.2. An example of accessing methods and properties of inherited classes using a reference to the base class
    • 11.5.3. Polymorphism. Late and early binding. Basic concepts. Examples. Passing a reference to a base class in a method. Keywords virtual, override, new
  • 11.6. Abstract classes
    • 11.6.1. Abstract classes. Basic concepts. Keyword abstract. Examples
    • 11.6.2. An example of using an abstract class that contains abstract properties and methods
    • 11.6.3. An example of using an abstract class to build class hierarchies
  • 11.7. Prohibitions of inheritance. Keyword sealed. Features of use
• 14. Delegates
  • 14.1. The concept of delegate. Declaration of delegate type. Using a delegate in the program. Group transformation of methods
  • 14.2. Using delegates that reference the instance methods of the class. Example
  • 14.3. Delegates. Group addressing. Creating a chain of methods calling
  • 14.4. Anonymous functions. Anonymous methods. Returning the value. Passing parameters
  • 14.5. Examples of passing arrays, structures, classes to an anonymous method
• 15. Lambda expressions
  • 15.1. General concepts of lambda expressions. Lambda operator. Single and block lambda expressions
  • 15.2. Examples of lambda expressions that receive as a parameter an arrays, structures, classes
• 16. Events
  • 16.1. Events and delegates. The concept of event. Interaction between events. Examples of using
  • 16.2. Examples of using an anonymous method and a lambda expression as an event. Event handlers that are used in .NET environment
• 17. Input/Output tools. Streams
  • 17.1. Stream concept. Stream architecture in C#. Basic storage streams. Streams with decorators. Adapters streams
  • 17.2. The Stream class
    • 17.2.1. The Stream class. Review of methods. Methods from reading from a stream. Examples
    • 17.2.2. The Stream class. Operations (methods) of writing to a file stream. Examples
    • 17.2.3. The Stream class. Stream search methods (operations). Examples
  • 17.3. Streams with basic storages
    • 17.3.1. Hierarchy of streams with basic storages. The FileStream class
    • 17.3.2. The FileStream class. Additional read/write options. Enumeration FileOpions. Examples
  • 17.5. Stream adapters
    • 17.5.1. Classes StreamReader, StreamWriter
      • Classes StreamReader, StreamWriter. Working with text files. Constructors of StreamReader class
      • Methods of StreamReader class
      • StreamWriter class. Purpose. Constructors. Create an output stream in different ways
      • Class StreamWriter. Overview of methods and properties
    • 17.5.2. BinaryReader, BinaryWriter classes
      • The BinaryReader class. Working with binary files
      • The BinaryWriter class. Working with binary files
      • Examples of solving tasks of reading from files and writing data to files in binary format
• 18. Generics
  • 18.1. Generics. Basic concepts. Generic classes and structures
  • 18.2. Generic interfaces. Declaration syntax. Implementing generic interfaces in classes. Examples
  • 18.3. Generic methods in classes. Declaration syntax. Methods call
  • 18.4. Generic delegates
  • 18.5. Boxing and unboxing. The need of using generics
  • 18.6. Bounded types
    • 18.6.1. Bounded types. General concepts. Bounds on reference type and value type
    • 18.6.2. Constraints on the constructor, base class and interface
    • 18.6.3. Constraints in generic methods and delegates. Examples. Applying constraints for multiple types
  • 18.7. Comparison of instances of generic types. IComparable<T> and IEquatable<T> interfaces
  • 18.8. Applying generics to inheritance and polymorphism. Examples
    • 18.8.1. Hierarchies of generic classes. Generalized base and derived classes
    • 18.8.2. Overriding virtual methods in generic classes. Examples
  • 18.9. Covariance. Contravariance
    • 18.9.1. Covariance in generic interfaces. The out keyword
    • 18.9.2. Support for contravariance in generic interfaces. The in keyword
• 20. Reflection
  • 20.1. Run-time type information (RTTI). Statements is, as. Examples
  • 20.2. Reflection of types. Getting type metadata. The System.Reflection namespace. Class System.Type. Ways to get information about types. Operator typeof
  • 20.3. Examples of obtaining information about methods, interfaces, classes, structures, enumerations, delegates, type fields, method parameters, type statistics
  • 20.4. Dynamically loadable assemblies. Class Assembly. Methods Load() and LoadFrom()
  • 20.5. Late binding. Method call. Example. Class System.Activator. Method Invoke()
  • 20.6. Examples of using the reflection based on late binding
• 21. Attributes
  • 21.1. Attributes. The role of attributes. The need to use attributes. Custom attributes
  • 21.2. Constructors in attribute classes. Positional and named parameters. Examples
  • 21.3. Embedded .NET attributes. Attributes [AttributeUsage], [Obsolete], [Conditional], [Serializable], [NonSerialized]
• II. C# Library
  • 1. Collections
    • 1.2. General concepts about collections
    • 1.3. The ArrayList class
  • 2. Strings. Class StringBuilder. Methods of StringBuilder class
  • 3. Class System.Enum. Working with enumerations
• III. Controls (Windows Forms Application)
  • 1. DataGridView
  • 6. BackgroundWorker control
    • 6.1. Control (component) BackgroundWorker. Working with threads, background operations. Overview of methods, properties, events
    • 6.2. Displays the progress of completed work. Cancelling the execution of a thread

Practice

• Microsoft Visual Studio 2017 – 2019
  • Console App (.NET Framework) template
    • 001 – Example of creating a Unit-test in MS Visual Studio 2017
    • 002 – An example of the development program, which is placed in different files. Implementation of inheritance in classes. MS Visual Studio 2019 tools for splitting a program into parts
    • 003 – Development of a generic class that contains tools  for implementing linear search
    • 004 – Development of a generic class that implements the selection sorting algorithm
    • 005 – Examples of using the FileStream class without using additional streams (decorators, adapters)
  • Windows Forms App (.NET Framework)
    • 001 – Creating a pentagonal form
    • 009 – An example of creating a modeless form. Modal and modeless windows
    • 016 – Create a document to print.  Controls PrintDocument, PageSetupDialog, PrintDialog, PrintPreviewDialog
    • 017 – Development of a program for demonstrating work for threads with execution. BackgroundWorker control. Sorting an array by insertion, bubble, selection algorithms
• 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
• An example of solving problems using static data and method in a class
• Text files. The solution of tasks on the modification of text files. Classes File, StreamReader, StreamWriter

---

C++

Theory

• I. Fundamentals of C++
  • 1. C++. Features
  • 2. C++. General concepts
    • 2.1. Base types in C++
    • 2.2. Identifiers, reserved words, literals, escape sequences
    • 2.3. The concept of variable. Declaration of variable. Operation expansion of scope :: . Memory allocation for variables. Constants
    • 2.4. The concept of expression. Assignment operation. Converting and casting of types. Initialization. Unified initialization
  • 3. Operations. Basic operators
    • 3.1. Arithmetic operations
    • 3.2. Operations of relations
    • 3.3. Logical operations. Bitwise logical operations. Shift operations
    • 3.4. Operators of increment (++) and decrement (––). The complex assignment operators
    • 3.5. The operation sizeof. The ternary operation ? :
    • 3.6. The operation priority table in C++
  • 4. Control operators
    • 4.1. Conditional jump operator if
    • 4.2. Operator switch
    • 4.3. Loops. Loop operators for, while, do…while
    • 4.4. The break and continue statements. Features of use. Examples
  • 5. Arrays. Strings
    • 5.1. Array definition. One-dimensional arrays. Initializing array
    • 5.2. Two-dimensional arrays. Arrays of strings. Multidimensional arrays
    • 5.3. Examples of solving the most common problems with one-dimensional arrays
    • 5.4. Examples of solving tasks using character strings
    • 5.5. Arrays of strings of type string. Examples of tasks solving
  • 6. Classes for working with strings
    • The string class. Examples of use
    • Working with strings. Class System::String
  • 7. Pointers. References
    • 7.1. General concepts. Pointer types. Managed and unmanaged pointers. Pointers to a function. Examples of the use of pointers
    • 7.2. Unmanaged pointers. Operation on pointers. Pointer to type void. Memory allocation. A null pointer. The operation of getting the address &
    • 7.3. Unmanaged pointers and arrays. Pointer to structure. Pointer to class
    • 7.4. Pointers and strings. Using pointers when converting strings (char, string, wchar_t, System::String)
    • 7.5. Memory allocation for the pointer. Arrays of pointers to basic types, functions, structures, classes
    • 7.6. Composite managed and native data types. Managed pointers (^) in CLR. Memory allocation. The ref and value qualifiers. Managed pointers to structures and classes
    • 7.7. References. Basic concepts. References to variables, structures, unions and class objects. Differences between references and pointers. Examples
  • 8. Functions. Recursion
    • 8.1. Function declaration. Actual and formal parameters (arguments). Passing arguments to a function by value and by reference. Function prototype
    • 8.2. Functions and arrays. Passing a one-dimensional and multidimensional array to a function. Passing a structure and a class to a function
    • 8.3. Default arguments in functions
    • 8.4. Overloaded functions. Overloaded functions in classes. Overloading of class constructors. Access to the overloaded function using a pointer. Examples
    • 8.5. Passing a constant parameters to a function. The return of constant from function
    • 8.6. Generalization in functions. Template function. Keywords template, typename, class. Explicit specialization of template function. Overloading of template function
    • 8.7. Recursion. Examples of tasks solving. Advantages and disadvantages of recursion
  • 9. Structures. Unions. Enumerations
    • 9.1. Composite data types. The template of structure. Structural variable. Structures in the CLR. Declaring and initializing a structured variable
    • 9.2. Memory allocation for the structure. Nested structures. Arrays of native structures
    • 9.3. Working with managed-structures in CLR. Qualifiers ref and value. Declaring structural variables. Arrays of managed-structured variables. Initializing of managed-structures
    • 9.4. Structures and functions. Passing a structure to a function in the CLR. Returning a structure from a function
    • 9.5. Structures. Using methods in structures. Constructors in structures
    • 9.6. Structures and inheritance. Structures and polymorphism. Abstract structure. Overloading of operators in structures. Static methods in structures
    • 9.7. Unions. The keyword ‘union’. Examples of declaring and using unions
    • 9.8. Enumerations. Keyword enum. The advantages of using enumerations. Examples
    • 9.9. Bit fields in structures. Examples
  • 10. Dynamic and static allocation of memory
    • 10.1. Dynamic and static allocation of memory. Advantages and disadvantages. Allocating memory for single variables by the operators new and delete. Initialization when allocating memory
    • 10.2. Memory allocation for structural variables, class objects, arrays. Initialization of allocated memory. Reallocation of memory. Examples
  • 11. Preprocessor 
    • 11.1. Macros. Directive #define. Examples
• II. Object-oriented programming in C++
  • 2. Classes
    • 2.1. The concept of class. Class declaration. The object of the class. Classes in the CLR. Data encapsulation in the class
    • 2.2. Special functions in classes
      • 2.2.1. Class constructor. Features of use constructors in the classes. The default constructor. Parameterized constructor. Examples of calsses that contain constructors
      • 2.2.2. Copy constructor. Examples of using. Passing a class object to a function. Returning a class object from a function
      • 2.2.3. Destructor. Definition of the destructor. Public and private destructors. Examples of destructors using. Differences between constructors and destructors
      • 2.2.4. The default methods. Deleted methods. Keywords default, delete
      • 2.2.5. Move constructor. Move operator
    • 2.3. Members of the class data
      • 2.3.1. Using the class data members. Static data members in the class. Static data members for native-classes and managed-classes
      • 2.3.2. Class objects as members of the class data. Initialization of internal object of the class. Examples
      • 2.3.3. References to the class object. Access to a class object by reference. References as members of class data. Examples
    • 2.4. Functions-members of class
      • 2.4.1. Types of functions of class members. Ordinary member functions. Static member functions. Examples
      • 2.4.2. Constant member functions. Member functions ‘volatile’
      • 2.4.3. Class functions that are declared with a constant (const) ‘this’ pointer and a volatile ‘this’ pointer
      • 2.4.4. Inline member functions of class. The inline keyword
    • 2.5. Encapsulation
      • 2.5.1. Access modifiers: private, protected public. Encapsulating data in a class
      • 2.5.2. Using private, protected, public access modifiers when inheriting classes
    • 2.6. Classes of memory that can be declared when working with classes and class objects. Keywords register, extern, static, mutable
    • 2.7. Managed and unmanaged classes in Visual C++. Overview. Example of implementing managed and unmanaged classes
    • 2.8. “Friends” of the class. “Friendly” classes and functions. The keyword ‘friend’. Examples
    • 2.9. Class template. The ‘template’ keyword. Advantages of using templates. Arguments in templates. Examples
    • 2.10. Arrays in classes
      • 2.10.1. Arrays of objects in managed and unmanaged classes. Examples. Array of unmanaged pointers to a class
      • 2.10.2. Initializing arrays with data values from class objects. Examples
      • 2.10.3. Arrays of pointers to the class members methods. Examples
      • 2.10.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
    • 2.11. The concept of bitwise copying. Example
  • 4. Operator overloading
    • 4.1. Operator overloading in C++. Operator function. Keyword operator. Overload of basic arithmetic operators +, –, *, /. Examples of the implementation of built-in operator functions
    • 4.2. “Friendly” operator functions: differences, implementation. Overload of operators +, –, *, / with the help of friendly operator functions
    • 4.3. An example of elementwise summation of two arrays. Class DoubleArray. Overloading + operator. Dynamic memory allocation in class. Copy constructor. Bitwise copy disadvantages
    • 4.4. Overloading increment and decrement operators ++, – –. Examples
    • 4.5. Overloading of shortened assignment operators +=, -=, *=, /=, %=. Examples
    • 4.6. Overloading operators new and delete. Examples
    • 4.7. Overloading the assignment operator =. Examples
    • 4.8. Overloading operator [ ] indexing items of the array
    • 4.9. Overloading of operator ( ) of function call. Examples
    • 4.10. Overloading of operators -> and ‘ , ‘ (comma). Examples
  • 5. Aggregation, composition, inheritance, polymorphism, abstract classes
    • 5.1. Types of relations between classes: is-a, has-a, uses. Examples. Aggregation. Composition
    • 5.2. Inheritance
      • 5.2.1. Inheritance. General concepts. Using private, protected, public modifiers when inheriting
      • 5.2.2. Order of calling constructors during inheritance. Inheritance restrictions. Properties to the pointer to the base class
    • 5.3. Polymorphism. Virtual functions. General concepts. Specifiers virtual, override. Examples
    • 5.4. Abstract class. Pure virtual function. Examples
  • 6. Exceptions
    • 6.1. The concept of exception. Instruction try…catch. Examples. Operator throw
    • 6.2. An example of creating a class hierarchy for exception handling
    • 6.3. Class exception. Using class to handle exceptions
  • 7. Namespaces. Keywords namespace, using. Namespace creation rules. Global namespace
  • 9. Run-Time Type Identification. Smart pointers
    • 9.1. Run-Time Type Identification. The typeid operator. Examples
    • 9.2. Operators dynamic_cast, const_cast, reinterpret_cast, static_cast. Examples
    • 9.3. Smart pointers. Automatic pointer. Class auto_ptr
    • 9.4. Smart pointers. Pointer classes unique_ptr, shared_ptr, weak_ptr
  • 10. File system
    • 10.1. C++ File System. General concepts. Examples. Open/close file
    • 10.2. Examples of using C++ for working with files
    • 10.3. Examples of working with text files. Modification of files. Sort data in files. Converting file lines to array. Replacing/deleting lines in a file. Inserting a line in the file
    • 10.4. Examples of saving/reading class objects. Serialization
  • 11. Dynamic data structures
    • 11.1. Stack. Operations on the stack. An example implementation of the stack as a dynamic array
    • 11.2. Queue. General concepts. Ways to implement the queue. Implementing a queue as a dynamic array
    • 11.3. Priority Queue. Example of implementation for template class. Implementation as a dynamic array
    • 11.4. Ring queue. Developing a template class that implements a ring queue
    • 11.5. Development a template class that implements a stack in the form of a linked list
    • 11.6. Linear singly linked list. General information. Basic operations on the list
    • 11.7. An example of implementation of a linear singly-linked list for the generic type T
    • 11.8. Linear doubly linked list. General concepts. Basic operations on the list
    • 11.9. Linear doubly linked list. Example of a template class
• III. Library of standard functions and classes
  • 1. Generating random numbers. Functions rand(), srand(), time(). Examples
• IV. Examples of classes development
  • 01. Developing a class that implements an array of char* strings
  • 02. Developing a Random class for generating random numbers
  • 03. Development of a class that implements linear search in a one-dimensional array
  • 04. Development of a class that implements the selection sorting algorithm
  • 05. Development of a class that implements a “smart” pointer
• V. Standard Template Library (STL)
  • 1. Standard Template Library. General concepts. Containers. Algorithms. Iterators. Functors
  • 2. Containers
    • 2.1. Class vector. Dynamic array
      • 2.1.1. General information about the class vector. Methods overview. Creating a dynamic array. Ways to access vector elements
      • 2.1.2. Methods that define and modify the general characteristics of array: size(), max_size(), capacity(), empty(), shrink_to_fit(), resize(), reserve()
      • 2.1.3. Methods that modify data in the array. Methods push_back(), pop_back(), clear(), swap(), operator=(), erase(), insert(), assign()
      • 2.1.4. Methods that provide access to array elements. Methods at(), front(), back(), data(), begin(), end(), cbegin(), cend(), rbegin(), rend(), crbegin(), crend()

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-2019

• 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
• 013 – Test. An application of type Console Application. Template class CArray

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
• Tasks solving. Functions and arrays. Function prototype. Passing an array to a function
• Examples of implementation of template functions and overloaded template functions. Processing arrays
• Recursion. Examples of task solving on recursion in C++
• Developing a class demonstrating the implementation of an overflow exception for built-in int type
• An example of creating a template class MATRIX. Dynamic memory allocation

---

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
      • Strong and weak relations between entity types. Unary relations. Recursive relation
    • 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
    • Normalization
      • Normalization. Concept and necessity of using. Modification anomalies. Examples
      • First normal form (1NF). Converting the table to first normal form. Examples
      • Functional dependencies. Building functional dependency diagram. Example
      • Second normal form (2NF)
• 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