- August 03, 2022
- Nikolay Kostov (Nikolay.IT)
Video lecture with an introduction to SQL Server.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- SQL Server Services
- Types of Databases
- Authentication and Permissions
- SQL Server Management Studio
- Moving a SQL Server Database
- Through Backups and Restore
- By Detaching and Attaching
Read More
- July 11, 2022
- Nikolay Kostov (Nikolay.IT)
Video lecture with a brief summary of the database systems.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- Database Models
- Relational Database Model
- DBMS & RDBMS Systems
- Tables, Relationships, Multiplicity, E/R Diagrams
- Normalization
- Constraints
- Indices
- The SQL language
- Stored Procedures
- Views
- Triggers
- Transactions and Isolation Levels
- NoSQL Databases
Read More
- July 04, 2022
- Nikolay Kostov (Nikolay.IT)
Video lecture about using Win32 and COM Interoperability in the C# programming language.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- Comparing “managed execution” and "native execution”
- The metadata-driven partnership
- Mechanics of managed/native interop
- CLR => Win32
- CLR => COM
Read More
- June 14, 2022
- Nikolay Kostov (Nikolay.IT)
Video lecture about using classes and objects in the C# programming language.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- Classes and Objects
- What are Objects?
- What are Classes?
- Classes in C#
- Declaring Class
- Fields and Properties: Instance and Static
- Instance and Static Methods
- Constructors
- Enumerations
- Structures
- Namespaces
- Random class
- Introduction to .NET Common Type System
Read More
- June 03, 2022
- Nikolay Kostov (Nikolay.IT)
Video lecture about serialization and deserialization in the C# programming language.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- Serialization Overview
- Serialization Formatters
- The [Serializable] Attribute
- IDeserializationCallback Interface
- XML Serialization
Read More