Data Expert: The Chemistry of SQL: ACID

What you'll learn

• What are the very basics of Normalization?
• How to create VIEWs?
• What are Transactions? What is ACID?
• How to use these concepts for Database Refactoring?

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

Fork the repository with the initializer scripts.

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

• 📖 Introduction to Databases and SQL
• 📖 Setting up a local PostgreSQL database
• ❗ PosgreSQL: Views
• ❗ PosgreSQL: Transactions
• 🎥 Database Transactions & ACID
• 🎥 Database Normalization
• 📕 Refactoring Databases: Evolutionary Database Design
• 🎥 Git in 100 seconds
• 🎥 Git Fork vs. Git Clone
• 🎥 Basics of Coding