The intent of this guide is to give you an idea about the DBA landscape and to help guide your learning if you are confused. The roadmap is highly opinionated — neither, knowing everything listed in the roadmap, nor the order of items given in the roadmap is required to be followed in order to be a DBA. Learn basic RDBMS terms and concepts Get basic understanding of Postgres key terms and basic RDBMS concepts. Object model : data types, columns, rows, tables, schemas, databases, queries. Relational model : domains, attributes, tuples, relations, constraints, NULL. Databases high-level concepts : ACID, MVCC, transactions, write-ahead log, query processing. Links : Postgres Glossary SQL and Relational Theory - Christopher J. Date, 2009 Database Design and Relational Theory - Christopher J. Date, 2012 Learn how to install and run PostgreSQL Get practical skills of how to set up and run Postgres to get a working environment for further learning. Using package managers (APT, YUM, etc.) Us
Comments
Post a Comment