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.

YugabyteDB Components1:53
Architecture Overview1:52
YugabyteDB Services1:17
YB-TServer Service0:34
YB-Master Service0:25
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
YSQL Overview0:51
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

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

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: