What you'll learn

Level: Intermediate

As a distributed PostgreSQL-compatible database, YugabyteDB has a ton of similarities and a few differences when compared to open-source Postgres. YugabyteDB does behave and look like Postgres in runtime which allows you to reuse most optimization techniques you've already mastered with Postgres. At the same time, YugabyteDB is a distributed database that can store your data across multiple geographies and use thousands of CPUs distributed across hundreds of nodes which requires you to consider query tuning patterns specific to distributed systems.

During this training, you'll learn and receive hands-on experience with techniques, concepts, and toolsets used for performance optimization and query tuning in YugabyteDB. By following simple examples, you'll start with generic SQL optimization concepts and tactics, and then do a deep dive into advanced optimization techniques specific to YugabyteDB's distributed nature.

What you’ll learn and how you can apply it:

  • Tables and indexes internals, and their scan operations
  • Basics of hash or range sharding for tables and indexes
  • Best practices for indexing distributed data, includes covering and partial indexes
  • Types of joins and when they perform the best



Prerequisites

Wanted: Developers and Architects

We recommend that participants in this course are experienced SQL developers, or NoSQL developers learning SQL. You should have practical experience creating tables and querying them, as well as the ability to start YugabyteDB on Docker (if on Windows) to complete the hands-on exercises.

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
    Your favorite IDE, such as IntelliJ IDEAEclipse, or Visual Studio Code.
    GitPod or Docker 20 or later, JDK 11 or later, Python 3.8 or later, Apache Maven 3.0 or later and Docker Compose 1.29 or later

  • YugabyteDB Managed sandbox (free) cluster

  • YugabyteDB Community Slack account

Workshop agenda

Duration: 150 minutes

  1. 01

    • 👋 Welcome!

    • 📅 Course Calendar

    • 🍿 On-Demand Video

    • 🎟️ 2024 Jan 6 9-10:30a PT | Zoom Meeting
  2. 02

    • Tables, Indexes, and Sharding

    • Create Table

    • Instrumentation

    • Execution Plans

    • Push Down

    • Secondary_Indexes

    • Joins

    • Hints

    • Geo-Distribution

    • Follower Reads

    • Bulk Load

    • SQL Tuning Methodology
  3. 03

    • 🦶Next Steps

    • 🧰 Your YugabyteDB Skill on LinkedIn

    • 🏆 Learning Path Tracker

FAQs

The answers you seek

  • What is the cost?

    YugabyteDB University courses are FREE, so enroll today!

  • For this builder workshop, 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.

  • Will I be able to review this workshop?

    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 register, you will receive a calendar invitation. You will also receive an email reminding you to attend this builder workshop.

  • 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.