Intro to Couchbase for Microsoft SQL Server Experts

Learn how to transition your SQL Server experience to the clustered, document-focused NoSQL architecture of Couchbase.

As data volumes increase, data management has evolved. One RDBMS no longer fits all. Learn how to transition your SQL Server experience to the clustered, document-focused enterprise NoSQL architecture of Couchbase. This course compares Couchbase and Microsoft SQL Server on many factors, including target workflows, data access methods, indexing, and querying. Instructor Leo Schuman also compares SQL Server tables to Couchbase documents, and shows how to create, read, update, upsert, and delete documents and the fields within them. The aim is to help developers to leverage Couchbase to support the agile, aggregation-oriented demands of modern enterprise development. By the end, you’ll understand the fundamental architecture and data access methods in Couchbase, particularly N1QL (SQL for JSON).

This course was created by Couchbase Learning Services. We are honored to host this training in our library.

Introduction

• Comparing Couchbase and Microsoft SQL Server

1. Couchbase and SQL Server

• Couchbase and SQL Server target workloads compared
• Couchbase and SQL Server architectures compared
• Couchbase and SQL Server data access compared
• SQL Server tables and Couchbase documents compared
• SQL and N1QL querying compared
• SQL Server and Couchbase types and atomicity compared
• SQL and N1QL indexing compared
• Couchbase and SQL Server aggregation, filtering, and joins compared
• Couchbase functions and query expressions
• Couchbase and SQL Server high availability and disaster recovery compared