Welcome to the third post in our series on NuoDB, an innovative and easy-to-use product for managing databases. In our previous posts, we discussed how to install NuoDB and manage its transaction engines and storage managers. In this post, we will explore the powerful Explorer feature of NuoDB, which allows us to perform various SQL operations with ease.

NuoDB’s browser-based Explorer is a robust tool that offers many features typically found in an IDE. Let’s dive into a step-by-step tutorial to see how it works:

1. Open your browser and navigate to the NuoDB Console by entering the following URL: http://localhost:8080/.
2. On the QuickStart screen, ensure that you have created the sample database. If not, click on “Create Database” and follow the prompts to create it successfully.
3. Click on the main tab to access the NuoDB Explorer. You will be prompted to enter your domain username and password. Enter the username as “domain” and the password as “bird”. Alternatively, you can use “quickstart” as both the username and password.
4. Once you enter the password, you will see the databases. In our example, we have installed the Sample Database, so you will see the “Test database” in the Database Hierarchy screen.
5. Click on the database and provide the database login. Note that the Database Login is different from the Domain login. In our case, the database username is “dba” and the password is “goalie”.
6. After successfully logging in, you will be able to explore various objects within your database.
7. Select any database and click on “Open”. This will display the SQL script to select data from the table.
8. If you click on “List SQL Statements”, you will see a list of all available SQL statements in the Query Editor.
9. For the geeks out there, you can even click on “Query Plan” to view the text-based query plan. This feature is particularly useful for performance tuning of the database.
10. Another handy feature is the “List Tables” option, which displays all available tables in the query editor. This is helpful when writing complex queries.

Now, let’s take a look at a relatively complex example using Inner Join syntax:

SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.ID = Table2.ID;

By clicking on “Query Plan”, you can view the detailed query plan for this query. This information can be used for further analysis and performance optimization.

NuoDB is not only a powerful distributed database with full support for SQL and ACID guarantees, but it also offers flexibility in terms of adding or shutting down processes to optimize resource usage. Additionally, NuoDB provides a user-friendly interface for monitoring deployments.

If you haven’t already, I strongly recommend downloading NuoDB and exploring its capabilities. Despite its power, NuoDB is remarkably easy to learn and use.

Stay tuned for more exciting posts on SQL Server concepts and ideas!