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:
- Instructor Led Online
- Self-Paced Virtual Classroom
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
This intermediate course is designed for developers and administrators that want to use Big SQL to access and administer their Hadoop data
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.
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.