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!
YSQL Exercises: Simple queries
Learn how to write basic YSQL queries using YugabyteDB and YugabyteDB Managed.
YSQL Exercises: Joins and subqueries
This mini course covers various basic commands such as INNER JOIN, LEFT OUTER JOIN, UNION, as well as subqueries.
YSQL Exercises: Modifying data
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.
YSQL Exercises: Aggregation queries
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.
YSQL Exercises: Dates and timestamps
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.
YSQL Exercises: String operations
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.
YSQL Exercises: Recursive queries
Learn how to write a recursive query with YSQL and a Common Table Expression (CTE) in this mini-course.