ILT - DANA-262: Analyzing with Cloudera Data Warehouse - 3710034




Upcoming Sessions


This four-day 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.

What you'll learn

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

What to expect

This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Some knowledge of SQL is assumed, as is basic Linux command-line familiarity.



Virtual Classroom, [APAC, EMEA, AMER]

9:00 - 17:00 (TIMEZONE)


By completing/passing this course, you will attain the certificate Cloudera OnDemand and ILT Certificate (Centered, Updated)

Currently no reviews submitted

Shopping Cart

Your cart is empty