YugabyteDB
YSQL Development Fundamentals
VILT
Public Virtual Training
2022 May 11
9:00 AM - 10:30 AM PT
Ideal for AMER time zones
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 Yugabyte Cloud free tier cluster, connect to your cluster using Yugabyte Cloud Shell ad other tools, create a database, load data, and process queries with joins between tables.
Wanted: Administrator, Developers, Architects, and Business Users
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
Duration: 90 minutes
Welcome!
Helpful Resources
Zoom Meeting Details
Zoom Recording
Introduction
Data Definition Language: Schemas and Databases
Data Definition Language: Tables
Data Manipulation Language
Queries
Joins
🥼[LAB]: Create a Yugabyte Cloud Free cluster
🥼[LAB]: Create a distributed SQL database
🥼[LAB]: Connect to your Yugabyte Cloud Free cluster with pgAdmin
What's next?
Announce your achievement
Yugabyte University courses are FREE, so enroll today!
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 YugabyteDB Managed free cluster without a credit card or payment method.
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.
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.
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.
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.
After you enroll, you will receive a calendar invitation. You will also receive an email reminding you to attend this virtual training.
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.
Seth will be your guide
Seth Luersen
Director, Yugabyte University