Welcome to Production Database Tools — the module where you step outside the single relational database you have used so far and meet the wider data ecosystem that real companies run on. Up to now, every table you have queried lived in one engine: SQLite or PostgreSQL on one machine. Modern data teams almost never work that way. They spread data across cloud warehouses, document stores, caches, and graph engines, choosing the right tool for each job.

In this module you will get hands-on with three of the most in-demand production tools. You will load data into Snowflake, a cloud data warehouse that separates storage from compute so teams can scale up, scale down, and pause to control costs. You will then learn what NoSQL really means, meet its four main types — document, key-value, column-family, and graph — and develop the judgment to choose NoSQL or SQL for a given problem. Finally, you will build a real document database in MongoDB, evolve its schema without a single migration, run analytics with aggregation pipelines, and connect it to Python.

Everything here is practical and rooted in real queries, real output, and real architectural decisions that data engineers make every day. By the end, you will understand not just how to use these tools, but when and why each one is the right choice.

This is the final module of the SQL & Databases course. No new prerequisites are needed beyond the SQL you have already learned and a little comfort with Python. Start with Lesson 1, where you will run your first queries in a cloud data warehouse with Snowflake.