/data-get-triggered-easily

Primary LanguagePLpgSQL

Data Expert: Get TRIGGERed easily

What you'll learn

  • How to manage events in SQL?
  • How to create functions and stored procedures in SQL (and what's the difference between them)?

Prerequisites

  • Programming basics
  • Being familiar with Git
  • The fundamentals of Relational Databases and SQL
  • Solid understanding of the basic CRUD operations in SQL (CREATE/INSERT, SELECT, UPDATE, DELETE/DROP)
  • Installed and running PostgreSQL Server (version 12 or higher)
  • A fork of the start repository

Tasks

1. Fork the repository

Create a fork of the start repository.

Criteria:

  • The repository is forked

2. Initialize

Initialize the database for the project.

Criteria:

  • A new database exists
  • The tables and data in the init.pgsql are in the database

Background materials