- September 02, 2022
- Nikolay Kostov (Nikolay.IT)
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
- August 17, 2022
- Nikolay Kostov (Nikolay.IT)
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
- 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