YugabyteDB YCQL Development
The definitive course for mastering YCQL. Includes Gitpod hands-on labs with Jupyter notebooks.
Level: Intermediate and Advanced
Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is compatible with Apache Cassandra’s Query Language (CQL). YCQL supports strongly consistent secondary indexes, a native JSONB column type, and distributed transactions.
Designed for developers who are new to distributed SQL database development, this course provides a unique learning experience. By watching learning videos and completing hands-on lab exercises with Gitpod powered VS Code Browser Jupyter notebooks, you will learn more than just the fundamentals of data definition language and data manipulation language of YCQL. You will dive deep into how YCQL is a distributed SQL database language.
With the goal of demystifying key concepts such as partition keys, clustering keys, and tablets, you will explore how the DDL of a table affects not only the distribution of data, but also the very data stored on disk. As many students already know about traditional relational databases, this course also offers a practical methodology for the modeling of semi-relational data, known as query-driven, data modeling. Additional course topics include understanding the nuances of YCQL such as time-to-live, upserts, collections, JSONB, and secondary indexes.
After completion of this course, students can complete a free certification exam.
Wanted: Developers and Architects
What you'll need
macOS 10.12+, Ubuntu 16.04+, or Windows+
Chromium web browser
Chrome, Opera, or Microsoft Edge
YugabyteDB Managed sandbox cluster
YugabyteDB Community Slack account
Duration: 180 minutes
DDL: Create table
DDL: Data types
DML: Insert, update, delete, and more
DML: Built-in functions
Logical data model
Data access patterns
Physical data model
Optimization and tuning: Query plans
Optimization and tuning: Secondary indexes
JSONB: DML and secondary indexes
🧪 [LAB]: YCQL Development with Gitpod
📚 Additional resources
🧰 Your YugabyteDB skill on LinkedIn
Announce your achievement
The answers you seek
YugabyteDB University courses are FREE, so enroll today!
You do not need to purchase a YugabyteDB software license for this course. YugabyteDB is open source software.
You can sign up for Yugabyte Cloud Free cluster without a credit card or payment method.
Most of our courses require a YugabyteDB Managed cluster, so an on-demand YugabyteDB Managed cluster is a great option. However, the labs in this course use Gitpod. A 3 node YugabyteDB cluster runs in your Gitpod environment.
If you get stuck, help is a literally a click away. In the Course Player header bar, select Discussions and post a question, concern, or even suggestion.
We also have a #training channel on YugabyteDB Public Slack.