-
Notifications
You must be signed in to change notification settings - Fork 1.1k
YSQL Development Training and Certification Prerequisites
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.
https://yugabyte.zoom.us/webinar/register/WN_ktw1STbkQoiW3-KAPOIbfg
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.
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.
$ 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
$ 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!)
- YB-Master Admin UI is available at http://127.0.0.1:7000
- YB-TServer Admin UI is available at http://127.0.0.1:9000
For more detailed instructions check out:
https://download.yugabyte.com/
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/
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;
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/
Join the #training channel on the https://www.yugabyte.com/slack and we can help.
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.
At the conclusion of the training session, all participants will be emailed a study guide.
At the conclusion of the training session, all participants will be emailed a link to take the exam.
Yes.
After successfully passing the exam, we will email you your certificate and badge. Typically, within 48 hours.
Like what you see? Don't forget to star us!