Shared Databases

SQL and no-SQL

• https://martinfowler.com/bliki/NosqlDefinition.html (Novice)
• https://martinfowler.com/articles/nosqlKeyPoints.html (Novice)
• https://phoenixnap.com/kb/sql-vs-nosql (Novice)

Transactions

• https://en.wikipedia.org/wiki/Database_transaction (Novice)
• https://en.wikipedia.org/wiki/Isolation_(database_systems) (Advanced)
• https://www.postgresql.org/docs/current/transaction-iso.html (Advanced)
• https://www.tutorialspoint.com/dbms/dbms_concurrency_control.htm (Advanced)
• https://www.postgresql.org/docs/current/explicit-locking.html (Advanced)
• https://www.tutorialspoint.com/dbms/dbms_deadlock.htm (Advanced)

ACID

• https://www.tutorialspoint.com/dbms/dbms_transaction.htm (Intermediate)
• https://en.wikipedia.org/wiki/ACID (Intermediate)

CAP

• https://en.wikipedia.org/wiki/CAP_theorem (Intermediate)
• https://en.wikipedia.org/wiki/Fallacies_of_distributed_computing (Intermediate)
• https://hub.packtpub.com/the-cap-theorem-in-practice-the-consistency-vs-availability-trade-off-in-distributed-databases/ (Intermediate)

PACELC

• https://en.wikipedia.org/wiki/PACELC_theorem (Advanced)

BASE

• https://phoenixnap.com/kb/acid-vs-base (Advanced)
• https://en.wikipedia.org/wiki/Eventual_consistency (Advanced)

Database Replication

• https://vladmihalcea.com/single-primary-database-replication/ (Intermediate)
• https://searchdatamanagement.techtarget.com/definition/database-replication (Advanced)
• https://microservices.io/patterns/data/saga.html (Advanced)
• https://developers.redhat.com/blog/2018/10/01/patterns-for-distributed-transactions-within-a-microservices-architecture/ (Advanced)

Database Partitioning and Sharding

• https://en.wikipedia.org/wiki/Partition_(database) (Intermediate)
• https://en.wikipedia.org/wiki/Shard_(database_architecture) (Intermediate)
• https://www.digitalocean.com/community/tutorials/understanding-database-sharding (Advanced)
• https://www.freecodecamp.org/news/understanding-database-scaling-patterns/ (Advanced)

SQL

• https://www.w3schools.com/sql/sql_syntax.asp (Novice)
• https://www.geeksforgeeks.org/cte-in-sql/ (Intermediate)

Relational Algebra

• https://www.postgresqltutorial.com/postgresql-joins/ (Intermediate)
• https://en.wikipedia.org/wiki/Relational_algebra (Advanced)

SQL scripts

• https://www.postgresql.org/docs/current/plpgsql.html (Intermediate)

Relational Databases Basics

• https://en.wikipedia.org/wiki/Relational_database (Novice)

Data Normalization

• https://en.wikipedia.org/wiki/Database_normalization (Intermediate)

Indexes

• https://www.geeksforgeeks.org/indexing-in-databases-set-1/ (Novice)
• https://en.wikipedia.org/wiki/Database_index (Novice)
• https://www.tutorialspoint.com/dbms/dbms_indexing.htm (Advanced)

Postgres Features

• https://www.postgresql.org/docs/13/intro-whatis.html (Intermediate)
• https://dzone.com/articles/postgresql-connection-pooling-part-4-pgbouncer-vs (Advanced)
• https://www.percona.com/blog/2019/05/24/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/#:~:text=In%20fact%2C%20PostgreSQL%20has%20implemented,PostgreSQL%20for%20a%20long%20time (Advanced)

MySql and MariaDB

• https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html (Intermediate)

TimeScale DB

• https://docs.timescale.com/latest/introduction (Advanced)
• https://blog.timescale.com/blog/time-series-data-why-and-how-to-use-a-relational-database-instead-of-nosql-d0cd6975e87c/#2362 (Advanced)
• https://blog.timescale.com/blog/building-columnar-compression-in-a-row-oriented-database/ (Advanced)

NoSQL – MongoDB

• https://docs.mongodb.com/manual/tutorial/getting-started/ (Intermediate)

NoSQL – Neo4j

• https://neo4j.com/developer/get-started/ (Advanced)

ElasticSearch

• https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html (Intermediate)

Redis

• https://aws.amazon.com/ru/redis/ (Novice)
• https://redis.io/documentation (Intermediate)
• https://redislabs.com/redis-best-practices/introduction/ (Advanced)

ClickHouse

• https://clickhouse.tech/docs/en/ (Intermediate)

Cassandra

• https://cassandra.apache.org/doc/latest/architecture/overview.html (Advanced)

InfluxDB

• https://docs.influxdata.com/influxdb/v2.0/get-started/ (Advanced)

RMQ

• https://www.rabbitmq.com/getstarted.html (Intermediate)

NATS

• https://docs.nats.io/ (Advanced)
• https://docs.nats.io/compare-nats (Advanced)

Kafka

• https://otonomo.io/redis-kafka-or-rabbitmq-which-microservices-message-broker-to-choose/ (Advanced)
• https://kafka.apache.org/documentation/ (Advanced)
• https://cwiki.apache.org/confluence/display/KAFKA/Kafka+Streams (Advanced)

Apache Spark

• https://spark.apache.org/docs/3.1.1/ (Advanced)

Presto.db

• https://prestodb.io/docs/current/overview/use-cases.html (Advanced)