Search tutorials

Matching courses (6)

SQL Server Tutorial

100-article SQL Server master path — T-SQL, indexing, stored procedures, HA, SQL Server 2022, and DataVerse projects.

ADO.NET Core Tutorial

100-article data access master path — SqlConnection, stored procedures, transactions, performance, and enterprise projects.

MySQL Tutorial

100-article MySQL master path — InnoDB, window functions, replication, AWS RDS, and DataFlow projects.

MongoDB Tutorial

100-article MongoDB master path — aggregation, sharding, Atlas, vector search, and NoSQLVerse projects.

Oracle SQL Tutorial

96-article Oracle master path — PL/SQL, RAC, Data Guard, RMAN, AWR, OCI, and OracleCore projects.

PostgreSQL Tutorial

100-article PostgreSQL master path — MVCC, JSONB, pgvector, replication, Patroni, and PostgresVerse projects.

Lessons (2523)

Value Conversions (Enums & Strongly Typed IDs)

Entity Framework Core Mastery · 2. Code-First Modeling

.NET

E-Commerce Web Application

ASP.NET Core MVC Mastery · MODULE 21: REAL-WORLD PROJECTS (🔥 MUST DO)

.NET

DbContext Pooling Mechanisms

Entity Framework Core Mastery · 6. Advanced Performance & Scale

.NET

Proxy Pattern: Interception, Lazy-Loading, and Security

Design Patterns Mastery · 3. Structural Patterns

.NET

Concurrency Tokens and Optimistic Locking

Entity Framework Core Mastery · 6. Advanced Performance & Scale

.NET

Transaction Isolation Levels: Read Uncommitted to Snapshot

SQL Server Mastery · 5. Transactions & Concurrency

Database

Data Annotations

ASP.NET Core MVC Mastery · MODULE 12: VALIDATION

.NET

The Infrastructure Layer: Bridging to the outside world

Clean Architecture & DDD Mastery · 4. Implementing the Clean Layers

.NET

Subqueries vs CTEs: Writing readable, high-performance code

SQL Server Mastery · 2. Advanced T-SQL Querying

Database

Method Syntax vs Query Syntax: Trade-offs

LINQ Mastery · 1. Core Foundations

.NET

Interceptors (Logging & Auditing Data Changes)

Entity Framework Core Mastery · 6. Advanced Performance & Scale

.NET

CQRS Pattern (Command Query Responsibility Segregation)

Design Patterns Mastery · 5. Modern Enterprise & Cloud Patterns

.NET

Aggregations & Grouping Sets: Building complex reports

SQL Server Mastery · 2. Advanced T-SQL Querying

Database

Entity Conventions & Data Annotations

Entity Framework Core Mastery · 2. Code-First Modeling

.NET

Many-to-Many Relationships & Navigation Properties

Entity Framework Core Mastery · 3. Relational Architecture

.NET

Backup & Recovery Models: Full vs Simple vs Bulk-Logged

SQL Server Mastery · 6. Administration & Security

Database

GroupBy: The SQL counterpart in LINQ

LINQ Mastery · 6. Join & Grouping

.NET

TakeWhile & SkipWhile: Dynamic partitioning

LINQ Mastery · 4. Ordering & Partitioning

.NET

Optimistic vs Pessimistic Concurrency

SQL Server Mastery · 5. Transactions & Concurrency

Database

Clustered vs Non-Clustered Indexes: The physical storage reality

SQL Server Mastery · 3. Indexing & Performance Tuning

Database

Toolliyo Assistant

Ask about tutorials, ebooks, training, pricing, mentor services, and support. I use public site content only—not admin or internal tools.

care@toolliyo.com