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 youll 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