Nikolay Kostov's Blog

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

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

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