Course details

This course is designed to help students understand and use Big SQL. Students will learn to use different BigInsights components to access Big SQL to access and analyze their Hadoop data

Next, the course will cover Big SQL data types where students will learn how to work with the data in Big SQL tables. Students will also learn how to use the EXPLAIN and ANALYZE commands to understand the performance of their queries.

The course will then go into Big SQL administration showing students how to grant and revoke authority to control access to their data, including fine grained access control.

The course will then cover data federation to allow users to be able to create queries from various data sources. Finally, this course will cover how to use Big SQL 1.0 with HBase tables.

Target Audience:

  • This intermediate course is for users who want to use Big SQL to access or administer their Hadoop data

Objectives:

  • Understand how Big SQL fit into the Hadoop architecture
  • Load data into Big SQL tables
  • Access Big SQL using:
  • JSqsh
  • BigInsights Web Consol
  • BigInsights Eclipse development environment
  • Create schemas and tables
  • Load data into Big SQL tables
  • Query Big SQL tables
  • Use Big SQL statistics (EXPLAIN / ANALYZE)
  • Grant and revoke authority and fine grained access
  • Understand how to set up and to query federated data
  • Use Big SQL 1.0 on data residing in HBase tables

Pre-Requisites

Please refer to Course Overview for description information.

Updated on 13 August, 2015

About Global Knowledge Egypt

Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.

See all Global Knowledge Egypt courses
Are you from Global Knowledge Egypt ? Claim your course!
Courses you can instantly connect with... Do an online course on MySQL starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or