What you'll learn

Level: Beginner

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.

The course format is a series of exercises.  Each exercise is about 5 minutes. To help you along, each exercise includes a hint and a detailed solution. 

Prerequisites

Wanted: Architects, Developers, Administrators, and Business Leaders

Your curiosity and desire to learn YSQL are the only requirements for this mini course. The hands-on labs and exercises come complete with step-by-step instructions and easy to follow explanations and solutions.

Checklist

What you'll need

  • Operating System:
    macOS 10+, Ubuntu 16+, or Windows 10+

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

  • YugabyteDB Managed free cluster

  • YugabyteDB Community Slack account

Course details

Duration 55 minutes

  1. 01

    • 👋 Welcome!

    • 🪁 Get Started with YugabyteDB Managed

    • 🧪 [LAB]: Create a YugabyteDB Managed free cluster

    • 🔭 [LAB]: Create the ysql_exercises database

    • 🏋🏾‍♂️ Insert some data into a table

    • 🏋🏿‍♂️ Insert multiple rows of data into a table

    • 🏋🏼‍♀️ Insert calculated data into a table

    • 🏋🏿 Update existing data

    • 🏋🏾 Update multiple rows and columns at the same time

    • 🏋🏻 Update a row based on the values in another row

    • 🏋️ Delete all bookings

    • 🏋🏼 Delete a row from the cd.members table

    • 🏋🏻‍♀️ Delete rows using a subquery

    • 📚 Additional reading

    • 🧰 Your YugabyteDB skill on LinkedIn

    • 🏆 Learning Path Tracker

Frequently asked questions

  • What is the cost?

    YugabyteDB University courses are FREE, so enroll today!

  • Is this course self-paced? In other words, do I decide to learn when I want and on my schedule?

    Yes, you do!

    This is a self-paced course! You can start, stop, pause, resume, and replay whenever you feel like it.

    Using the Course Player, for example, you can watch learning videos whenever you want.

    This course doesn't have any on-demand labs for hands-on exercises, but for our courses that do have labs, they are available when you want as well!

  • 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 Yugabyte Cloud Free cluster?

    What an interesting idea!

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

    If a course requires a YugabyteDB cluster, the course will provide two options:

    (1) a lab provides instructions for how to sign up for a Yugabyte Cloud Free cluster, or...

    (2) an on-demand, lab environment that includes a YugabyteDB cluster

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

    In the Course Player, you always find instructions on how to get help in the Help lesson.

  • Will I be able to review this course?

    After completing this course, you will have the opportunity to review it!

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

  • Can I enroll in just this course ?

    Yes, you can. Simply enroll and start right away. It's free and fun! For this learning path, there are seven courses with a suggested order. You can enroll in any course you want.

Frequently asked questions

  • What is the cost?

    Yugabyte University courses are FREE, so enroll today!

  • Is this course self-paced? In other words, do I decide to learn when I want and on my schedule?

    Yes, you do!

    This is a self-paced course! You can start, stop, pause, resume, and replay whenever you feel like it.

    Using the Course Player, for example, you can watch learning videos whenever you want.

    This course doesn't have any on-demand labs for hands-on exercises, but for our courses that do have labs, they are available when you want as well!

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

    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 YugabyteDB Managed free cluster without a credit card or payment method.

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

    Do I need to sign up for a YugabyteDB Managed free cluster? What an interesting idea!

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

    If a course requires a YugabyteDB cluster, the course will provide two options:

    (1) a lab provides instructions for how to sign up for a YugabyteDB Managed free cluster, or...

    (2) an on-demand, lab environment that includes a YugabyteDB cluster.

  • What do I receive for completing this course?

    A big THANK YOU from the team at Yugabyte University!

    If you complete all of the courses in the learning path, you will automatically receive proof of completion and join a special group of students.

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

    In the Course Player, you always find instructions on how to get help in the Help lesson.

  • Will I be able to review this course?

    After completing this course, you will have the opportunity to review it!

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

  • Can I enroll in just this course?

    Yes, you can. Simply enroll and start right away. It's free and fun! For this learning path, there are seven courses with a suggested order. You can enroll in any course you want.

Learning path

YSQL Exercises: Learn by doing!

Digital Badge

Practitioner:
YSQL Exercises - Modifying data

After completing this course, you will receive a digital badge.

This badge is proof that you completed this course. The skills badge validates your learning.

With a few clicks, you can easily add your digital badge to your LinkedIn profile.
Practitioner: YSQL Exercises - Modifying data