What you'll learn

Level: Novice to Intermediate

In this Distributed SQL Summit training, you'll begin by learning how Yugabyte Cloud Query Language (YCQL) is a Cassandra compatible API by using both Data Definition Language (DDL)  and Data Manipulation Language (DML) to create tables and queries. Then, you'll explore the benefits of query-driven data model design for YugabyteDB and YCQL. You'll also learn how to test and tune a denormalized data model in order to perform at global scale. 

Prerequisites

Wanted: Developers and Architects

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.

Checklist

What you'll need

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

  • Chromium web browser
    Chrome, Opera, or Microsoft Edge

  • Third party tools
    ycqlsh

  • YugabyteDB Managed free cluster

  • YugabyteDB Community Slack account

  • Github account

  • Register for DSS

Course agenda

Duration: 90 minutes

  1. 01
    • Welcome!

    • DSS Session Recording

  2. 02
    • Introduction to YCQL

    • YugabyteDB Installation and Setup for YCQL

    • Data Definition Language: Keyspaces and Tables

    • Data Definition Language: Primary Key

    • Data Manipulation Language

    • Queries

    • Data Types

  3. 03
    • YugabyteDB Review

    • Query-Driven Data Model Design

    • Data Model Optimization

    • Secondary Indexes Explained

    • Index Types

    • Advanced Data Types

    • Automated Data Deletion

  4. 04
    • 🧰 Your YugabyteDB skill on LinkedIn

    • 🦶Next Steps

Certifications

YugabyteDB YCQL Development for DSS

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.
Proof of Completion

FAQs

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?

    Yes!

    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.

  • 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.

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