> Canonical URL: https://codingcat.dev/topic/sql

# SQL Courses, Podcasts & Blog Posts | CodingCat.dev

⌨️ Language & Standard Hub

# SQL.

Relational Modeling, B-Tree Indexing, EXPLAIN QUERY PLAN & Joins

Explore CodingCat.dev hands-on courses, video lessons, podcast episodes, and technical deep-dive blog posts covering SQL: Relational Modeling, B-Tree Indexing, EXPLAIN QUERY PLAN & Joins.

[Search All SQL Content](/search?q=SQL)![SQL official logo](/logos/tags/sql-lockup-light.svg)![SQL official logo](/logos/tags/sql-lockup-dark.svg)Official SQL Brand Lockup (16 Blog Posts · 2 Episodes)✏️ SQL Production Architecture Diagram✓ Good PatternVISUAL DIAGRAM[Diagram Walkthrough]How SQL fits into a modern, type-safe full-stack production architecture on CodingCat.dev.AAA Contrast Verified

## SQL Courses.

[All Courses→](/courses)[![Cloudflare Agents, Durable Objects & Stateful Workflows in TypeScript](https://cdn.sanity.io/images/hfh83o0w/production/093f286587d2720f2a0908e4149bbfcb29cf409f-1376x768.png?w=1376&q=82&fit=max&auto=format)](/course/cloudflare-agents-durable-workflows-typescript)November 4, 2026[![](/logos/tags/cloudflare-symbol-light.svg)![](/logos/tags/cloudflare-symbol-dark.svg)Cloudflare](/topic/cloudflare)[![](/logos/tags/typescript-symbol-light.svg)![](/logos/tags/typescript-symbol-dark.svg)TypeScript](/topic/typescript)

### [Cloudflare Agents, Durable Objects & Stateful Workflows in TypeScript](/course/cloudflare-agents-durable-workflows-typescript)

Build stateful, long-running AI agents and resilient multi-step workflows using the Cloudflare Agents SDK, Durable Objects with embedded SQLite, WebSockets hibernation, and Workflows.

[![The Odin Project 7: Relational Databases, SQL Indexing & Drizzle ORM](https://cdn.sanity.io/images/hfh83o0w/production/8483b0d708ec8791707984ef7ed816a39777a89a-1376x768.png?w=1376&q=82&fit=max&auto=format)](/course/odin-databases-and-sql)November 4, 2026[![](/logos/tags/cloudflare-symbol-light.svg)![](/logos/tags/cloudflare-symbol-dark.svg)Cloudflare](/topic/cloudflare)[![](/logos/tags/sql-symbol-light.svg)![](/logos/tags/sql-symbol-dark.svg)SQL](/topic/sql)

### [The Odin Project 7: Relational Databases, SQL Indexing & Drizzle ORM](/course/odin-databases-and-sql)

Master relational schema normalization, Primary/Foreign keys, INNER/LEFT JOINs, B-Tree composite indexes, ACID transactions, and type-safe Drizzle ORM on Cloudflare D1.

[![The Zero-Cold-Start Edge Stack: Astro 7, Cloudflare Workers, D1 & Better-Auth](https://cdn.sanity.io/images/hfh83o0w/production/9f57c8f0566623ffe1d29af3a7fbbf6ebd77a4de-1376x768.png?w=1376&q=82&fit=max&auto=format)](/course/zero-cold-start-edge-stack)November 1, 2026[![](/logos/tags/cloudflare-symbol-light.svg)![](/logos/tags/cloudflare-symbol-dark.svg)Cloudflare](/topic/cloudflare)[![](/logos/tags/cloudflare-workers-symbol-light.svg)![](/logos/tags/cloudflare-workers-symbol-dark.svg)Cloudflare Workers](/topic/cloudflare-workers)

### [The Zero-Cold-Start Edge Stack: Astro 7, Cloudflare Workers, D1 & Better-Auth](/course/zero-cold-start-edge-stack)

Ship sub-10ms full-stack TypeScript web applications at the edge using Astro 7 Server Islands, Cloudflare Workers V8 Isolates, Cloudflare D1 SQLite, and self-hosted Better-Auth.

## SQL Blog Posts.

Showing 8 of 16 blog postsFiltered: SQL[Open Full Topic Hub →](/topic/sql)[![Realtime PostgreSQL: From Data Connect to SQL Connect in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/e37466f94f5a3bf43230dd809e34453e99828ee8-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2026-04-whats-new-sql-connect)April 30, 2026[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Realtime PostgreSQL: From Data Connect to SQL Connect in Firebase: Web Architecture & Implementation Guide](/post/firebase-2026-04-whats-new-sql-connect)

Alex Patterson's hands-on web engineering breakdown of "Realtime PostgreSQL: From Data Connect to SQL Connect" (2026-04-29). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Firestore levels up: Bringing the power of search and JOINs to NoSQL in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/b386f1f3d3b9d26306ac85f06b0a8e6cdafd1cea-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2026-04-firestore-pipelines-ga)April 28, 2026[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Firestore levels up: Bringing the power of search and JOINs to NoSQL in Firebase: Web Architecture & Implementation Guide](/post/firebase-2026-04-firestore-pipelines-ga)

Alex Patterson's hands-on web engineering breakdown of "Firestore levels up: Bringing the power of search and JOINs to NoSQL" (2026-04-27). Learn how to wire up Firebase, Google Cloud, Web Dev, AI in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Writing SQL in SQL Connect in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/c2d8e2107d9120829fe3c36a2173a68be8522829-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2026-03-fdc-native-sql)March 25, 2026[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Writing SQL in SQL Connect in Firebase: Web Architecture & Implementation Guide](/post/firebase-2026-03-fdc-native-sql)

Alex Patterson's hands-on web engineering breakdown of "Writing SQL in SQL Connect" (2026-03-24). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Introducing no-cost trials for Data Connect in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/38c94a9c7d5cae2648d4cdf2b84dcb84eeb2a0c1-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2026-03-fdc-ift)March 13, 2026[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Introducing no-cost trials for Data Connect in Firebase: Web Architecture & Implementation Guide](/post/firebase-2026-03-fdc-ift)

Alex Patterson's hands-on web engineering breakdown of "Introducing no-cost trials for Data Connect" (2026-03-12). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Data Connect: Event Triggers and Generated Admin SDKs in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/0b0ba7407b917ebfbf12ca4bbe281352ebc5ac22-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2025-11-dataconnect-nov25)November 18, 2025[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Data Connect: Event Triggers and Generated Admin SDKs in Firebase: Web Architecture & Implementation Guide](/post/firebase-2025-11-dataconnect-nov25)

Alex Patterson's hands-on web engineering breakdown of "Data Connect: Event Triggers and Generated Admin SDKs" (2025-11-17). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Firebase Firestore vs. Data Connect: Unlocking Your Data](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/5a2acf59d37c7dc7b5e5949448aac0d13cfa00aa-1920x1080.png?w=1920&q=82&fit=max&auto=format)](/post/firebase-firestore-vs-data-connect-unlocking-your-data-s-full-potential)October 19, 2025[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/sql-symbol-light.svg)![](/logos/tags/sql-symbol-dark.svg)SQL](/topic/sql)

### [Firebase Firestore vs. Data Connect: Unlocking Your Data's Full Potential](/post/firebase-firestore-vs-data-connect-unlocking-your-data-s-full-potential)

Explore Firebase Data Connect to enhance your app with powerful SQL capabilities, bridging the gap between real-time data and managing databases.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Transactions Updates for Data Connect in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a8f734d12f17873e1734cfc2c59e568ab1468175-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2025-06-dataconnect-transactions)June 6, 2025[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Transactions Updates for Data Connect in Firebase: Web Architecture & Implementation Guide](/post/firebase-2025-06-dataconnect-transactions)

Alex Patterson's hands-on web engineering breakdown of "Transactions Updates for Data Connect" (2025-06-05). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Server Value Expressions for Data Connect in Firebase: Web Architecture & Implementation Guide](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/8ca5284ba0e1ac2be92ef160fbbdf62543193a24-1200x630.svg?w=1200&q=82&fit=max&auto=format)](/post/firebase-2025-06-dataconnect-server-values)June 6, 2025[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/google-cloud-symbol-light.svg)![](/logos/tags/google-cloud-symbol-dark.svg)Google Cloud](/topic/google-cloud)

### [Server Value Expressions for Data Connect in Firebase: Web Architecture & Implementation Guide](/post/firebase-2025-06-dataconnect-server-values)

Alex Patterson's hands-on web engineering breakdown of "Server Value Expressions for Data Connect" (2025-06-05). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)

No matching blog posts found for this filter.

Try clearing the filter above to browse the full feed.

Loading more blog posts...✓ All blog posts loaded

## SQL Podcast Episodes.

Showing 2 of 2 episodesFiltered: SQL[Open Full Topic Hub →](/topic/sql)[![Firebase SQL with Data Connect](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/85d81ee02a09ff89d5cbb7b3644e8793d98b5c13-1920x1080.png?w=1920&q=82&fit=max&auto=format)](/podcast/firebase-sql-with-data-connect)October 28, 2025[![](/logos/firebase/firebase-symbol.png)![](/logos/firebase/firebase-symbol.png)Firebase](/topic/firebase)[![](/logos/tags/sql-symbol-light.svg)![](/logos/tags/sql-symbol-dark.svg)SQL](/topic/sql)

### [Firebase SQL with Data Connect](/podcast/firebase-sql-with-data-connect)

Firebase SQL with Data Connect how to use semantic searches with vector embeddings.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Tyler Crowe](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/432bde3e4b533ceccfe9c4d53bda13a1965020c8-500x500.jpg?w=96&h=96&q=82&fit=max&auto=format)Tyler Crowe](/guest/tyler-crowe)[![Enterprise Databases that Scale](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/bc1237eb727c0f9e14f914e6ce24f88d45e2dc40-1920x1080.jpg?w=1920&q=82&fit=max&auto=format)](/podcast/2-19-enterprise-databases-that-scale)May 11, 2022[![](/logos/tags/sql-symbol-light.svg)![](/logos/tags/sql-symbol-dark.svg)SQL](/topic/sql)[![](/logos/tags/database-symbol-light.svg)![](/logos/tags/database-symbol-dark.svg)Databases](/topic/database)

### [Enterprise Databases that Scale](/podcast/2-19-enterprise-databases-that-scale)

James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Brittney Postma](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/f25e504779cb6ebb7c0dd7df367f2c7490e17784-735x735.png?w=96&h=96&q=82&fit=max&auto=format)Brittney Postma](/author/brittney-postma)[![James Q Quick](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/bbb504849129a95ed2775009ba78cfc3452d1628-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)James Q Quick](/guest/james-q-quick)

No matching episodes found for this filter.

Try clearing the filter above to browse the full feed.

Loading more episodes...✓ All episodes loaded