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
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
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
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
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