Topics

Browse practical tutorials, guides, and examples for MongoDB, PostgreSQL, MySQL, Oracle, Redis, and other databases supported by VisuaLeaf.

Start with a specific database below, or explore the MongoDB sections for more focused guides on queries, aggregations, schema design, performance, visualization, and tools.

---

🗂️ Browse by Database

Find tutorials and practical workflows for the database you use.

MongoDB

Explore all MongoDB tutorials, from basic queries and aggregation pipelines to schema design, indexes, sharding, automation, and database administration.

PostgreSQL

Find practical PostgreSQL guides covering SQL, JSONB, indexes, query plans, schema design, performance, and database management.

MySQL

Learn how to work with MySQL tables, queries, joins, JSON columns, ER diagrams, execution plans, charts, and other everyday database tasks.

Oracle

Explore Oracle Database tutorials covering SQL, PL/SQL, packages, procedures, triggers, schema diagrams, and table management.

DuckDB

Learn how to use DuckDB for local data analysis, including querying CSV and Parquet files, exploring tables, working with nested data, and creating charts.

Redis

Find practical Redis guides covering safe key browsing, SCAN, TTLs, data types, scripts, security, and database management.

---

📊 MongoDB Query & Aggregation

Learn how to filter, group, search, and transform MongoDB data. These guides explain the logic behind queries and aggregation pipelines through practical examples.

Aggregation Pipeline

Understand MongoDB aggregation pipelines step by step, from simple filtering to grouping, reshaping, and combining data across collections.

MongoDB Query

Learn how to write MongoDB queries that filter, search, sort, and retrieve the exact documents you need.

MongoDB Shell

Use the MongoDB shell to run queries, execute scripts, test changes, automate repetitive work, and inspect your data directly.

---

🧱 MongoDB Schema & Data Modeling

Understand how MongoDB data is structured, how collections relate to each other, and how to design schemas that remain clear as an application grows.

MongoDB Schema

Explore MongoDB schema design, embedded and referenced data, validation rules, relationships, and ways to visualize existing collections.

---

📈 MongoDB Data Visualization

Turn MongoDB data into views, charts, and dashboards that make results, patterns, and trends easier to understand.

MongoDB Charts

Learn how to turn MongoDB query and aggregation results into charts that are easier to explore, present, and explain.

MongoDB Dashboard

Explore how to combine multiple MongoDB charts into dashboards for monitoring data, metrics, and business activity.

MongoDB Views

Understand how table, tree, and JSON views can help you inspect MongoDB documents and query results more clearly.

---

⚙️ MongoDB Performance & Optimization

Learn how to investigate slow queries, improve performance, and understand how MongoDB executes operations.

MongoDB Indexes

Learn how MongoDB indexes improve query speed, how to choose useful indexes, and how to inspect query execution plans.

MongoDB Technical Articles

Explore deeper MongoDB topics including architecture, performance, replication, sharding, transactions, and production troubleshooting.

---

🔐 MongoDB Security & Administration

Understand the features used to manage database access, permissions, users, and administrative workflows.

MongoDB RBAC

Learn how MongoDB users, roles, permissions, and role-based access control work through practical administration examples.

---

🧰 MongoDB Tools & Alternatives

Compare MongoDB tools and discover workflows that make querying, visualization, administration, and everyday database work easier.

MongoDB Tools

Explore MongoDB GUIs, visual query builders, Compass alternatives, shell tools, and database management platforms.