DEV 321 - Apache HBase Schema Design

Not currently available
Processing...
Not currently available
Processing...

About this Course

Targeted towards data analysts, data architects and application developers, the goal of this course is to enable you to design HBase schemas based on design guidelines. You will learn about the various elements of schema design and how to design for data access patterns. The course offers an in-depth look at designing row keys, avoiding hot-spotting and designing column families. It discusses how to transition from a relational model to an HBase model. You will learn the differences between tall tables and wide tables. Concepts are conveyed through lectures, hands-on labs and analysis of scenarios.

Prerequisites

  • Completion of ESS 100, ESS 101ESS 320, DEV 320
  • 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

Certification

This course is part of the preparation for the MapR Certified HBase Developer (MCHBD) certification.

Syllabus

Lesson 4  Basic Schema Design

  • List the Elements of Schema Design
  • Design Row Keys for Data Access Patterns
  • Lab 4.2: Import Data with Different Row Key Designs
  • Design Table Shape and Column Families for Data Access Patterns
  • Lab 4.3: Populate and Examine Trades Tall and Flat Tables
  • Define Column Family Properties
  • Design Schema for Given Scenario

Lesson 5  Design Schemas for Complex Data Structures

  • Transition from Relational Model to HBase
  • Use Intelligent Keys
  • Use Secondary Indexes or Lookup Tables
  • Design for other Complex Data Structures
  • Lab 5.4a: Model Person-Relatives Schema
  • Lab 5.4b: Model Movie Rental Online Store Schema
  • Lab 5.4c: Model Customer Click Event or Action
  • Evolve Schemas Over Time

Lesson 6  Using Hive to Query HBase

  • Use Hive to Query HBase/MapR Tables
  • Lab 6.1a: Use Hive with the Airlines HBase Table
  • Lab 6.1b: Use Hive to Query the Trades Table

Curriculum

  • Lesson 4: Apache HBase Basic Schema Design
  • Quiz 4
  • Lesson 5: Design Schemas for Complex Data Structures
  • Quiz 5
  • Lesson 6: Use Hive to Query Apache HBase
  • Quiz 6

About this Course

Targeted towards data analysts, data architects and application developers, the goal of this course is to enable you to design HBase schemas based on design guidelines. You will learn about the various elements of schema design and how to design for data access patterns. The course offers an in-depth look at designing row keys, avoiding hot-spotting and designing column families. It discusses how to transition from a relational model to an HBase model. You will learn the differences between tall tables and wide tables. Concepts are conveyed through lectures, hands-on labs and analysis of scenarios.

Prerequisites

  • Completion of ESS 100, ESS 101ESS 320, DEV 320
  • 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

Certification

This course is part of the preparation for the MapR Certified HBase Developer (MCHBD) certification.

Syllabus

Lesson 4  Basic Schema Design

  • List the Elements of Schema Design
  • Design Row Keys for Data Access Patterns
  • Lab 4.2: Import Data with Different Row Key Designs
  • Design Table Shape and Column Families for Data Access Patterns
  • Lab 4.3: Populate and Examine Trades Tall and Flat Tables
  • Define Column Family Properties
  • Design Schema for Given Scenario

Lesson 5  Design Schemas for Complex Data Structures

  • Transition from Relational Model to HBase
  • Use Intelligent Keys
  • Use Secondary Indexes or Lookup Tables
  • Design for other Complex Data Structures
  • Lab 5.4a: Model Person-Relatives Schema
  • Lab 5.4b: Model Movie Rental Online Store Schema
  • Lab 5.4c: Model Customer Click Event or Action
  • Evolve Schemas Over Time

Lesson 6  Using Hive to Query HBase

  • Use Hive to Query HBase/MapR Tables
  • Lab 6.1a: Use Hive with the Airlines HBase Table
  • Lab 6.1b: Use Hive to Query the Trades Table

Curriculum

  • Lesson 4: Apache HBase Basic Schema Design
  • Quiz 4
  • Lesson 5: Design Schemas for Complex Data Structures
  • Quiz 5
  • Lesson 6: Use Hive to Query Apache HBase
  • Quiz 6