SQL

MFC Database Access

MFC's two parallel database frameworks - ODBC-based CDatabase/CRecordset and DAO-based CDaoDatabase/CDaoRecordset - and how record field exchange (RFX/DFX) bin…

Debugging LINQ Queries

Practical techniques for stepping through, inspecting, and diagnosing bugs in LINQ query chains, including deferred execution pitfalls.

Joining with Join

Learn how LINQ's Join operator performs inner joins between two sequences, how GroupJoin enables left-outer-join patterns, and how composite keys and performan…

Query Syntax vs Method Syntax

LINQ offers two equivalent ways to write the same query — SQL-like query syntax and fluent, chainable method syntax — and knowing when to reach for each makes…

LINQ to SQL and LINQ to Entities

Learn how LINQ to SQL and LINQ to Entities translate C# query expressions into database SQL, and how their architectures differ.

Database Access in Web Pages

Learn how the WebMatrix.Data.Database helper connects ASP.NET Web Pages to SQL databases with lightweight Query, Execute, and parameterized SQL methods.

Working with SQL in Web Forms

Learn practical patterns for executing SQL from Web Forms code-behind, including parameterized queries, stored procedures, and transactions.

SQL Server Connector

How to connect Power Apps to Azure SQL Database or on-premises SQL Server, work with stored procedures and views, and understand the connector's delegation beh…

Avoiding the N+1 Query Problem

How lazy loading silently causes one query per entity in a loop, and how Include, projection, and split queries fix it in EF Core.

Code-First vs Database-First

Comparing the Code-First and Database-First workflows in EF Core and how to choose between them, including hybrid approaches.

Handling Schema Drift in Teams

Strategies for detecting and resolving mismatches between the EF Core model, migration history, and the actual database schema across a team.

Raw SQL Queries with FromSqlRaw

When and how to drop down to raw SQL in EF Core with FromSqlRaw and FromSqlInterpolated, and how to do it without opening a SQL injection hole.

Tracking vs No-Tracking Queries

When to let EF Core track query results for later updates versus opting out with AsNoTracking for faster, read-only workloads.

Your First Query

Writing and executing your first LINQ query against EF Core, including deferred execution, projections, async queries, and the N+1 pitfall.

Joins in Spark

How Catalyst chooses between broadcast hash joins and sort-merge joins, why the choice matters for performance, and how to diagnose and fix skewed joins.

Running SQL Queries on DataFrames

Learn how to register DataFrames as temporary views and query them with standard SQL syntax, and how SQL and the DataFrame API interoperate under the hood.

The Spark SQL API

How Spark SQL lets you query DataFrames with standard SQL, compiling to the same Catalyst-optimized plan as the DataFrame API.

Window Functions in Spark SQL

Understand how to compute running totals, rankings, and moving averages across partitions of rows using Spark's window function API.

The Table API and Flink SQL

Learn how Flink's Table API and SQL layer let you express streaming and batch pipelines declaratively on top of the DataStream engine.

Building a Data Warehouse Schema

How to design a layered, star-schema Snowflake warehouse with correctly-chosen grain, slowly changing dimensions, and incremental loading.

Databases, Schemas, and Warehouses

How Snowflake organizes data into databases and schemas, and how virtual warehouses exist independently as compute resources.

Query Performance and Caching

Explore Snowflake's layered caching model, including result cache, local disk cache, and metadata cache, and how each speeds up repeated queries.

Querying with Snowflake SQL

A practical tour of Snowflake's SQL dialect, covering joins, window functions, common table expressions, and result caching.

Your First Snowflake Query

A hands-on guide to running your first SQL query in Snowsight, including context, syntax, and Snowflake's free sample dataset.

Learn SQL Through Music Data Analysis

A comprehensive guide to learn sql through music data analysis — written for learners at every level.

SQL Tutorial for Beginners with Examples

Master SQL with simple examples and real-world queries. Perfect for aspiring data analysts.

Project: Build a Full-Stack To-Do App with React, Node.js and MongoDB

A full-stack to-do app is the perfect first MERN project — it covers every concept you'll use in production: REST APIs, database CRUD operations, JWT authentic…

Project: Build a REST API with Python and FastAPI

FastAPI is the fastest-growing Python web framework — and for good reason. In this hands-on project you'll build a fully functional REST API with auto-generate…

Learn SQL Through Football Data

Football generates rich match data — goals, assists, passes, xG, red cards. This project uses a Premier League dataset to teach SQL SELECT, WHERE, GROUP BY, JO…

Vector Databases Explained: The Memory Layer Powering AI Apps

Vector databases are the storage layer behind RAG systems, semantic search, and AI- powered recommendations. This guide explains what they are, how they differ…

Async Python: asyncio Explained for Beginners

Async Python lets a single thread handle hundreds of concurrent I/O operations — making it essential for web APIs, database calls, and AI integrations. This gu…

From Teacher to Data Analyst: An Illustrative 8-Month Transition

This composite illustrative story follows how a secondary school maths teacher used her existing analytical skills to transition into a data analyst role — sta…

SQL Tutorial for Beginners: With Real Examples

SQL is the language of data — used by data analysts, backend developers, and data scientists every day. This tutorial covers SELECT, WHERE, ORDER BY, GROUP BY,…

AWS for Beginners: Cloud Computing Fundamentals

Amazon Web Services is the world's most widely used cloud platform. This guide covers the core services every developer needs — EC2 (virtual servers), S3 (stor…

SQL Cheat Sheet

Common SQL queries, joins, clauses, and database operations.

DuckDB Cheat Sheet

Run fast in-process analytical SQL queries directly on CSV, Parquet, and pandas data with DuckDB's embedded OLAP engine.

Secure Coding Practices Cheat Sheet

Language-agnostic patterns for input validation, output encoding, secrets handling, and common vulnerability prevention.

What is Normalization in Database?

Normalization is the process of organizing data in a database to reduce redundancy, avoid anomalies, and improve data integrity.

What are ACID Properties in DBMS?

ACID stands for Atomicity, Consistency, Isolation, and Durability — the four guarantees a database transaction must satisfy so that data stays correct even und…

Difference Between SQL and NoSQL Databases

SQL databases are relational, store data in structured tables with a fixed schema, and use SQL for querying; NoSQL databases are non-relational, store data in…

What is an Index in a Database?

A database index is a data structure that speeds up read queries by letting the database find rows without scanning the entire table, at the cost of extra stor…

What is a JOIN in SQL?

A SQL JOIN combines rows from two or more tables based on a related column, letting you query normalized data as if it were a single table.

Difference Between Primary Key and Foreign Key

A primary key uniquely identifies each row in a table and cannot be NULL, while a foreign key is a column that references the primary key of another table to l…

Difference Between DELETE, TRUNCATE and DROP

DELETE removes selected rows and can be rolled back, TRUNCATE quickly removes all rows but keeps the table structure, and DROP removes the entire table includi…

What is a View in SQL?

A view is a virtual table defined by a stored SQL query; it holds no data of its own but presents the result of that query as if it were a table whenever you s…

What is a Transaction in a Database?

A transaction is a sequence of one or more database operations that executes as a single, indivisible unit of work — either every operation succeeds and commit…

What is Database Sharding?

Database sharding is a horizontal partitioning technique that splits a large dataset across multiple independent database servers (shards), where each shard ho…

Clustered vs Non-Clustered Index: What is the Difference?

A clustered index determines the physical order in which table rows are stored on disk, while a non-clustered index is a separate structure that stores pointer…

What is a Stored Procedure in SQL?

A stored procedure is a precompiled, named block of SQL statements saved inside the database that can be executed repeatedly with a single call, optionally acc…

What is Database Replication?

Database replication is the process of continuously copying data from one database server (the primary) to one or more other servers (replicas), so multiple co…

What is a Deadlock in Database?

A deadlock in a database happens when two or more transactions each hold a lock the other needs, so every transaction involved waits forever and none can proce…

What is Database Partitioning?

Database partitioning is splitting a large table into smaller, more manageable pieces called partitions, while the table is still queried as one logical unit.

Optimistic vs Pessimistic Locking: What is the Difference?

Pessimistic locking locks a row before reading it so no one else can change it, while optimistic locking allows concurrent reads and only checks for conflicts,…

What is a Trigger in SQL?

A trigger in SQL is a stored piece of code that automatically executes in response to a specific event, such as an INSERT, UPDATE, or DELETE, on a table.

What is Denormalization in Database?

Denormalization is the deliberate process of combining data from multiple related tables back into fewer, wider tables to reduce joins and speed up read querie…

Inner Join vs Outer Join

An INNER JOIN returns only the rows that have matching values in both tables, while an OUTER JOIN (LEFT, RIGHT, or FULL) returns matched rows plus unmatched ro…

What is a Composite Key?

A composite key is a primary key made up of two or more columns that, together, uniquely identify a row, even though no single column among them is unique on i…

HAVING vs WHERE Clause

WHERE filters individual rows before any grouping or aggregation happens, while HAVING filters groups after GROUP BY has aggregated them, so HAVING is the only…

What is a Cursor in SQL?

A cursor is a database object that lets a program process a query result set one row at a time, instead of the usual set-based operation that acts on all match…

CHAR vs VARCHAR

CHAR is a fixed-length string type that always stores and pads to its declared length, while VARCHAR is a variable-length type that stores only the actual char…

What is Connection Pooling?

Connection pooling is a technique where a fixed set of pre-established database connections is reused across multiple requests instead of opening and closing a…