Learn how to transition your Oracle experience to the clustered, document-focused NoSQL architecture of Couchbase.
- Welcome to CB116 - Introduction to Couchbase for Oracle Experts. Now, we're going to start by comparing the target workloads for which Oracle and Couchbase are each best suited. Data management has evolved, along with rising data volume. One size no longer fits all. Then we'll compare some fundamental architectural distinctions, survey the Couchbase services and consider the utility of multidimensional scalability. We'll also take a fast tour of the Couchbase UI to get you oriented. Next we'll explore how RSDKs access Couchbase services. We'll survey available frameworks and connectors and take a quick high level look at our core API. After that, we'll dive into one of the great mysteries. For those who are taking a first look at document databases, how do tables and documents compare as ways to store data? We'll also step through a demo on creating and loading a data bucket, although you might prefer to think of that as a key space. Then we're going to start our head to head comparison of SQL and N1QL to show you how much you already know about Couchbase. You'll see how to create, read, update and delete Couchbase data or to be more accurate, how to select, insert, update and delete documents and fields within documents. We'll also jump into the Couchbase query workbench to set you up for your own exploration. Now with these basics covered, we'll go further into comparing how Oracle and Couchbase each handle data typing and compare transactional capabilities and atomicity. In a demo, we'll introduce query filtering. Now, this next lesson is vital. We'll compare Oracle and Couchbase indexing capabilities, learn how to define indexes using N1QL and learn how to set your desired index consistency from the SDK. In a demo, we'll step through and compare indexing approaches in Couchbase. Next, we'll continue our comparison of SQL and N1QL, showing you more of all you already know about N1QL and Couchbase and demonstrating how to implement and see joins in N1QL. In the next lesson, we'll quickly survey Couchbase's function library and expression syntax and we'll learn how to create and use prepared statements in N1QL. A hint, you probably already know how. And then in our last lesson, we'll dial things back out to consider how Couchbase handles high availability and disaster recovery. What do we expect someone taking this course already knows? Well, SQL (laughs), but that's probably obvious by this point and hopefully just a little bit about JSON. If not, jump out to json.org and take a look. It's really straight quite forward. All told, this course is comprised of about 88 minutes of fast paced lecture and demonstration, divided across 10 lessons. There's a short quiz available for each lesson to reinforce your recollection. And if you really want to learn about Couchbase, we have a set of lab exercises for you too because there's only so much lecture anyone can take, no matter how lively we try to make it. So at some point in all this, whether now or at the end of videos or in between, you decide, get your hands dirty. The lab workbook will carefully guide you through downloading Couchbase, configuring it locally and loading it with sample data. You'll dive right into N1QL queries to select, filter and aggregate data fields. You'll build and drop indexes and explore query plans. You'll go through the full crud cycle to insert, upsert, update, delete, sub-select and select documents by key. And you'll use inline expressions on ANSI joined document data. It will all be fast and will hopefully leave you both with a good idea of how much you already know about N1QL because of your SQL experience, as well as hungry for more. We've got some fun ground to cover ahead. Stick around.
This course was created by Couchbase Learning Services. We are honored to host this training in our library.