workshop-postgres-intro

Introduction to PostgreSQL

Introduction to PostgreSQL for programmers

Details：

This workshop is ideal for developers who interact with databases and build schema in their daily work and who want to know more about PostgreSQL. Those developers used to other RDBMS (like MySQL) should be particularly interested.

• We will learn how to use special type of PostgreSQL

  • JSON
  • Array
  • UUID

• We will check how to use some basic PostgreSQL only features

  • Inheritance
  • Type constraint
  • Trigger
  • Procedure creation
  • Plpgsql the PostgreSQL procedural language

• We will create our own database schema based on StackOverflow