Distributed SQL and YugabyteDB Fundamentals

Discover the defining characteristics of distributed sql, including sql api compatibility, automatic distributed data storage, strong consistency, distributed query execution, and asset transactions, and compare it to nosql.

Learn how distributed databases scale out by sharding data across four nodes with replication, enabling horizontal cloud elasticity and resilience when nodes fail, in contrast to scale-up monolithic databases.

Explore distributed ACID transactions and how distributed SQL coordinates multi-node execution and automatic distributed data storage to guarantee atomicity, consistency, isolation, and durability, with comparisons like MySQL, PostgreSQL, SQL Server.

Explore YugabyteDB, an open source distributed SQL database inspired by Google Spanner, with PostgreSQL compatibility, cloud native design, and features like stored procedures, triggers, and UDS.

Explore the cap theorem, network partitions, and how Yugabyte's Raft consensus algorithm (Paxos-equivalent) maintains tablet peers, replication factor, and shard consistency while balancing availability.

Explore YugabyteDB architecture by examining nodes, clusters, including primary and read replica clusters, with synchronous intra-cluster replication and asynchronous cross-cluster replication.

Explore YugabyteDB architecture, including the query layer with a YSQL API and a PostgreSQL-compatible API, and a RocksDB-based storage layer with document storage, sharding, raft consensus, and distributed asset transactions.

Identify two YugabyteDB services: the tablet server that hosts data, and the YV master service that stores cluster metadata, and understand how they form the data and control layers.

Discover how the YB-TServer service hosts and serves data, with tables split into tablets (shards) that are synchronously replicated to form a raft group with a leader and followers.

Explore the master service that manages system metadata and tracks tables, tablets, nodes, and clusters, coordinating backups and load balancing while enabling create and drop table operations.

Explore docdb document store as storage layer enabling transactions, sharding, replication, persistence, and tunable read consistency, built on a customized Rock CDB, delivering strong resilience across zones, regions, and clouds.

Explore how the storage layer uses a primary key with hash and ordering components to ensure row uniqueness, and see a sharding example on sample data.

Explore query layer where query and command compilation occur, along with data type representations, the statement cache for prepared statements, and access via the Y Eskil API and Y sequel.

Explore the YSQL API in YugabyteDB, a PostgreSQL-compatible interface designed for relational workloads with scale-out resilience, geographic distribution, and features like foreign keys, joins, distributed transactions, and triggers.

Explore the YCQL overview for semi relational workloads and how it enables massive data ingestion, blazing queries, and distributed transactions with native JSON and strongly consistent secondary indexes.

Discover how node counts and replication factors shape YugabyteDB cluster fault tolerance and data correctness, using RF = 2 times the number of nodes plus 1 to survive node failures.

Explore how distributed databases handle network partitions under cap theorem, showing a four-node cluster where the majority maintains reads and writes while the minority halts to preserve consistency over availability.

Explore strongly consistent secondary indexes for fast lookups and unique value enforcement, collocated tables for efficient sharding, and change data capture to publish changes to Kafka.

Demonstrates fault tolerance on a local three-node YugabyteDB cluster, balancing reads and writes, removing and restoring a node, and adding a fourth node to illustrate horizontal scaling.

Download the Java load generator, run reads and writes on a three-node YugabyteDB cluster, and monitor balanced load via the web UI on localhost:7000 while simulating node failures and rebalancing.

Explore a benchmarking overview and run the TPK benchmark against a Yaqoubi cluster, loading 10 warehouses on a 3-node setup, and inspect the CSV output.

Review distributed sql concepts, YugabyteDB architecture, and exam-ready topics like PostgreSQL-compatible YSQL API, sharding, replication, Raft consensus, and distributed transactions for fault-tolerant, strongly consistent queries.

Access certification prep guide, learn the 37-question exam with an 80% pass mark, retake as needed, and receive your certificate and badge within 24–48 hours via the YugabyteDB community Slack.