labex-labs/postgresql-for-beginners
In this course, learn PostgreSQL basics from installation to data operations, including database management, table creation, and simple queries.
PostgreSQL for Beginners
Languages
🇨🇳 简体中文 🇪🇸 Español 🇫🇷 Français 🇩🇪 Deutsch 🇯🇵 日本語 🇷🇺 Русский 🇰🇷 한국어 🇧🇷 Português 🇺🇸 English
In this course, learn PostgreSQL basics from installation to data operations, including database management, table creation, and simple queries.
Exercises
| Index | Name | Difficulty | Practice |
|---|---|---|---|
| 01 | 🧩 🆓 Installation and Initial Setup of PostgreSQL | Intermediate | Start Lab |
| 02 | 🎯 🆓 Verify PostgreSQL Connection Details | Beginner | Start Challenge |
| 03 | 🧩 🆓 Database Management Basics with PostgreSQL | Beginner | Start Lab |
| 04 | 🎯 🆓 Create Your Own Recipe Database | Beginner | Start Challenge |
| 05 | 🧩 🆓 PostgreSQL Table Creation and Data Types | Intermediate | Start Lab |
| 06 | 🎯 Create Employee Table in PostgreSQL | Beginner | Start Challenge |
| 07 | 🧩 Basic Data Operations in PostgreSQL | Beginner | Start Lab |
| 08 | 🎯 Manage Employee Data in PostgreSQL | Beginner | Start Challenge |
| 09 | 🧩 Data Filtering and Simple Queries in PostgreSQL | Beginner | Start Lab |
| 10 | 🎯 Find Marketing Employees in PostgreSQL | Beginner | Start Challenge |
About LabEx
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. With a strict 'Learn by Doing' approach, interactive online environments in the browser with automated step-by-step checks, structured content organization through the Skill Tree learning system, and a growing resource of 30 Skill Trees and over 6,000 Labs, LabEx offers comprehensive practical education. The platform includes Labby, an AI learning assistant built on latest AI models, providing a conversational learning experience.