Video description
This is a beginner level class for data analysts with RDBMS backgrounds looking to learn more about Big Data NoSQL solutions and the available SQL layers for Big Data. The course begins with a review of the performance characteristics of SQL systems vs. NoSQL systems, so you'll know how to structure data to get maximum performance from NoSQL solutions. It then moves into a detailed tutorial on how to use Apache Phoenix, the easy-to-use SQL "skin" layer for NoSQL HBase.
- Understand the performance characteristics of relational SQL systems vs. NoSQL systems
- Explore the use of Apache Phoenix, the SQL "skin" layer for working with NoSQL HBase
- Learn the fundamentals of HBase, and how to obtain and configure Apache Phoenix
- Discover why Phoenix interacts with HBase much easier than native HBase tools
- Learn to create Phoenix tables, load data, and execute queries against that data
- See how to retrieve data from Phoenix by using a JDBC connection
- Understand how to structure data to get maximum performance from NoSQL solutions
Table of contents
-
Introduction
- What Is Apache Phoenix And Who Uses It 00:02:56
- What You Should Expect From This Course 00:02:22
- About The Author 00:00:56
-
Introduction To NoSQL
- What Is NoSQL 00:04:31
- What Is SQL 00:05:00
- Performance Characteristics Of SQL 00:05:53
- Performance Characteristics Of NoSQL 00:12:02
- Optimizing NoSQL 00:09:45
-
Introduction To Phoenix
- Hbase Fundamentals 00:08:56
- Phoenix SQL Engine For Hbase 00:05:39
- Obtaining And Configuring Apache Phoenix 00:03:01
-
Using Phoenix
- Creating Tables 00:07:14
- Schema Operations 00:04:14
- Indexes And Secondary Indexes 00:06:50
- Executing Queries 00:05:45
-
Advanced Phoenix
- Statistics 00:03:08
- Salted Tables 00:06:40
- Views 00:05:30
-
Conclusion
- Wrap Up 00:02:03
Product information
- Title: Introduction to Apache Phoenix
- Author(s):
- Release date: September 2016
- Publisher(s): Infinite Skills
- ISBN: 9781491967430
You might also like
video
Introduction to Apache NiFi (Hortonworks DataFlow - HDF 2.0)
Apache NiFi was initially used by the NSA so they could move data at scale and …
book
Apache Oozie
Get a solid grounding in Apache Oozie, the workflow scheduler system for managing Hadoop jobs. With …
video
Introduction to Apache HBase Operations
HBase master Jonathan Hsieh provides a complete overview of Apache HBase operations in this course designed …
video
Mastering Apache Sqoop
In this Mastering Apache Sqoop training course, expert author David Yahalom teaches you everything you need …
