YSQL Exercises:
Learning Path
LP-PAC-YSQL
Learn by doing in the hands-on learning path which consists of 7 mini-courses and results in certification
What you'll learn
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!
Self-paced mini-courses
Learning path
-
YSQLE01YSQL Exercises: Simple queries
Learn how to write basic YSQL queries using YugabyteDB and YugabyteDB Managed.
-
YSQLE02YSQL Exercises: Joins and subqueries
This mini course covers various basic commands such as INNER JOIN, LEFT OUTER JOIN, UNION, as well as subqueries.
-
YSQLE03YSQL 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.
-
YSQLE04YSQL 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.
-
YSQLE05YSQL 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.
-
YSQLE06YSQL 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.
-
YSQLE07YSQL Exercises: Recursive queries
Learn how to write a recursive query with YSQL and a Common Table Expression (CTE) in this mini-course.
Certifications
YugabyteDB YSQL Development
Certification establishes your credentials and validates your expertise.
By completing this course and by passing the course exams, you will receive proofs of completion. With a few clicks, you can easily add your digital certificate to your LinkedIn profile.
