Level: Beginner
There are at least a hundred ways to learn Structured Query Language (SQL), but many fail to make it easy to learn. The easiest way to learn SQL is to learn by doing. To help you learn by doing, we offer, for free, the YSQL Exercises: Learning Path.
YSQL is a PostgreSQL compatible language for YugabyteDB, the most popular open-source distributed SQL database in the world.
Designed for beginners, this learning path consists of seven, self-paced mini-courses. The mini-courses cover a range of topics related to YSQL from simple commands, joins, dates, and case statements, to aggregations, window functions, and recursive queries. Each course offers task-based questions, complete with hints, solutions, and explanations. All questions use the same database schema of three related tables.
With no software to install and instant access to YugabyteDB Managed Shell within the course player, you can complete each exercise in less than 5 minutes, directly from your Chromium browser.
Learn by doing, the Yugabyte University way.
Simply enroll for free, today!
Learning path
Learn how to write basic YSQL queries using YugabyteDB and YugabyteDB Managed.
This mini course covers various basic commands such as INNER JOIN, LEFT OUTER JOIN, UNION, as well as subqueries.
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.
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.
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.
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.
Learn how to write a recursive query with YSQL and a Common Table Expression (CTE) in this mini-course.
YSQL Exercises
