Loading...

DW633G – IBM BigInsights Big SQL

Home / DW633G – IBM BigInsights Big SQL

This course introduces students to the capabilities of Big SQL, a part of IBM BigInsights that allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data. This course will provide some context on why students would use Big SQL, followed by how to use Big SQL to access data. It will also cover Big SQL federation allowing students to join various data sources with Big SQL. Big SQL also integrates with a number of other components including Spark, HBase and BigSheets.

Course Length: 1 day(s)

Course Price: $750 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom

Enroll Now

Course: DW633G – IBM BigInsights Big SQL

Understand how Big SQL fit in the Hadoop architecture

Creating Big SQL schemas and tables

Loading data into Big SQL tables

List and understand the Big SQL data types

Querying Big SQL tables

Understanding Big SQL data access plans

Controlling data access using column masking and row-based access control

Using Big SQL statistics to improve query performance

Setting up and using Big SQL federation

Using Big SQL operations on tables managed by HBase

Using Spark operations on data managed by Big SQL

Audience:

This intermediate course is designed for developers and administrators that want to use Big SQL to access and administer their Hadoop data

Prerequisites:

You should be familiar with SQL, Hadoop, and the Linux file system.

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.