More Information
Special Product No
Key Note Agilitics courses information , Agilitics courses information
Course feature Enterprise Reporting, Lifetime Access, CloudLabs, 24x7 Support, Real-time code analysis and feedback, Certified Trainer
Interested Audience You learn about, and compare, many of the computing and storage services available in Google Cloud Platform, including Google App Engine, Google Compute Engine, Google Kubernetes Engine, Google Cloud Storage, Google Cloud SQL, and BigQuery. You learn about important resource and policy management tools, such as the Google Cloud Resource Manager hierarchy and Google Cloud Identity and Access Management.

Agilitics courses information , Agilitics courses information

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

  • Certified Trainer

Course Description

Through instructor-led discussion and interactive, hands-on exercises, participants will navigate the ecosystem, learning:

  • How the open source ecosystem of big data tools addresses

    challenges not met by traditional RDBMSs

  • Using Apache Hive and Apache Impala to provide SQL access

    to data

  • Hive and Impala syntax and data formats, including functions

    and subqueries

  • Create, modify, and delete tables, views, and databases; load

    data; and store results of queries

  • Create and use partitions and different file formats

  • Combining two or more datasets using JOIN or UNION, as

    appropriate

  • What analytic and windowing functions are, and how to use

    them

  • Store and query complex or nested data structures

  • Process and analyze semi-structured and unstructured data

  • Techniques for optimizing Hive and Impala queries

  • Extending the capabilities of Hive and Impala using

    parameters, custom file formats and SerDes, and external

    scripts

  • How to determine whether Hive, Impala, an RDBMS, or a mix

    of these is best for a given task

Target Audience

This course is designed for

  • data analysts

  • business intelligence specialists

  • developers

  • system architects

  • database administrators

Prerequisites

Some knowledge of SQL is assumed, as is basic Linux command-line familiarity.

Prior knowledge of Apache Hadoop is not required.

Key Objectives

Upon completion of the course, attendees are encouraged to continue their study and register for the CCA Data Analyst exam. Certification is a great differentiator. It helps establish you as a leader in the field, providing employers and customers with tangible evidence of your skills and expertise.

Prequisitives
You learn about, and compare, many of the computing and storage services available in Google Cloud Platform, including Google App Engine, Google Compute Engine, Google Kubernetes Engine, Google Cloud Storage, Google Cloud SQL, and BigQuery. You learn about important resource and policy management tools, such as the Google Cloud Resource Manager hierarchy and Google Cloud Identity and Access Management.
Interested Audience
You learn about, and compare, many of the computing and storage services available in Google Cloud Platform, including Google App Engine, Google Compute Engine, Google Kubernetes Engine, Google Cloud Storage, Google Cloud SQL, and BigQuery. You learn about important resource and policy management tools, such as the Google Cloud Resource Manager hierarchy and Google Cloud Identity and Access Management.

Get a Peek at Our Success Stories

Featured Review

Puli

Develpoer

One of best I have encountered in my life. Freedom to interact and respond candidly and with courage for every question is not an easy task for Trainers which they did it exceptionally well.

Chun Ngee

Develpoer

The course is well structure. Timing is also right. The trainer Mr Raj is professional. And he asnwer all my question and doubts.

Sarbojit Bose

Develpoer

The course is one of the two in the track of Agile Professional Coach. It is designed to provide both wide and deep knowledge to become a competent Coach with the addirional skills of a Trainer and a Mentor. The two trainers, Preeth Panday and Naveen K Singh, are excellent Facilitators and Coaches with patience and promptness. Their mastery in this area stands out while their mode of delivery captures the interest of the trainees. They demonstrated professionalism with a personal touch.

Training FAQ

Course Outline

  1. Operators

    Scalar Functions

    Aggregate Functions

  2. Complex Data with Hive

    Complex Data with

    Impala

  3. Data Storage

    Creating Databases and

    Tables

    Loading Data

    Altering Databases and

    Tables

    Simplifying Queries with

    Views

    Storing Query Results

  4. Using Regular

    Expressions with Hive

    and Impala

    Processing Text Data

    with SerDes in Hive

    Sentiment Analysis and

    n-grams