Table management

• Data types – cover the most commonly used PostgreSQL data types.

• Create table – guide you on how to create a new table in the database.

• Select Into & Create table as– shows you how to create a new table from the result set of a query.

• Auto-increment column with SERIAL – uses SERIAL to add an auto-increment column to a table.

• Sequences – introduce you to sequences and describe how to use a sequence to generate a sequence of numbers.

• Identity column – show you how to use the identity column.

• Alter table – modify the structure of an existing table.

• Rename table – change the name of the table to a new one.

• Add column – show you how to use add one or more columns to an existing table.

• Drop column – demonstrate how to drop a column of a table.

• Change column data type – show you how to change the data of a column.

• Rename column – illustrate how to rename one or more columns of a table.

• Drop table – remove an existing table and all of its dependent objects.

• Truncate table – remove all data in a large table quickly and efficiently.

• Temporary table – show you how to use the temporary table.

• Copy a table – show you how to copy a table to a new one.

• Insert – guide you on how to insert single row into a table.

• Insert multiple rows – show you how to insert multiple rows into a table.

• Update – update existing data in a table.

• Update join – update values in a table based on values in another table.

• Delete – delete data in a table.

• Upsert – insert or update data if the new row already exists in the table.

• Group By – divide rows into groups and applies an aggregate function on each.

• Having – apply conditions to groups.