This course was created by Couchbase Learning Services. We are honored to host this training in our library.
Skill Level Intermediate
- [Instructor] Welcome to CB116, Introduction to Couchbase for Microsoft SQL Server Experts. We're going to start by comparing the target workloads for which SQL Server 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 multi-dimensional scalability. We'll also take a fast tour of the Couchbase UI to get you oriented. Next we'll explore how our SDKs 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 in to one of the great mysteries for those 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. Then we're going to start our head-to-head comparison of SQL, or Structured Query Language, SQL, however you like to pronounce that, 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. We'll also jump into the Couchbase query workbench to set you up for your own exploration. With these basics covered, we'll go further into comparing how SQL Server and Couchbase each handle data typing, and compare transactional capabilities and atomicity. In a demo, we'll introduce query filtering. The next lesson it vital. We'll compare SQL Server 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, demonstrating how to implement ANSI joins in N1QL. In the next lesson, we'll quickly survey Couchbase's function library and expression syntax, and learn how to create and use prepared statements in N1QL. A hint here, you probably already know how. Then in our last lesson we'll dial things back out to consider how Couchbase handles high-availability and disaster recovery. So what do we expect someone taking this course already knows? Well, SQL, but that's probably obvious by this point, and hopefully just a little bit about JSON too. Now all told, this course is comprised of about 88 minutes of fast-paced lecture and demonstration divided across 10 lessons, and if you really want to learn about Couchbase, we have a set of lab exercises for you too. There's only so much lecturing one 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 all the videos, you decide, get your hands dirty. The lab workbook will carefully guide you through downloading Couchbase, configuring it locally, and loading it with your 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 we'll 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.