SQL and Data Access in .NET
Query, change and design relational databases in SQL Server and PostgreSQL, then work with them from .NET using Dapper and Entity Framework Core. The SQL stages start at your first SELECT; the .NET stages assume you already write C#.
- Milestone 1
Relational databases and SQL
Build a database with related tables and views, query it with joins, aggregates, subqueries, CTEs and window functions, change its data inside transactions, and use a query plan to decide on indexes.
- Getting Started: SQL ServerA short first look at a relational database in SQL Server: building a database, changing data, programming basics, relationships and views.3h 5m
- Hands-On: Learn PostgreSQLPractices the language in depth on PostgreSQL, from WHERE and JOINs to CTEs, window functions, indexes, query analysis and transactions.17h 4m
- Milestone 2
Data access from .NET
Query and change a database from .NET with Dapper, including stored procedures, relationships and bulk operations, then map classes to tables with Entity Framework Core, change the schema through migrations, and handle testing, performance and concurrency.
- From Zero to Hero: Dapper in .NETDapper keeps you writing SQL by hand and maps the results to C# objects: queries, stored procedures, relationships, bulk operations and a CRUD API.3h 22m
- From Zero to Hero: Entity Framework Core in .NETNext, EF Core writes that SQL for you from a C# model, then covers migrations, testing, advanced modeling, performance, concurrency and existing databases.8h 32m
- Milestone 3
Caching in front of the database
Put a cache in front of the database in .NET, choose a cache type, and keep cached data correct under load with stampede protection and cache synchronization.
