MotherDuck tutorial

This comprehensive guide will take you from your first query to sharing databases with your team.

What you'll learn

This tutorial is in 3 parts, you'll discover how to:

• 🔍 1. Query shared data - Run your first SQL queries on publicly available datasets
• 📊 2. Load your own data - Upload and work with your own data from files and datasets
• 🤝 3. Share databases - Collaborate by sharing databases with team members

tip

Each part of this tutorial builds on the previous one, but you can also jump to specific sections if you're looking to learn particular features.

Prerequisites

To follow this tutorial, you'll need:

• A MotherDuck account (sign up for free)
• Basic SQL knowledge (we'll guide you through the queries)
• You have several ways to run the queries:
  • Execute them directly on this documentation website 🪄
  • Use the MotherDuck UI for the full interface experience
  • Connect with any DuckDB client(Python, Java, DuckDB CLI) of your choice

⏱️ Estimated time: 20-30 minutes for the complete tutorial

Let's get started! 🚀