SQL Notebooks in VS Code - Demo & Tutorial (Step by Step - Detail) | Write SQL Like Jupyter Notebook

If you’ve ever wondered how SQL can be written, documented, and executed step-by-step like a Jupyter Notebook, this video is for you. In this video, I walk you through SQL Notebooks inside VS Code using the Oracle SQL Developer Extension. You’ll see how markdown, SQL code, and query results can live together in a single, interactive workflow — all inside VS Code. This is a game-changer for Oracle developers, APEX developers, and anyone working with SQL who wants a cleaner, more modern way to write and explain queries. 🎯 What You’ll Learn in This Video ✅ What a SQL Notebook is and how it works ✅ How SQL Notebooks are similar to Jupyter Notebooks ✅ Creating a SQL Notebook from scratch in VS Code ✅ Working with Markdown cells (titles, subtitles, bullets, bold, italic) ✅ Creating and executing SQL Code Cells ✅ Viewing query results directly below each cell ✅ Copying cells between notebooks ✅ Running queries step-by-step or using Run All ✅ Understanding breadcrumbs for easy navigation ✅ Why SQL Notebooks are ideal for: SQL analysis Debugging Reporting Documentation Version control with Git 💡 Why SQL Notebooks Matter Traditional SQL worksheets force you to: Scroll endlessly Switch tabs for results Lose context over time With SQL Notebooks: Your thought process, SQL, and output stay together Your work becomes self-documenting Your SQL becomes reusable and version-controlled Your workflow feels natural inside VS Code If you already understand SQL Notebooks, congratulations — you already understand the core idea behind Jupyter Notebooks as well. 🧩 Who Is This Video For? ✔ Oracle SQL Developers ✔ Oracle APEX Developers ✔ Beginners learning SQL ✔ Developers moving from SQL Developer to VS Code ✔ Anyone curious about modern SQL workflows No prior notebook knowledge is required. Chapters: 00:00 Demo of VS Code SQL Notebook 00:40 Channel Intro 00:47 What is a notebook? 01:04 Notebook Creation tutorial starts 01:24 Markdown cell creation 03:27 Cell Copy feature 03:44 Code cell creation 05:19 Advantages of SQL Notebook 06:27 Relation with Jupyter notebook 06:42 Breadcrumbs in Notebook 07:06 Playlist intro 07:17 Channel conclusion 📂 Playlist Information This video is part of my playlist: Modern Oracle SQL in VS Code, where we explore advanced and practical features of the Oracle SQL Developer Extension inside VS Code. More videos coming soon 👀 👍 Support the Channel If this video helped you: Like the video 👍 Drop your thoughts or questions in the comments 💬 Subscribe for more Oracle SQL, PL/SQL, and APEX content 🔔 Thanks for watching — see you in the next video!