What you'll learn

Level: Beginner

As organizations build born-in-the-cloud applications using microservices, they seek a distributed SQL database that offers a high degree of SQL compatibility, is continuously available and resilient to failures, scales horizontally, and supports multiple geo-distributed cluster topologies. In this virtual training, you will learn about the key features of YugabyteDB, an open-source, distributed SQL database. This course examines features such sharding, replication, load balancing, linear scaling, continuous availability, and geo-distribution. You will also review YugabyteDB's pluggable API and how it is compatible with PostgreSQL.

Prerequisites

Wanted: Administrators, Developers, Architects, and Business Leaders

As an introductory course, we'll cover the key concepts and terminology of distributed SQL and YugabyteDB. So, bring your curiosity and and join us as we dig into the fundamentals of YugabyteDB. Experience with structured data, relational database systems, SQL, and Bash shell scripting is helpful, but not required.

Checklist

What you'll need

  • Operating System:
    macOS 10.12+, Ubuntu 16.04+, Docker, or Minikube 1.18+

  • Chromium web browser:
    Safari, Chrome, Opera, or Microsoft Edge

  • Third party tools:
    DBeaver, pgAdmin, or ysqlsh

  • Yugabyte Cloud free cluster

  • YugabyteDB public slack account

Course agenda

Duration: 90 minutes

  1. 01

    • Welcome!

    • Zoom Meeting Details

    • Zoom Recording
  2. 02

    • Introduction

    • Key Concepts and Terminology

    • YugabyteDB Architecture

    • YSQL API
  3. 03

    • Local Installation and Configuration

    • Lab: Create a Yugabyte Cloud Free cluster

    • Lab: Deploy the Northwind database from a local client (pgAdmin)

    • Fault Tolerance

    • Benchmarks

    • LAB: Run the TPC-C Benchmark
  4. 04

    • Next Steps

Proof of completion

Announce your achievement

Proof of Completion establishes your credentials and validates your expertise. By completing this course and by passing a course exam, you will receive a certificate of proof of completion. With a few clicks, you can easily add your digital certificate to your LinkedIn profile.
Proof of Completion

FAQs

The answers you seek

  • What is the cost?

    YugabyteDB University courses are FREE, so enroll today!

  • For this course, do I need to purchases a YugabyteDB software license?

    You do not need to purchase a YugabyteDB software license for this course. YugabyteDB is open source software.

    You can sign up for Yugabyte Cloud Free cluster without a credit card or payment method.

  • Do I need to sign up for a Yugabyte Cloud Free cluster?

    Yes!

    Most of our courses require a YugabyteDB cluster, so an on-demand Yugabyte Cloud cluster is a great option.

  • Sometimes I get stuck. How can I get help?

    If you get stuck, help is a literally a click away. In the Course Player header bar, select Discussions and post a question, concern, or even suggestion.

    We also have a #training channel on YugabyteDB Public Slack.

  • What do I receive for completing this course?

    A big THANK YOU from the team at Yugabyte University!

    More importantly, you will receive a course completion email and completion page, both of which include a link to take the course exam, if applicable. When you pass the course exam, you will receive a digital certificate of course completion.

  • Will I be able to review this course?

    Yes! We highly value your feedback and suggestions. Your review and rating helps pay it forward for our future students.

  • Will you email me a calendar invite and reminder?

    After you enroll, you will receive a calendar invitation. You will also receive an email reminding you to attend this virtual training.

  • Where are the Zoom webinar details?

    You will find the Zoom webinar details in the Course Player, in Welcome --> Zoom Details. In the table of contents, select this lesson and then select Start Zoom. That's it.

Your instructor

Seth will be your guide

Over 20 years ago, Seth started his career in data warehousing and database development at Microsoft. More recently, he has served as the leader of various technical training and professional certification programs for a variety of startups including Sitecore, Guidewire, SingleStore (formely MemSQL), and Incorta. In his career, Seth has delivered in-person and virtual training to over 10,000 administrators, architects, and developers worldwide.

As the Director of Yugabyte University, Seth strives to continually improve the curriculum, certification, and training programs. When not working, Seth enjoys hiking, biking, and swimming with his wife and two young boys in the California Bay Area. You can follow him on LinkedIn at :

Follow Seth

Seth Luersen

Director, Yugabyte University