Description
In this course, you will 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.
- By the end, you’ll understand the fundamental architecture and data access methods in Couchbase, particularly N1QL (SQL for JSON).
Syllabus:
- 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