A Practical Guide to Transitioning from SQL Systems to Big Data NoSQL
By Tom Hanlon
Publisher: O'Reilly Media
Final Release Date: September 2016
Run time: 1 hour 43 minutes
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
Tom 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.