Contents
Java
Theory
- 1. Java. General concepts
- 2. Data types. Literals. Keywords. Variables
- 3. 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
- 6. Strings
- 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.3. Initialization in classes
- 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
- 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
- 7.1. Classes and objects
- 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
- 12. Exceptions
- 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
- 16. Additional Java features
- 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
Practice
- 1. Developing classes
- 2. Stream API
- 3. Solving tasks. Examples
Delphi
Theory
- I. Structural programming. Basic course
- 1. Development of programs on the PC. Algorithms
- 2. Basic concepts of the Pascal language. Standard data types. Variables, constants
- 3. Basic syntactic constructions of the Pascal language
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
- 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
- 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
- 8. Interfaces. The use of interfaces in C# programs
- 9. Classes
- 9.1. General concepts. Objects. The data and methods of the class
- 9.2. Special class functions
- 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
- 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
- 11.6. Abstract classes
- 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
- 16. Events
- 17. Input/Output tools. Streams
- 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
- III. Controls (Windows Forms Application)
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
- Windows Forms App (.NET Framework)
- Console App (.NET Framework) template
- 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
- ASP .NET Web Application template
- Distributed applications
- Windows Forms Application template
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
- 5. Arrays. Strings
- 6. Classes for working with strings
- 7. Pointers. References
- 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.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.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
- 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
- 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 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. Encapsulation
- 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
- 6. Exceptions
- 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
- 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
- 2. Classes
- III. Library of standard functions and classes
- IV. Examples of classes development
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
- Normalization
- Basic concepts
- Practice
- Working with the Microsoft SQL Server database server 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