What you'll learn

Level: Intermediate

Cloud native applications require a distributed database that maintains resiliency and performance at scale. 

For this reason Yugabyte created YugabyteDB, an open source distributed database that supports both relational and semi-relational data. Yugabyte Cloud Query Language, or YCQL, is a semi-relational API for YugabyteDB that is compatible with Cassandra Query Language (CQL). 

In this intermediate level course, you will learn a query-first approach to data model design for semi-relational data using YCQL. As such, you will discovery the benefits of semi-relational data types, user-defined data types, built-in functions, and secondary indexes.


Wanted: Developers and Architects

This course is ideal for folks who have already taken the YugabyteDB YCQL Development Fundamentals course. You should already be familiar with YugabyteDB concepts, terminology, and features. Additional experience with semi-relational data models, CQL, SQL, YCQL, and Bash shell scripting is helpful.


What you'll need

  • Operating System:
    macOS 10.12+, Ubuntu 16.04+, or Windows

  • Chromium web browser:
    Safari, Chrome, Opera, or Microsoft Edge

  • Third party tools:
    Visual Studio Code and ycqlsh

  • YugabyteDB Managed free cluster

  • YugabyteDB public slack account

Course agenda

Duration: 90 minutes

  1. 01
    • Welcome!

    • Zoom Meeting Details

    • Zoom Recording

  2. 02
    • Introduction

    • YugabyteDB Review

    • Query-driven Data Model Design

    • Data Model Optimization

    • Secondary Indexes Explained

    • Index Types

    • Advanced Data Types

    • Automated Data Deletion

  3. 03
    • What's next?

Proof of completion

Announce your achievement

Proof of Completion establishes your credentials and validates your expertise. By completing this course and by passing a course exam, you will receive a certificate of proof of completion. With a few clicks, you can easily add your digital certificate to your LinkedIn profile.
Proof of Completion


The answers you seek

  • What is the cost?

    YugabyteDB University courses are FREE, so enroll today!

  • For this course, do I need to purchases a YugabyteDB software license?

    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.

  • Do I need to sign up for a YugabyteDB Managed Free cluster?


    Most of our courses require a YugabyteDB Managed cluster, so an on-demand YugabyteDB Managed cluster is a great option.

  • Sometimes I get stuck. How can I get help?

    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.

  • What do I receive for completing this course?

    A big THANK YOU from the team at Yugabyte University!

    More importantly, you will receive a course completion email and completion page, both of which include a link to take the course exam, if applicable. When you pass the course exam, you will receive a digital certificate of course completion.

  • Will I be able to review this course?

    Yes! We highly value your feedback and suggestions. Your review and rating helps pay it forward for our future students.

  • Will you email me a calendar invite and reminder?

    After you enroll, you will receive a calendar invitation. You will also receive an email reminding you to attend this virtual training.

  • Where are the Zoom webinar details?

    You will find the Zoom webinar details in the Course Player, in Welcome --> Zoom Details. In the table of contents, select this lesson and then select Start Zoom. That's it.

Your instructor

Mark will be your guide

Four years ago Mark began his journey as part of the instructional team at an EdTech company called 2U. There, he accelerated learners' careers in the field of web development teaching the MERN stack. He has gone on to create online courses in web development and cloud computing. As the Sr. Curriculum Engineer at Yugabyte University, he creates world-class courseware, trainings, and labs. When he's not working, he enjoys the outdoors by going on hikes and bike rides while listening to podcasts.

Mark Kim

Sr. Curriculum Engineer, Yugabyte University