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 2010-2019
  • Tasks solving
• Databases

---

Java

• 1. Java. General concepts
• 2. Data types. Literals. Keywords. Variables
  • 2.1. Data 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
  • 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
• 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

---

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

• 1. C#. Overview
  • The basic concepts of .NET Framework technology
• 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
• 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. 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
• 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. Classes. Class definition. Object of class. Keyword this
  • 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. Examples. Passing arrays of structures, classes, enumerations to methods. Passing two-dimensional arrays. Returning the array from method
      • 5. Optional arguments. Advantages. Examples of using optional arguments. Ambiguity when using optional arguments
      • 6. 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.5. Static classes, methods, variables. Static constructors. Keyword static
  • 9.6. Nested classes. Nested static classes. Declaring and using nested classes. Examples
  • 9.7. Initialization data in classes. Ways to initialize data in the class. The object initializer
• 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
• 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()
• II. C# Library
  • 1. Collections
    • 1.2. General concepts about collections
    • 1.3. The ArrayList class
• III. Controls (Windows Forms Application)
  • 1. 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

• Fundamentals of C++
  • 1. C++. Features
  • 2. C++. General concepts
    • 2.1. Base types in C++ (Visual C++)
    • 2.2. Identifiers, reserved words, literals, escape sequences
    • 2.3. The concept of variable. Declaration of variable. Memory allocation for variables. Constants
    • 2.4. The concept of expression. Assignment operation. Converting and casting of types
  • 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. Cycles. Operators of the cycle for, while, do…while
  • 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
  • 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. Unions. The keyword ‘union’. Examples of declaring and using unions
    • 9.6. Enumerations. Keyword enum. The advantages of using enumerations. 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 
• 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 destructos. Examples of destructors using. Differences between constructors and destructors
      • 2.2.4. The default methods. Deleted methods. Keywords default, delete
    • 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. 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. Classes of memory that can be declared when working with classes and class objects. Keywords register, extern, static, mutable
    • 2.6. Managed and unmanaged classes in Visual C++. Overview. Example of implementing managed and unmanaged classes
    • 2.7. “Friends” of the class. “Friendly” classes and functions. The keyword ‘friend’. Examples
    • 2.8. Class template. The ‘template’ keyword. Advantages of using templates. Arguments in templates. Examples
    • 2.9. Arrays in classes
      • 2.9.1. Arrays of objects in managed and unmanaged classes. Examples. Array of unmanaged pointers to a class
      • 2.9.2. Initializing arrays with data values from class objects. Examples
      • 2.9.3. Arrays of pointers to the class members methods. Examples
      • 2.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
    • 2.10. 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
  • 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
  • 10. File system
    • 10.1. C++ File System. General concepts. Examples. Open/close file
    • 10.2. Examples of using C++ for working with files
  • 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. Development a template class that implements a stack in the form of a linked list

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