Nikolay Kostov's Blog

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

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
  • P/Invoke
• CLR => COM

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

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 Advantages
• Serialization Formatters
  • The [Serializable] Attribute
• IDeserializationCallback Interface
• XML Serialization

Video lecture about strings and text processing in the C# programming language.

The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.

Topics covered:

• What is String?
• Creating and Using Strings
  • Declaring, Creating, Reading and Printing
• Manipulating Strings
  • Comparing, Concatenating, Searching, Extracting Substrings, Splitting
• Other String Operations
  • Replacing Substrings, Deleting Substrings, Changing Character Casing, Trimming
• Building and Modifying Strings
  • Why the + Operator is Slow?
  • Using the StringBuilder Class
• Formatting Strings
  • Formatting Numbers, Dates and Currency
• Cultures and Culture-Sensitive Formatting
  • Accessing and Assigning the Current Culture
  • Parsing Numbers and Dates