EasyEnv
Engineering/Courses/Catalog/PostgreSQL/Creating Databases and Tables
PostgreSQL
IntermediateLesson 3 of 1430 min · hands-on

Creating Databases and Tables

Part of the PostgreSQL course

So far you have only looked around a server someone else set up. That is fine for learning the tools, but it does not get you anywhere on a real project: you need a place of your own to put data, and before you can put a single row anywhere, Postgres needs to know the shape of that data in advance. Which columns exist. What type each one holds. Whether a column is allowed to be left empty.

Connect as postgres and create a database to experiment in ...

Want to learn PostgreSQL Creating Databases and Tables in a real environment?

Click below, get a fresh Linux box with PostgreSQL ready to go, and work through Creating Databases and Tables hands-on with an AI tutor that knows your code.

Start this lessonCreating Databases and Tables

What you'll learn

  • CREATE DATABASE
  • CREATE TABLE
  • PRIMARY KEY
  • NOT NULL
  • DEFAULT
  • DROP TABLE
  • \d to inspect

Read this lesson in your language

All lessons in this course

14 lessons
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

Creating Databases and Tables - PostgreSQL (English) | Engineering Courses