Query This Couchbase Database on Linux

15 minutes
  • 4 Learning Objectives

About this Hands-on Lab

You are working as a System Administrator and have been tasked with loading data into a new bucket on an existing Couchbase database.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Set the Administrator User’s Password

Access the server’s web UI at http://publicip:8091 and set the Administrator user’s password.

Note: Please wait an extra minute or two before trying to connect to http://publicip:8091 to allow the lab to fully provision.

Create a Bucket

Create a new bucket named demo-bucket:

/opt/couchbase/bin/couchbase-cli bucket-create -c 127.0.0.1:8091 --username Administrator --password Omgpassword! --bucket demo-bucket --bucket-type couchbase --bucket-ramsize 512
Insert Data

First, connect to the Couchbase Query console (CBQ):

/opt/couchbase/bin/cbq -e http://localhost:8091 -u=Administrator

Use INSERT INTO to insert data:

INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc0",{"name": "David", "department": "Engineering"} ) RETURNING META().id as docid, *;
INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc1",{"name": "Clay", "department": "HR"} ) RETURNING META().id as docid, *;
INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc2",{"name": "Sue", "department": "Sales"} ) RETURNING META().id as docid, *;
INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc3",{"name": "Betty", "department": "Marketing"} ) RETURNING META().id as docid, *;
Create Primary Index and Query Data

In order to query the data, an index is required:

CREATE PRIMARY INDEX `demo-index` ON `demo-bucket`;

Once the index is created, you can query the data:

SELECT * FROM `demo-bucket` WHERE name= "Betty";
UPDATE `demo-bucket` set department = "Sales" WHERE name= "Betty";     

Additional Resources

Note: Please wait an extra minute or two before trying to connect to http://publicip:8091 to allow the lab to fully provision.

You will need to complete the following steps to accomplish this:

  1. Set the Administrator user's password via the server's web UI at http://publicip:8091.
  2. Create a new bucket named demo-bucket with this command:
    /opt/couchbase/bin/couchbase-cli
  3. Connect using the CouchBase Query tool at /opt/couchbase/bin/cbq and insert the following data:
    doc0; name:David, department:Engineering
    doc1; name:Clay, department:HR
    doc2; name:Sue, department:Sales
    doc3; name:Betty, department:Marketing
  4. Create a primary index named demo-index and ensure you can query the data.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!