Database Tutorial

Aikesheng Open Source Community

Oct 26, 2023 · Databases

SQL Learning Course Outline and Book Giveaway Announcement

This announcement details a book giveaway sponsored by Tsinghua University Press and presents a comprehensive SQL learning curriculum covering SQLite, MySQL, query fundamentals, subqueries, joins, and advanced database features, complete with micro‑lecture videos and hands‑on exercises.

DatabaseDatabase TutorialMySQL

0 likes · 9 min read

Ops Development Stories

Apr 5, 2020 · Databases

Master MongoDB: From Basics to Advanced Operations

This comprehensive guide introduces MongoDB, explains NoSQL classifications, walks through Windows and Linux installations, demonstrates using the Robo 3T GUI, and covers essential CRUD operations, queries, indexing, sorting, counting, and data deduplication with clear code examples and screenshots.

CRUD OperationsData QueryDatabase Tutorial

0 likes · 27 min read

Master MongoDB: From Basics to Advanced Operations

Java Captain

Aug 7, 2019 · Databases

Practical Guide to Group, Join, and CASE WHEN Queries in SQL

This article provides a beginner‑friendly, step‑by‑step tutorial on common SQL operations—including GROUP BY aggregation, JOIN types, CASE WHEN expressions, and useful built‑in functions—illustrated with clear examples, typical pitfalls, and ready‑to‑use code snippets.

Database TutorialGROUP BYJoin

0 likes · 10 min read

Practical Guide to Group, Join, and CASE WHEN Queries in SQL