- July 02, 2020
- Nikolay Kostov (Nikolay.IT)
Topics covered:
- SQL Profilers
- The N+1 Query Problem
- Incorrect Use of ToList()
- Incorrect use of SELECT *
- Deleting objects faster with native SQL
Read More
- June 24, 2020
- Nikolay Kostov (Nikolay.IT)
Overview of data structures and basic algorithms, computational complexity and asymptotic notation. Video recorded in 2015 in Bulgarian.
Topics covered:
- Data Structures Overview
- Linear Structures, Trees, Hash Tables, Others
- Algorithms Overview
- Algorithms Complexity
- Time and Memory Complexity
- Mean, Average and Worst Case
- Asymptotic Notation
O(g)
Read More
- June 04, 2020
- Nikolay Kostov (Nikolay.IT)
Topics covered:
- Database Performance Factors
- Query Execution Plans
- Operations and Costs
- Table Scan
- Nested Loops
- Index Seek
- Clustered Index Seek
- Merge Join
- Hash Join
- Sort
- Hash Match
- Table Indexes - Clustered and non-Clustered Indexes
- Caching SQL Query Results
- Table Partitioning in SQL Server
Read More
- May 31, 2020
- Nikolay Kostov (Nikolay.IT)
A webinar about the processes and good practices in developer and QA teams with Nikolay Kostov, Ivaylo Kenov, Dimo Mitev and Mila Madjarova
Read More
- May 27, 2020
- Nikolay Kostov (Nikolay.IT)
3 video lectures in Bulgarian about creating a Tetris game on the console using C# and .NET Core
- Link to the source code after part 1: GitHub
- Link to the source code after part 2: GitHub
- Link to the source code after part 3: GitHub
Read More