This free tutorial training, comprised of numerous video tutorials, demonstrations, and hands on lab exercises, teaches how to index, select, filter, aggregate, and calculate JSON data fields, and how to insert, update upsert, join, and delete JSON documents, within a Couchbase data bucket.
Prior experience with Structured Query Language (SQL) is assumed for people taking this course. It will be most useful to developers and data analysts who will model JSON documents and design queries for accessing data from these documents.
- Install Couchbase Enterprise Edition, navigate its user interface, and load external data
- Select document fields and limit results
- Alias, concatenate, and select by keys
- Create indexes and filter queries
- Query ranges, order results, and explain queries
- Aggregate values, select distinct fields, and filter with wildcards
- Select for missing fields and group results
- Index and select based on values in JSON arrays
- Use functions in queries
- Manipulate data using N1QL DML
- Join documents by related values (ANSI)
By completing/passing this course, you will attain the certificate OLT Proof of Participation
This website is made available by Couchbase, Inc., a company incorporated and registered in Delaware, USA (“Couchbase”).
The content of this website (“Content”) is owned by or licensed to Couchbase and protected by United States and international copyright laws. Couchbase and its licensors retain all proprietary rights to such Content. You may not copy, reproduce or distribute the Content without the prior written permission of Couchbase.
Couchbase and the couch logo are trademarks of Couchbase and its affiliated companies. More information about permitted used is available here: Trademark Policy.
Couchbase grants you a limited license to access and make personal use of this website subject to these Terms. This website and any part of it may not be reproduced, copied, framed or otherwise exploited for any commercial purpose without the express prior written consent of Couchbase.
6. Use of Software
To the extent that Couchbase provides for the download of Couchbase software and/or open source software from this website (“Software”), such Software is protected by the applicable copyright, patent or other intellectual property rights of either Couchbase or the open source licensor, respectively. Any use of the Software is subject to the terms of the applicable license agreement made available with the Software.
7. Links to Third Party Websites
8. Disclaimer and Limitation of Liability
THIS WEBSITE IS PROVIDED BY COUCHBASE ON AN “AS IS” AND “AS AVAILABLE” BASIS. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, COUCHBASE MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, AS TO THE OPERATION OF THIS WEBSITE OR THE INFORMATION, CONTENT OR MATERIALS INCLUDED ON THIS WEBSITE. EXCEPT TO THE EXTENT PROHIBITED BY APPLICABLE LAW, IN NO EVENT WILL COUCHBASE BE LIABLE FOR ANY DIRECT, INDIRECT, SPECIAL, PUNITIVE, EXEMPLARY OR CONSEQUENTIAL LOSSES OR DAMAGES OF WHATSOEVER KIND ARISING OUT OF ACCESS TO OR USE OF THIS WEBSITE OR ANY INFORMATION, CONTENT OR MATERIALS INCLUDED ON THIS WEBSITE.
9. Applicable Law and Jurisdiction
These Terms shall be governed by the laws of California, USA and you agree to submit to the non-exclusive jurisdiction of the courts of Santa Clara County, California, USA in respect of any disputes arising under or in connection with these Terms.
For information about how to contact Couchbase, please visit our Contact Us page.
Instructor Led Training: Couchbase guarantees that registered and paid Learners who fully attend all lectures, actively participate, and complete all hands on lab work for an Instructor Led Training course registered through this site and delivered by Couchbase staff, will be competent and confident with the learning objectives presented for that course. Learners who fully attend all lectures, actively participate, and complete all hands on lab work for a course, but do not feel competent and confident with the stated learning objectives presented for that course, at the end of the course, may retake any publicly scheduled and confirmed delivery of the same course, without charge, within one year of the end date of the originally registered training.
Online Training: Couchbase provides no guaranteed learning outcome for any Learner's participation in free online training courses provided by Couchbase.
2. Intellectual Property
All training content registered or distributed through this service is owned by Couchbase, and all rights to this content are reserved. No rights, title, or interest in the training content are extended to the Learner.
Learner agrees not to record any Couchbase training content, in whole or part, by any means.
3. Right of Dismissal
Couchbase reserves the right to dismiss participants from any Couchbase training event. A participant who, in Couchbase's sole judgment, behaves disruptively during a Couchbase training event may be dismissed from the premises, and may not return. In case of such dismissal, Couchbase's liability is strictly limited to the refund of fees paid for this training to Couchbase by participant or participant's organization. Couchbase is not responsible for any consequential loss or inconvenience related to participant's dismissal.
4. Use of Third Party Learning Management System
Couchbase uses a third party learning management system ("LMS") to register all learners for our training courses, to deliver all our online training, and to assist in the delivery of our instructor led training. Couchbase does not guarantee the availability or functionality of this LMS, which may go or be taken offline, from time to time, without notice. Further, Couchbase disclaims all liability for intellectual property used in this LMS. All persons using this LMS agree to hold Couchbase harmless for any intellectual property violations which do or may exist within this LMS.
5. Use of Learner Data
Couchbase may use data collected during the learner's registration and training processes to improve our delivery of training, enablement, and marketing efforts for our learners. We do not share or sell this information to third parties.
Your cart is empty