IT & Software Other IT & Software Database Management

Distributed SQL and YugabyteDB Fundamentals

Learn the core concepts of distributed SQL, put them into practice using YugabyteDB and take the certification exam
Rating: 4.6 out of 5 (65 ratings)
992 students
Created by Jimmy Guerrero
English
English [Auto]
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.

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

Course content

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

  • Welcome and Housekeeping
    02:45

Instructor

Jimmy Guerrero
VP Developer Relations
Jimmy Guerrero
  • 4.6 Instructor Rating
  • 65 Reviews
  • 996 Students
  • 1 Course

I have working in open source and data infrastructure for over 20 years. Prior to joining YugabyteDB, I held various positions at InfluxDB, Oracle, MySQL and was a founding member of the Red Hat OpenShift team. Recently, my primary emphasis has been on community building, training and developing technical integrations.