Database Design, Tools & Techniques with NoSQL

Database Design, Tools & Techniques with NoSQL workshop is intended for participants interested in gaining knowledge of the fundamentals of designing and building non-relational database applications using MongoDB’s NoSQL. It is recommended prospective participants have some basic experience developing applications with JavaScript and/or other scripting languages. 

CONTENT

Introduction

• Fundamental database concepts
• Fundamentals of software development
• Fundamentals of system programming
• Basic JavaScript programming

Philosophy & Features

• The key features of MongoDB and what functionality they provide
• Fundamentals of JSON and BSON
• The MongoDB data model at a high level
• The MongoDB query model at a high level
• Data consistency and availability in MongoDB

CRUD Operations

• Understand all create, read, update, and delete (CRUD) operations in the MongoDB
• query language
• Are familiar with commonly used CRUD operators and how to use them
• Know what data types MongoDB supports

Data Modelling

• Understand the document model
• Given two alternative data models, you can determine which will be more efficient
• Know common patterns for schema design
• Know the benefits of special data types in MongoDB
• Understand the difference between embedding and linking pieces of information

Indexing and Performance

• Understand the types of indexes available in MongoDB
• Know the options you can have for an index
• Know how to improve the efficiency of a query using indexes
• Understand the write performance costs of indexes

Aggregation

• The analogy between the aggregation pipeline and UNIX pipes
• Each aggregation stage operator and its semantics
• How documents enter the pipeline, are passed from one stage to another, and are
• returned when the pipeline completes

Replication

• Understand the benefits of replication
• Understand trade offs between speed and durability
• Know the basics of how the oplog works, including concepts like idempotence and
• statement-based replication
• Know what happens when a node (primary or not) fails

Sharding

• Understand horizontal scaling and how sharding provides this capability in MongoDB
• Know how to construct a good shard key, and what can go wrong with selecting a shard key
• Understand the balancer
• Know the role of the config servers and how they work