Distributed SQL and YugabyteDB Fundamentals

Distributed SQL and YugabyteDB Fundamentals, available at Free, has an average rating of 4.5, with 38 lectures, 5 quizzes, based on 378 reviews, and has 4378 subscribers.

Free Enroll Now

You will learn about 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. This course is ideal for individuals who are Beginner or intermediate developers and DBAs new to distributed SQL It is particularly useful for Beginner or intermediate developers and DBAs new to distributed SQL.

Enroll now: Distributed SQL and YugabyteDB Fundamentals

Summary

Title: Distributed SQL and YugabyteDB Fundamentals

Price: Free

Average Rating: 4.5

Number of Lectures: 38

Number of Quizzes: 5

Number of Published Lectures: 38

Number of Published Quizzes: 5

Number of Curriculum Items: 43

Number of Published Curriculum Objects: 43

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

Beginner or intermediate developers and DBAs new to distributed SQL

Target Audiences

Beginner or intermediate developers and DBAs new to distributed SQL

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

Course Curriculum

Chapter 1: Welcome and Housekeeping

Lecture 1: Welcome and Housekeeping

Chapter 2: Terms and Definitions

Lecture 1: What is Distributed SQL and how does it compare to NoSQL

Lecture 2: Scaling Out

Lecture 3: Distributed ACID Transactions and Comparing SQL Systems

Lecture 4: What is YugabyteDB and comparing it to Google Spanner

Lecture 5: CAP Theorem and Raft Consensus Algorithim

Chapter 3: YugabyteDB Architecture

Lecture 1: YugabyteDB Components

Lecture 2: Architecture Overview

Lecture 3: YugabyteDB Services

Lecture 4: YB-TServer Service

Lecture 5: YB-Master Service

Lecture 6: DocDB Document Store

Lecture 7: Sharding Data

Lecture 8: Storage Layer

Lecture 9: Replicating Data

Lecture 10: Query Later Overview

Lecture 11: YSQL Overview

Lecture 12: YCQL Overview

Lecture 13: Node Count, Replication Factor & Fault Tolerance

Lecture 14: Cluster Deployment Configurations

Lecture 15: Network Partitions in Distributed Databases

Lecture 16: Secondary Indexes, Collocated Tables and Change Data Capture (CDC)

Chapter 4: YSQL API

Lecture 1: An Overview of PostgreSQL Architecture and How YugabyteDB Reuses Its Query Layer

Chapter 5: Exercises

Lecture 1: Installing a Single Node of YugabyteDB with yugabyted

Lecture 2: Installing a Local 3-Node YugabyteDB Cluster

Lecture 3: Install a 3 Node YugabyteDB Cluster on Google Kubernetes Engine

Lecture 4: The YugabyteDB Web UI

Lecture 5: Install the Northwind Sample Database

Lecture 6: Getting Started with DBeaver – DBA Tools

Lecture 7: Creating Databases, Schemas and Calling External Files

Lecture 8: Creating a Function

Lecture 9: Creating a Trigger

Lecture 10: User Management

Lecture 11: Fault Tolerance Demo Setup

Lecture 12: Fault Tolerance in Action

Lecture 13: Setting Up a TPCC Benchmark

Chapter 6: Course Review

Lecture 1: Course Review and Exam Prep

Chapter 7: Next Steps

Lecture 1: Exam Prep Guide, Exam, Certificate and Badge Informations

Instructors

Jimmy Guerrero
VP Developer Relations

Rating Distribution

1 stars: 1 votes

2 stars: 2 votes

3 stars: 37 votes

4 stars: 120 votes

5 stars: 218 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!