Database Tutorials

Our database tutorials provide well-structured learning paths for both SQL and NoSQL databases. Covering essential concepts, query languages, database design, and optimization techniques, our tutorials are suitable for both beginners and intermediate developers. With free labs and practical examples, you'll gain hands-on experience in database operations across different database systems.

Redis Pub/Sub Messaging

Redis Pub/Sub Messaging

In this lab, you will explore Redis's Pub/Sub messaging system. The lab guides you through the fundamental operations of subscribing to channels, publishing messages, and unsubscribing. You'll learn to use SUBSCRIBE, PUBLISH, UNSUBSCRIBE, and PSUBSCRIBE commands.

Manage MongoDB Embedded Docs

Manage MongoDB Embedded Docs

Learn advanced MongoDB techniques for handling nested documents, including creation, updating, querying, and managing complex data structures within a single document.

Group MongoDB Data

Group MongoDB Data

Learn powerful MongoDB aggregation techniques to group, analyze, and transform data using the $group operator with practical, hands-on examples.

Handle MongoDB Errors

Handle MongoDB Errors

Learn essential techniques for identifying, managing, and resolving common MongoDB errors to improve database reliability and performance.

Create MongoDB Indexes

Create MongoDB Indexes

Learn essential MongoDB indexing techniques to optimize database performance, improve query speed, and understand how to create, manage, and utilize different types of indexes.

Export MongoDB Data

Export MongoDB Data

Learn essential MongoDB data export techniques, including JSON and CSV exports, field selection, data formatting, and file verification for efficient database management.

Transform MongoDB Data

Transform MongoDB Data

Learn powerful MongoDB data transformation techniques using aggregation pipeline, including field selection, renaming, calculations, formatting, and filtering.

Query MongoDB Arrays

Query MongoDB Arrays

Learn advanced MongoDB querying techniques for arrays, including searching elements, using array operators, filtering by size, and matching specific array positions.

Summarize MongoDB Data

Summarize MongoDB Data

Learn essential MongoDB aggregation techniques to analyze and summarize data, including totals, counts, averages, and advanced reporting methods.

Import MongoDB Data

Import MongoDB Data

Learn essential techniques for importing JSON and CSV data into MongoDB, handling import errors, and verifying data integrity in this comprehensive hands-on lab.

Build MongoDB User Profiles

Build MongoDB User Profiles

Learn to design and implement flexible user profile schemas in MongoDB, exploring document structure, data modeling, and best practices for storing user information.

Handle MongoDB Arrays

Handle MongoDB Arrays

Learn advanced MongoDB array manipulation techniques, including adding, removing, updating, and querying array elements with practical, hands-on examples.

Design MongoDB Order Schema

Design MongoDB Order Schema

Learn to design a robust MongoDB order schema with customer details, order items, payment information, and status tracking for efficient e-commerce data management.

Update MongoDB Arrays

Update MongoDB Arrays

Learn advanced MongoDB array manipulation techniques, including adding, removing, and updating array elements with practical hands-on examples and real-world scenarios.

Structure MongoDB Product Data

Structure MongoDB Product Data

Learn to design efficient MongoDB document schemas for product catalogs, focusing on creating structured, flexible data models for e-commerce applications.

Filter MongoDB Collections

Filter MongoDB Collections

Learn advanced MongoDB query techniques to filter collections using comparison operators, regular expressions, and field existence checks.

Sort and Limit MongoDB Results

Sort and Limit MongoDB Results

Learn advanced MongoDB querying techniques to sort, limit, and filter database results efficiently using MongoDB shell commands.

Project MongoDB Fields

Project MongoDB Fields

Learn advanced MongoDB projection techniques to select, exclude, and format query results efficiently, mastering field selection and data transformation skills.

Prev
1
2
3
4
5
6
...
135
Next