Table of Contents

1. Challenge

   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.

2. Challenge

   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
   

3. Challenge

   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, *;
   

4. Challenge

   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";