Nikolay Kostov's Blog

Overview of linear data structures such as lists, linked lists, stacks and queues. The video is recorded in 2015 in Bulgarian.

Topics covered:

• Lists
  • Static and Linked Implementation
  • List<T> and LinkedList<T>
• Stacks
  • Static and Linked Implementation
  • The Stack<T> Class
• Queues
  • Circular and Linked Implementation
  • The Queue<T> Class

Topics covered:

• SQL Profilers
• The N+1 Query Problem
• Incorrect Use of ToList()
• Incorrect use of SELECT *
• Deleting objects faster with native SQL

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)

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

A webinar about the processes and good practices in developer and QA teams with Nikolay Kostov, Ivaylo Kenov, Dimo Mitev and Mila Madjarova