Design and Build a Data Fabric Database - DEV 331

Design and Build a Data Fabric Database - DEV 331

Learn to design the schema and row keys, work with complex schema, import data, replicate tables, and perform an ETL operation

About this Course

In this second Data Fabric Database course, you will learn how to design the DB schema and row keys to maximize efficient data use, based on how you expect the data to be accessed. Also covered are working with complex schema, importing data, table replication, and performing an ETL operation.

What's Covered

Course Lessons Lab Activities

3: Document Database Schema Design

Introduction to Schema Design 
Design Row Keys 
Design Columns and Column Families
Design Complex and Dynamic Schemas

 

Row Key Design Practice

4: Build a Document Database with MapR Database

Import Structured Data
Import Binary and JSON Data
Replicate Tables

 

Perform ETL on Relational Data
Import Data

Prerequisites

  • Completion of  DEV 330
  • Basic Hadoop knowledge and intermediate Linux knowledge
  • Experience using a text editor such as vi
  • Terminal program installed; familiarity with command-line options such as mv, cp, ssh, grep, cd, and useradd
  • Beginner-to-intermediate fluency with Java in an IDE

Curriculum

  • Lesson 3: Document Database Schema Design
  • Quiz 3
  • Lesson 4: Build a Document Database
  • Quiz 4
  • Course Materials
  • Lab Guide
  • Lab Environment Setup Guide

About this Course

In this second Data Fabric Database course, you will learn how to design the DB schema and row keys to maximize efficient data use, based on how you expect the data to be accessed. Also covered are working with complex schema, importing data, table replication, and performing an ETL operation.

What's Covered

Course Lessons Lab Activities

3: Document Database Schema Design

Introduction to Schema Design 
Design Row Keys 
Design Columns and Column Families
Design Complex and Dynamic Schemas

 

Row Key Design Practice

4: Build a Document Database with MapR Database

Import Structured Data
Import Binary and JSON Data
Replicate Tables

 

Perform ETL on Relational Data
Import Data

Prerequisites

  • Completion of  DEV 330
  • Basic Hadoop knowledge and intermediate Linux knowledge
  • Experience using a text editor such as vi
  • Terminal program installed; familiarity with command-line options such as mv, cp, ssh, grep, cd, and useradd
  • Beginner-to-intermediate fluency with Java in an IDE

Curriculum

  • Lesson 3: Document Database Schema Design
  • Quiz 3
  • Lesson 4: Build a Document Database
  • Quiz 4
  • Course Materials
  • Lab Guide
  • Lab Environment Setup Guide