Designed for beginners, you start this learning path with the fundamentals of distributed SQL and YugabyteDB. Then, you tackle seven mini-courses for writing YSQL queries.
Enroll to begin!
UCF100 | Learn about Distributed SQL and why modern, cloud-native applications require a distributed SQL database.
UCF101 | In this introductory course, you will learn about the unique architecture of YugabyteDB as well as the various key features that make YugabyteDB an amazing distributed SQL database.
UCF091 | In this course, you'll discover YugabyteDB Managed, create a free cluster, and connect to it with both YugabyteDB Managed Shell and pgAdmin.
YSQLE01 | Learn how to write basic YSQL queries using YugabyteDB and YugabyteDB Managed.
YSQLE02 | This mini course covers various basic commands such as INNER JOIN, LEFT OUTER JOIN, UNION, as well as subqueries.
YSQLE03 | Querying data important, but soon you will want to add, modify, and remove data! This mini-course showcases the various Data Manipulation Language (DML) commands available to YSQL: INSERT, UPDATE, and DELETE.
YSQLE04 | An aggregation query is often more than a count or summation. In this mini course, you'll tackle a series of exercises that cover built-in functions, including grouping data and ranking dating with window functions.
YSQLE05 | Working with dates and timestamps in YSQL can be complex. The exercises in this mini course reveal how fantastically powerful YSQL can be to work with dates and timestamps.
YSQLE06 | String operations can be needlessly painful many databases. Fortunately, YugabyteDB is better than most in this regard, providing strong regular expression support. This short course covers the basics of string manipulation in YSQL.
YSQLE07 | Learn how to write a recursive query with YSQL and a Common Table Expression (CTE) in this mini-course.
Practitioner:
Associate YSQL Certification
Our student champions endorse this learning path! Here's what they say:
These practice challenges helped me learn YSQL using Yugabyte Managed. The hints are great!
Technical Solution Architect
Great practice for learning YSQL. Tons of challenges with hints and explanations.
Junior Engineer
I needed to learn SQL and Postgres, and I found this program at Yugabyte University. It was a very good learning experience for learning YSQL.
Data Engieer
.png)
