Distributed SQL and YugabyteDB Fundamentals

Name: Distributed SQL and YugabyteDB Fundamentals
Rating: 4.6 (444 reviews)

Learn the core concepts of distributed SQL, put them into practice using YugabyteDB and take the certification exam

Created byJimmy Guerrero

Last updated 1/2021

English

What you'll learn

This course will teach you the core concepts of distributed SQL.
What makes distributed SQL different from monolithic databases like Oracle, SQL Server and MySQL.
A deep dive into YugabyteDB architecture.
Exercises that show you how to install, develop, fail over and benchmark YugabyteDB.
Everything you need to know to prepare for the YugabyteDB Fundamentals Certification exam.

Course content

7 sections • 38 lectures • 1h 6m total length

Welcome and Housekeeping2:45
In this lecture you will meet your instructor, get a course overview, get answers to common questions about the course and review the technical prerequisites.

What is Distributed SQL and how does it compare to NoSQL4:55
Scaling Out3:23
Distributed ACID Transactions and Comparing SQL Systems3:16
What is YugabyteDB and comparing it to Google Spanner2:18
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.
CAP Theorem and Raft Consensus Algorithim2:59
Terms and Definitions Quiz

YugabyteDB Components1:53
Architecture Overview1:52
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.
YugabyteDB Services1:17
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.
YB-TServer Service0:34
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.
YB-Master Service0:25
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.
YugabyteDB Architecture and Services
DocDB Document Store0:51
Sharding Data0:34
Storage Layer0:28
Replicating Data1:10
Sharding and Replicating Data
Query Later Overview0:58
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.
YSQL Overview0:51
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.
Reviewing APIs
YCQL Overview0:45
Node Count, Replication Factor & Fault Tolerance1:20
Cluster Deployment Configurations1:15
Network Partitions in Distributed Databases1:41
Secondary Indexes, Collocated Tables and Change Data Capture (CDC)2:10
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.

Installing a Single Node of YugabyteDB with yugabyted0:42
In this demo we'll show you how to install a local, single node YugabyteDB cluster using the yugabyted utility.
For additional info, check out: https://download.yugabyte.com/
Installing a Local 3-Node YugabyteDB Cluster0:33
In this demo we'll show you how to install a local, 3-node YugabyteDB cluster using the yb-ctl utility.
For additional info, check out: https://docs.yugabyte.com/latest/admin/yb-ctl/
Install a 3 Node YugabyteDB Cluster on Google Kubernetes Engine1:11
In this demo we'll show you how to install a 3-node YugabyteDB cluster on Google Kubernetes Engine using helm.
For additional info, check out: https://docs.yugabyte.com/latest/deploy/kubernetes/single-zone/gke/helm-chart/
The YugabyteDB Web UI0:38
In this demo we'll show you how to navigate the YugabyteDB web UI. If you performed a local install, you can access the UI at:
http://127.0.0.1:7000/
For additional info, check out: https://docs.yugabyte.com/latest/quick-start/create-local-cluster/macos/
Install the Northwind Sample Database0:41
In this demo we'll show you how to install the Northwind sample database.
For additional info, check out: https://docs.yugabyte.com/latest/sample-data/northwind/
Getting Started with DBeaver - DBA Tools1:23
In this demo we'll show you how to configure DBeaver, a free database administration tool to work with YugabyteDB.
For additional info, check out: https://dbeaver.io/
Creating Databases, Schemas and Calling External Files1:04
In this demo we'll show you how to create databases, schemas and call external files. You'll notice the workflow and syntax is identical to PostgreSQL.
Creating a Function0:28
In this demo we'll show you how to create a function that counts the number of rows in a table and accepts a table name as a parameter. You'll notice the workflow and syntax is identical to PostgreSQL.
Creating a Trigger1:33
In this demo we'll show you how to audit changes to data using a trigger that is called whenever someone changes the name of a customer. You'll notice the workflow and syntax is identical to PostgreSQL.
User Management0:29
In this demo we'll show you how create, alter and drop users. You'll notice the workflow and syntax is identical to PostgreSQL.
Fault Tolerance Demo Setup2:10
Fault Tolerance in Action3:26
Setting Up a TPCC Benchmark1:50
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.

Requirements

Basic understanding of how traditional RDBMS work.

Description

This course will teach you the core concepts of distributed SQL and what makes it different from monolithic databases like Oracle, SQL Server PostgreSQL and MySQL. Through lectures and hands-on exercises you'll develop the knowledge and skills to configure and get started with YugabyteDB. Over the span of 90 minutes we'll covered the following topics in-depth:

Distributed SQL terms, definitions, and comparisons
YugabyteDB architecture and design principles
YSQL API development
Course review and exam prep

We also worked through a variety of hands-on exercises including:

Single and multi-node cluster installs on Mac, Linux, and Kubernetes
JDBC connectivity
User management and basic security
Working with databases and schemas
Creating objects and loading data from external files
Creating and exploring a sample database
Creating functions and triggers
Setting up admin tools like pgAdmin, TablePlus, and DBeaver
Using a Java load generator
Testing fault tolerance (remove node, add node, rebalancing)
TPC-C benchmarking

Who this course is for:

Beginner or intermediate developers and DBAs new to distributed SQL

Distributed SQL and YugabyteDB Fundamentals

What you'll learn

Explore related topics

Course content

Welcome and Housekeeping1 lecture • 3min

Terms and Definitions5 lectures • 17min

YugabyteDB Architecture16 lectures • 18min

YSQL API1 lecture • 4min

Exercises13 lectures • 16min

Course Review1 lecture • 7min

Next Steps1 lecture • 2min

Requirements

Description

Who this course is for: