Video: Introduction to the Entity Framework (Bulgarian)

Video lecture with an introduction to the Entity Framework ORM.

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

Topics covered:

  • ORM Technologies – Basic Concepts
  • Entity Framework – Overview
  • Reading Data with EF
  • Create, Update, Delete using Entity Framework
  • Extending Entity Classes
  • Executing Native SQL Queries
  • Joining and Grouping Tables
  • Attaching and Detaching Objects

Read More


Video: Introduction to the SQL Language (Bulgarian)

Video lecture with an introduction to the SQL language.

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

Topics covered:

  • SQL and T-SQL Languages
  • Introducing the SELECT SQL Statement
    • Allowed Operators
    • The WHERE Clause
    • Sorting with ORDER BY
    • Selecting Data From Multiple Tables
  • Selecting Data From Multiple Tables
    • Natural Joins
    • Join with USING Clause
    • Inner Joins with ON Clause
    • Left, Right and Full Outer Joins
    • Cross Joins
  • Inserting Data
  • Updating Data
  • Deleting Data

Read More


Video: Introduction to SQL Server (Bulgarian)

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


Video: Database Systems Summary (Bulgarian)

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


Video: Win32 and COM Interop in C# (Bulgarian)

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

Read More