CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics

Content
14 sessions

Difficulty
Intermediate

Course Length
32 hours

Instructor
Barry Ryan

Released
15 Nov 2023

Price
$1,900.00

Upcoming Sessions

Description

Through conceptual presentation, demonstration and extensive hands­-on labs and exercises, this 4-day instructor-­led course guides developers, architects, and DBAs on storing and accessing data rapidly and at web scale, in diverse document-database use cases based on JSON, using Couchbase Server, N1QL, and related technologies. All labs rely on queries in N1QL for Query, N1QL for Analytics or FTS Queries without dependency on any particular application programming language. The course is aimed at developers, architects, analysts, SQL and Oracle Developers, DBAs, data warehouse and business intelligence admins and analysts, and DevOps professionals.

The hands-on labs (usually 60% of class time) get you real-world "flight-time" modeling NoSQL data using best practices for JSON and key/value, creating and exploiting secondary indexes, performing complex aggregations using N1QL, and becoming capable with N1QL as a basis for developing powerful, scalable, and reliable applications using NoSQL data, in any programming language. 

Data Sheet

Objectives

Upon completing this course, students will be able to perform the following.

 

  • Describe the key components of Couchbase Server
  • How to design data models for optimal storage and retrieval in Couchbase
  • How to query for data using SQL-like syntax
  • Create effective indexes to meet your requirements with the possible performance enhancements 
  • Monitor to assess how queries are performing and identify the slow running queries and tune them
  • Perform full-text-search, Google-like search capability on JSON documents
  • Use Couchbase Analytics to efficiently run complex queries over many records

 

Introduction to NoSQL

  • Discuss the modern application challenges
  • Describe Big Data
  • Describe the common strategies for handling Big Data
  • Explain CAP Theorem
  • Differentiate Hadoop and NoSQL
  • Explain different types of NoSQL
  • Describe Polyglot Programming

 Introduction to Couchbase

  • Describe the history of Couchbase server
  • Describe Couchbase Data Platform
  • Explain how data is stored in Couchbase server 
  • Describe Couchbase server architecture [Single Data Node]
  • Describe the anatomy of a Couchbase application 
  • Explain Multi Dimensional Scaling
  • Describe Tools to Integrate with Couchbase
  • Explain Couchbase SDKs

 N1QL Essentials

  • Select documents and limiting results
  • Explain Aliasing, concatenating, and selecting by keys
  • Create indexes and filter queries
  • Describe Querying ranges, ordering results, and explaining queries
  • Describe Aggregating, distinct values, and filtering with wildcards
  • Select for missing attributes, and group results
  • Index and select based on values in JSON arrays
  • Use functions in queries
  • Join documents

 Indexes in N1QL

  • Describe the various Index Options
  • Explain Index Partitioning
  • Explain Alter Indexes
  • Explain index service capacity management
  • Explain Memory Optimized Indexes

Query Planning and Tuning

  • Describe query planning
  • Explain the data source access methods
  • Explain index selection in N1QL
  • Explain pushdowns
  • Explain the best practices in index tuning
  • Explain query tuning in N1QL
  • Describe the query tuning checklist

Eventing

  • Describe an event
  • Explain the traditional ways of listening to events
  • Explain Couchbase Eventing
  • Describe Functions
  • Explain the Functions Terminology
  • Demonstrate Deploying and Un-deploying Functions

Introduction to Data Modeling

  • Describe Data Modeling
  • Explain Data Modeling for Distributed Systems
  • Explain Formal Data Modeling
  • Learn the Data Models Used In The Course

Data Modeling for Couchbase

  • Describe JSON Document Design
  • Explain Data Nesting
  • Explain Key Design
  • Explain the various Trade-offs in Data Modeling

Role Based Access Control, N1QL Tools and Other Tricks (Optional)

  • Explain Role Based Access Control in N1QL
  • Explain pretty setting in CBQ
  • Explain updating of nested arrays
  • Explain cURL in N1QL

Introduction to Full Text Search

  • Explain when use Search
  • Explain Search Basic Concepts
  • Introduce Couchbase Search
  • Demonstrate a simple Couchbase Search

Performing Full Text Search

  • Explain Search Queries
  • Execute Search Queries Using Couchbase Web Console
  • Demonstrate the usage of Query String Queries
  • Run Queries via REST
  • Demonstrate Simple Query
  • Demonstrate Compound Queries
  • Execute Search Queries Using N1QL

Creating Full Text Indexes

  • Create Basic Full Text Indexes
  • Configuring Mappings 
  • Store Field Data and Indexing Nested Fields
  • Create an Index Alias and Clone an Index
  • Explain Flex Indexes

Analyzers and Filters

  • Explain Tokenization and Analyzers
  • Define a custom analyzer

Introduction to Couchbase Analytics

  • Organizing Data in Analytics
  • N1QL for Analytics vs. N1QL for Query
  • Executing Analytical Queries
  • Monitoring Analytical Queries
  • Query and Configuration Parameters
  • Understand Query Responses
  • Analytics Shell
  • Analytics REST API
  • Remote Links
  • External Datasets

Built-in Functions and Window Functions

  • Expressions in N1QL for Analytics
  • Built-in Functions
  • Window Functions

 

Certificate

By completing/passing this course, you will attain the certificate ILT Certificate of Completion

1.

{{ vm.helper.t('lup.courses.pick_one_session') }}

CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - US Virtual (GMT -6)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - APAC Virtual (GMT +8)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - EMEA Virtual (GMT +0)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - APAC Virtual (GMT +8)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - US Virtual (GMT -6)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - EMEA Virtual (GMT +0)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - Placeholder
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - US Virtual (GMT -6)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - EMEA Virtual (GMT +0)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - EMEA Virtual (GMT +0)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - EMEA Virtual (GMT +0)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - APAC Virtual (GMT +8)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - US Virtual (GMT -6)
CD212: Couchbase NoSQL Data Modeling, Querying, Search, and Analytics - EMEA Virtual (GMT +0)

COUCHBASE WEBSITE TERMS OF USE

1. General

This website is made available by Couchbase, Inc., a company incorporated and registered in Delaware, USA (“Couchbase”).

All use of this website is subject to these terms of use (“Terms”). Couchbase may amend these Terms at any time by posting amended terms on this website.

2. Privacy

Please review our Privacy Policy which also applies to your use of this website.

3. Copyright

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.

4. Trademarks

Couchbase and the couch logo are trademarks of Couchbase and its affiliated companies. More information about permitted used is available here: Trademark Policy.

5. License

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

This website may contain links to third party websites for your convenience and information. Couchbase does not control and is not responsible for the content of such websites. The information collected by such third party websites is not covered by Couchbase’s privacy policy.

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.

COUCHBASE TRAINING TERMS OF USE

1. Guarantee

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.

Shopping Cart

Your cart is empty