Data Access in .NET

The courses, in order

1. 01
   Start here

   Advanced C#, EF Core and SQL Interview Q&A

   Review advanced C# runtime, async and API questions. • Explain EF Core behavior and data-access trade-offs. • Practise SQL queries, schema design and transactions. • Discuss performance, security and operational reliability.

   Advanced · 10 lessons · 1 h 55 min

2. 02
   EF Core Data Correctness and Safe Schema Delivery

   Handle EF Core identity, disconnected updates and concurrency. • Reason about transactions, retries and uncertain commits. • Plan migrations, backfills and mixed-version deployments. • Rehearse failures and recovery before release.

   Intermediate · 7 lessons · 1 h 13 min · 6 practice tests

3. 03
   EF Core Performance and Behavior

   Understand EF Core query translation and change tracking. • Diagnose N+1 queries, joins and tracking costs. • Handle context lifetimes, transactions and concurrency. • Review migrations, retries and a measured tuning workflow.

   Intermediate · 18 lessons · 5 h 18 min

4. 04
   SQL Server for .NET Developers

   Read execution plans, estimates and logical reads. • Choose indexes and write searchable predicates. • Understand transactions, isolation, blocking and deadlocks. • Use Query Store and diagnostics to verify tuning changes.

   Intermediate · 15 lessons · 4 h 43 min