数据库 免费实践教程

July 1, 2026 · View on GitHub

支持语言: English · 简体中文 · 日本語 · Español · Français · Deutsch · Русский · 한국어 · Português

数据库

通过专为初学者设计的综合学习路径学习数据库。本路线图提供实践性的数据库课程,助您掌握 MySQL、Redis、MongoDB 和 PostgreSQL 等流行系统。它提供结构化学习,涵盖不同数据库类型的基本概念、数据库设计和管理。通过交互式数据库演练场中的实践练习,获得数据库管理和查询的真实世界经验。

在 LabEx 浏览教程

序号教程难度练习
01SQLite Constraint Management初级View
02验证 PostgreSQL 连接详情中级View
03创建你自己的食谱数据库中级View
04Redis 的安装与初始设置初级View
05Basic Key-Value Operations in Redis初级View
06Introduction to Redis Data Structures初级View
07Redis 高级键管理初级View
08Redis 哈希操作初级View
09Redis 列表操作初级View
10Redis 集合操作初级View
11Redis 有序集合操作初级View
12验证 Redis 服务状态中级View
13在 Redis 缓存中设置键的过期时间中级View
14在 Linux 中设置 SQLite初级View
15Building Tables in SQLite初级View
16Creating and Managing SQLite Databases初级View
17PostgreSQL Views Management初级View
18SQLite Data Grouping初级View
19SQLite Index Optimization初级View
20SQLite Subquery Techniques初级View
21SQLite Table Joining初级View
22SQLite Transaction Handling初级View
23SQLite Trigger Automation初级View
24在 Linux 上安装并验证 SQLite中级View
25在 SQLite 中插入用户数据中级View
26Database Management Basics with PostgreSQL初级View
27How to start PostgreSQL in Kali Linux初级View
28创建你的第一个 MySQL 数据库初级View
29Create a Product Catalog Table中级View
30MySQL 基本数据操作初级View
31MySQL 表结构与数据类型初级View
32MySQL 数据库管理基础初级View
33Installation and Basic Configuration of MySQL初级View
34Your First MongoDB Lab初级View
35Create MongoDB Collection初级View
36Insert Data in MongoDB初级View
37Delete MongoDB Data初级View
38Update MongoDB Records初级View
39优秀学生名单追踪器中级View
40填充学生集合数据中级View
41探索 MySQL 系统表初级View
42PostgreSQL Table Creation and Data Types初级View
43MySQL Functions and Custom Logic初级View
44MySQL Indexes and Performance Optimization初级View
45MySQL Stored Procedures Basics初级View
46MySQL Subqueries and Nested Operations初级View
47MySQL Transactions and Data Integrity初级View
48MySQL Triggers for Automation初级View
49MySQL Views and Virtual Tables初级View
50PostgreSQL Advanced Data Types初级View
51PostgreSQL Advanced Query Writing初级View
52PostgreSQL Index Optimization初级View
53PostgreSQL 关系与连接初级View
54PostgreSQL 角色与权限管理初级View
55PostgreSQL Transaction Management初级View

在 LabEx 查看更多

About LabEx

LabEx is a hands-on learning platform for beginners.

Explore Linux, DevOps, Cybersecurity, and more — all directly in your browser.

Learn step by step through interactive labs, guided exercises, and real-world projects. 🌱
No setup, no stress — just practice and grow your skills by doing.


Download on the App Store Download on the Mac App Store


📖 Need help? Visit our Help Center or email info@labex.io