Creating a database

Creating PostgreSQL Databases

Darryl Reeves

Industry Assistant Professor, New York University

Course topics

  • Commands for building databases
  • PostgreSQL data types
  • Database normalization
  • Database access management
Creating PostgreSQL Databases

The PostgreSQL Database Management System

  • object-relational database management system
  • system components are objects
  • database is top-level object
Creating PostgreSQL Databases

The CREATE DATABASE command

CREATE DATABASE db_name;

CREATE DATABASE my_db;

CREATE DATABASE _my_db;

CREATE DATABASE 321_db; -- Invalid
Creating PostgreSQL Databases

Scenarios for new database creation

CREATE DATABASE ncaa_bb;

CREATE DATABASE auto_depot;

CREATE DATABASE pod;
Creating PostgreSQL Databases

Let's practice!

Creating PostgreSQL Databases

Preparing Video For Download...