What you'll learn

Level: Advanced

Cloud-native applications with transactional workloads often require low latency and high availability. In this virtual training, you will learn about some of the advanced YSQL language features that help minimize the negative effects of high-latency communications and network outages. These YSQL language features include table partitioning, tablespaces, and row-level geo-partitioning. 

Prerequisites

Wanted: Developers and Architects

For folks who have previously achieved YugabyteDB certification, this course is ideal. You should be already familiar with YugabyteDB key concepts, terminology, and features. Additional experience with structured data, relational database systems, SQL, and Bash shell scripting is helpful.
Gitpod YSQL Develoment

Checklist

What you'll need

  • Operating System
    macOS 10.12+, Ubuntu 16.04+, or Windows+

  • Chromium web browser
    Chrome, Opera, or Microsoft Edge

  • YugabyteDB Managed sandbox cluster

  • YugabyteDB Community Slack account

  • GitHub account

Course agenda

Duration: 90 minutes

  1. 01

    • 👋 Welcome!

    • 📅 Course Calendar

    • 🎟️ 2024 Jan 30 9-10:30 aPT | Zoom Meeting

    • 🍿 On-Demand Video
  2. 02

    • Overview of YSQL
  3. 03

    • Constraints

    • Functions, expressions and operators

    • Indexes

    • Views

    • Triggers

    • Extensions

    • Table partitions
  4. 04

    • Geo-partitions

    • Geo-distributed applications
  5. 05

    • 🧪 [LAB]: YSQL Development
  6. 06

    • 🦶Next Steps

    • 🧰 Your YugabyteDB Skill on LinkedIn

    • 🏆 Learning Path Tracker

Digital Badge

Developer: YSQL Development

A digital badge is proof of completion. The badge establishes your credentials and validates your expertise.

After completing this course, you will receive a digital badge. With a few clicks, you can easily add your digital badge to your LinkedIn profile.
Developer: YSQL Development

Frequently asked questions

  • What is the cost?

    Yugabyte University courses are FREE, so enroll today!

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

    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 YugabyteDB Managed free cluster without a credit card or payment method.

  • Do I need to sign up for a YugabyteDB Managed free cluster?

    Do I need to sign up for a YugabyteDB Managed free cluster? What an interesting idea!

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

    If a course requires a YugabyteDB cluster, the course will provide two options:

    (1) a lab provides instructions for how to sign up for a YugabyteDB Managed free cluster, or...

    (2) an on-demand, lab environment that includes a YugabyteDB cluster.

  • What do I receive for completing this course?

    A big THANK YOU from the team at Yugabyte University!

    More importantly, you will receive a digital badge for completing this course.

    You will also be automatically enrolled in the exam course. Passing the exam is required if you plan on achieving YugabyteDB YSQL Developer certification.

  • Will I be able to review this course?

    After completing this course, you will have the opportunity to review it!

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

  • Where can I find the Zoom meeting link?

    You will find the Zoom webinar details in the Course Player, in Welcome --> Zoom Details. This link becomes available 7 days before an event. In the table of contents, select this lesson and then select Start Zoom. That's it.