- 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?
- 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
Fork the repository with the initializer scripts.
Criteria:
- The repository is forked
Initialize the database for the project.
Criteria:
- A new database exists
- The tables and data in the
init.pgsql
are in the database
- ๐ 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