🇨🇳 简体中文 🇪🇸 Español 🇫🇷 Français 🇩🇪 Deutsch 🇯🇵 日本語 🇷🇺 Русский 🇰🇷 한국어 🇧🇷 Português 🇺🇸 English
In this course, master PostgreSQL through hands-on labs covering relationships, advanced data types, indexing, transactions, views, permissions, queries, triggers, backups, partitioning, full-text search, and more.
| Index | Name | Difficulty | Practice |
|---|---|---|---|
| 01 | 📖 🟢 PostgreSQL Relationships and Joins | Beginner | Start Lab |
| 02 | 📖 🟢 PostgreSQL Advanced Data Types | Beginner | Start Lab |
| 03 | 📖 🟢 PostgreSQL Index Optimization | Beginner | Start Lab |
| 04 | 📖 🟢 PostgreSQL Transaction Management | Beginner | Start Lab |
| 05 | 📖 🟢 PostgreSQL Views Management | Beginner | Start Lab |
| 06 | 📖 🔵 PostgreSQL Role and Permission Management | Beginner | Start Lab |
| 07 | 📖 🔵 PostgreSQL Advanced Query Writing | Beginner | Start Lab |
| 08 | 📖 🔵 PostgreSQL Trigger Automation | Beginner | Start Lab |
| 09 | 📖 🔵 PostgreSQL Backup and Restore | Beginner | Start Lab |
| 10 | 📖 🔵 PostgreSQL Table Partitioning | Beginner | Start Lab |
| 11 | 📖 🔵 PostgreSQL Full-Text Search | Beginner | Start Lab |
| 12 | 📖 🔵 PostgreSQL Stored Function Development | Beginner | Start Lab |
| 13 | 📖 🔵 PostgreSQL Date and Time Operations | Beginner | Start Lab |
| 14 | 📖 🔵 Using the PostGIS Extension in PostgreSQL | Beginner | Start Lab |
| 15 | 📖 🔵 PostgreSQL Database Maintenance | Beginner | Start Lab |
| 16 | 📖 🔵 PostgreSQL Streaming Replication | Beginner | Start Lab |
| 17 | 📖 🔵 PostgreSQL Error Handling | Beginner | Start Lab |
| 18 | 📖 🔵 PostgreSQL Event Trigger Setup | Beginner | Start Lab |
| 19 | 📖 🔵 PostgreSQL PgBouncer Connection Pooling | Beginner | Start Lab |
| 20 | 📖 🔵 PostgreSQL JSON/JSONB Advanced Operations | Beginner | Start Lab |
LabEx is an interactive, hands-on learning platform dedicated to coding and technology. It combines labs, AI assistance, and virtual machines to provide a no-video, practical learning experience.
- A strict "Learn by Doing" approach with exclusive hands-on labs and no videos.
- Interactive online environments within the browser, with automated step-by-step checks.
- A structured content organization with the Skill Tree based learning system.
- A growing learning resource of 30 Skill Trees and over 6,000 Labs.
- The learning assistant Labby, built on lastest AI models, providing a conversational learning experience.
Learn more about LabEx VM.