Creating a database

Creare database PostgreSQL

Darryl Reeves

Industry Assistant Professor, New York University

Course topics

Commands for building databases
PostgreSQL data types
Database normalization
Database access management

The PostgreSQL Database Management System

object-relational database management system
system components are objects
database is top-level object

The CREATE DATABASE command

CREATE DATABASE db_name;

CREATE DATABASE my_db;

CREATE DATABASE _my_db;

CREATE DATABASE 321_db; -- Invalid

Scenarios for new database creation

CREATE DATABASE ncaa_bb;

CREATE DATABASE auto_depot;

CREATE DATABASE pod;

Let's practice!

Creare database PostgreSQL

Preparing Video For Download...