We have finally gotten our feet wet creating database objects.

    CREATE data_obj data_name [code];

    CREATE DATABASE db_name; -- no extra code

    CREATE SCHEMA schema_name; -- no extra code

    CREATE TABLE table_name -- code for structure
      (
      field1 data_type [arguments],
      field2 data_type [arguments]
      );

    CREATE VIEW view_name -- code for structure
    AS
    SELECT field1,
      field2
    FROM table1;

Download the class notes for day 6.