by Tom Hanlon | Released September 2016 | ISBN: 9781491967430

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 systemsExplore the use of Apache Phoenix, the SQL "skin" layer for working with NoSQL HBaseLearn the fundamentals of HBase, and how to obtain and configure Apache PhoenixDiscover why Phoenix interacts with HBase much easier than native HBase toolsLearn to create Phoenix tables, load data, and execute queries against that dataSee how to retrieve data from Phoenix by using a JDBC connectionUnderstand how to structure data to get maximum performance from NoSQL solutionsTom Hanlon is a professional technical trainer with 15+ years of experience teaching Hadoop, MapReduce, YARN, NoSQL, Big Data, distributed systems, machine learning, SQL, and more. He is a Certified Cloudera Developer for Apache Hadoop; he's held senior level training positions at Cloudera, Hortonworks, and Sun Microsystems; and is the author of the O'Reilly titles Introduction to Apache Hive and Learning Apache Pig. Show and hide more Publisher resources Download Example Code

1. 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
2. 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
3. Introduction To Phoenix
   • Hbase Fundamentals 00:08:56
   • Phoenix SQL Engine For Hbase 00:05:39
   • Obtaining And Configuring Apache Phoenix 00:03:01
4. Using Phoenix
   • Creating Tables 00:07:14
   • Schema Operations 00:04:14
   • Indexes And Secondary Indexes 00:06:50
   • Executing Queries 00:05:45
5. Advanced Phoenix
   • Statistics 00:03:08
   • Salted Tables 00:06:40
   • Views 00:05:30
6. Conclusion
   • Wrap Up 00:02:03
Show and hide more