Skip to content

YSQL Development Training and Certification Prerequisites

jguerreroyb edited this page Nov 6, 2020 · 3 revisions

Thanks again for registering for the upcoming “YugabyteDB YSQL Development” training class!

Below you’ll find a list of prerequisites and FAQs to help you get the most out of the class.

Step 1: Register for the course on Zoom:

https://yugabyte.zoom.us/webinar/register/WN_ktw1STbkQoiW3-KAPOIbfg

Step 2: Join the Yugabyte Community Slack Channel

YugabyteDB's Community Slack is the easiest and fastest way to get your questions answered about requirements, installation, class content, exam preparation and certification. Register here:

https://www.yugabyte.com/slack

...after introducing yourself on #introductions, please join the #training channel, this is where we discuss all things training and certification related.

Step 3: Install YugabyteDB

The simplest way to get up and running with YugabyteDB is to deploy just a single node.

Note: Make sure you have a current version of wget.

Single Node Installation on Mac

$ wget https://downloads.yugabyte.com/yugabyte-2.3.2.0-darwin.tar.gz

$ tar xvfz yugabyte-2.3.2.0-darwin.tar.gz && cd yugabyte-2.3.2.0/

$ ./bin/yugabyted start

Single Node Installation on Linux

$ wget https://downloads.yugabyte.com/yugabyte-2.3.0.0-linux.tar.gz

$ tar xvfz yugabyte-2.3.0.0-linux.tar.gz && cd yugabyte-2.3.0.0/

$ ./bin/post_install.sh

$ ./bin/yugabyted start

You should now be able to access the basic web admin UIs. (Assuming other applications are not already using those ports!)

For more detailed instructions check out:

https://download.yugabyte.com/

3 Node Local Cluster Installation on Mac

If you’d like to try your hands at 3 node cluster running locally on your Mac, run the following commands:

$ wget https://downloads.yugabyte.com/yugabyte-2.3.2.0-darwin.tar.gz

$ tar xvfz yugabyte-2.3.2.0-darwin.tar.gz && cd yugabyte-2.3.2.0/

$ ./bin/yb-ctl --rf 3 create

For more detailed instructions and prerequisites like the necessary ulimit settings and required loopback addresses for local, multi-node installs, check out:

https://docs.yugabyte.com/latest/quick-start/

Step 4: Install the Northwind Sample Database

Many of the examples in the class will make use of the Northwind sample database. To install it, navigate to your YugabyteDB install directory. For example:

~/yugabyte-2.3.2.0/share

In the share directory you should see several *.sql files. The two files we’ll need to execute are:

northwind_data.sql
northwind_ddl.sql

To execute these files, the process is identical to how you would do it in PostgreSQL. First, let’s get to a YSQL command prompt.

./bin/ysqlsh
ysqlsh (11.2-YB-2.3.0.0-b0)
Type "help" for help.

yugabyte=#

Next let’s create the northwind database. Again the process is identical to PostgreSQL.

create database northwind;

Now, change to the northwind database.

\c northwind

Finally, execute the two sql scripts based on where you installed YugabyteDB. For example:

\i ~/yugabyte-2.3.0.0/share/northwind_ddl.sql
\i ~/yugabyte-2.3.0.0/share/northwind_data.sql

Verify that you now have the northwind tables and that they are loaded up with data.

\dt

and

SELECT customer_id, order_id, shipped_date FROM orders LIMIT 10;

Step 5: Configure an Administration Tool (Optional)

Graphical database administration tools make it a lot easier to navigate a database and its structure, write queries and examine the results. In general, if your favorite administration tool supports PostgreSQL, then it will support YugabyteDB. Why? Because YugabyteDB is PostgreSQL compatible and as such, the PostgreSQL drivers can be used to connect to YugabyteDB.

For example TablePlus, pgAdmin, DBeaver, SQLPad, IntelliJ and many more tools can be used with YugabyteDB. The only thing you need to remember when setting up the connect string is to specify port 5433 vs 5432. 5433 is YugabyteDB’s default port number, while 5432 is PostgreSQL’s. If you don’t already have a favorite tool, we recommend DBeaver because it has native support for YugabyteDB built-in. For more info and installation instructions, check out:

https://blog.yugabyte.com/getting-started-with-dbeaver-on-a-distributed-sql-database/

Frequently Asked Questions

I am stuck or have a question. Where can I get help?

Join the #training channel on the https://www.yugabyte.com/slack and we can help.

In what format will the class be delivered?

The class will be delivered over Zoom using a combination of slides and demos. All the exercises demonstrated can be performed offline on your own local installation of YugabyteDB. You can chat with us during the class in the #training channel of the https://www.yugabyte.com/slack.

How can I prepare for the exam?

At the conclusion of the training session, all participants will be emailed a study guide.

Where do I go to take the exam?

At the conclusion of the training session, all participants will be emailed a link to take the exam.

If I don’t pass the exam on the first try, can I retake it?

Yes.

When will I get my certificate and badge?

After successfully passing the exam, we will email you your certificate and badge. Typically, within 48 hours.