What you'll learn

Level: Beginner

Yugabyte Structured Query Language (YSQL) is a fully-relational API  with high degree of PostgreSQL compatibility. In this virtual training, you'll discover how YSQL supports both Data Definition Language (DDL)  and Data Manipulation Language (DML). Topics include database object creation, data manipulation, queries, and joins. With your instructor as your guide, you'll dive into hands-on labs that show you how to create a YugabyteDB Managed free tier cluster,  connect to your cluster using Cloud Shell and other tools, create a database, load data, and process queries with joins between tables.

Prerequisites

Wanted: Administrator, Developers, Architects, and Business Users

Basic knowledge of structured data and database concepts is helpful, but is not required. As a course for beginners, you'll be introduced to YSQL and will have an opportunity to complete hands-on labs in YugabyteDB Managed Cloud Shell and other tools. You'll create a database with tables, load data, and execute queries.

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
    DBeaver, pgAdmin, or ysqlsh

  • YugabyteDB Managed free cluster

  • YugabyteDB Community Slack account

Course agenda

Duration: 90 minutes

  1. 01

    • Welcome!
  2. 02

    • Introduction

    • Data Definition Language: Schemas and Databases

    • Data Definition Language: Tables

    • Data Manipulation Language

    • Queries

    • Joins

    • Helpful Resources
  3. 03

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

    • 🥼[LAB]: Connect to your YugabyteDB Managed cluster with pgAdmin

    • 🥼[LAB]: Create a distributed SQL database
  4. 04

    • 🧰 Your YugabyteDB skill on LinkedIn

    • 🦶Next Steps

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

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!

    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.

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

  • Will you send me a calendar invitation 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 can I find the Zoom meeting link?

    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

Seth 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