DANA-262: Analyzing with Cloudera Data Warehouse
Course will teach you to apply traditional data analytics and business intelligence skills to big data.
Course Overview
Course will teach you to apply traditional data analytics and business intelligence skills to big data.
This Analyzing with Data Warehouse course will teach you to apply traditional data analytics and business intelligence skills to big data. This course presents the tools data professionals need to access, manipulate, transform, and analyze complex data sets using SQL and familiar scripting languages.
Course Objectives
Through instructor-led discussion and interactive, hands-on exercises, participants will navigate the ecosystem, learning how to:
Use Apache Hive and Apache Impala to access data through queries
Identify distinctions between Hive and Impala, such as differences in syntax, data formats, and supported features
Write and execute queries that use functions, aggregate functions, and subqueries
Use joins and unions to combine datasets
Create, modify, and delete tables, views, and databases
Load data into tables and store query results
Select file formats and develop partitioning schemes for better performance
Use analytic and windowing functions to gain insight into their data
Store and query complex or nested data structures
Process and analyze semi-structured and unstructured data
Optimize and extend the capabilities of Hive and Impala
Determine whether Hive, Impala, an RDBMS, or a mix of these is the best choice for a given task
Utilize the benefits of CDP Public Cloud Data Warehouse
Available Options
Upcoming Sessions
0 sessions availableNo Sessions Scheduled
There are currently no upcoming sessions scheduled for this course.
Request Course Information