IBM BigInsights Big SQL

Overview

This course is designed to introduce you to the capabilities of Big SQL. Big SQL is 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 you would use Big SQL followed by how to use Big SQL to access your data. It will also cover Big SQL federation allowing you to join various data sources with Big SQL. Big SQL also integrates with a number of other components including Spark, HBase and BigSheets.

Learning Journeys or Training Paths that reference this course:

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.

Key topics

  • 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

Objectives

The objectives of this course are:

  1. Using Big SQL to access HDFS data
    • Understand how Big SQL fits in the Hadoop architecture
    • Accessing and using Big SQL
    • Loading data into Big SQL tables  
  2. Querying HDFS data using Big SQL
    • Creating Big SQL schemas and tables
    • List and understand the Big SQL data types
    • Querying Big SQL tables 
  3. Administering and managing 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   
  4. Data federation using Big SQL
    • Understand the concept of Big SQL federation
    • List the supported data sources
    • Set up and configure a federation server to use different data sources   
  5. Using Big SQL operations on tables managed by HBase
    • Describe the basic function of HBase
    • Issuing basic HBase commands
    • Using Big SQL to create and query HBase tables
    • Mapping HBase columns to Big SQL
    • Exploring data modeling options  
  6. Using Spark operations on tables managed by Big SQL
    • Describe the purpose and role of Spark and DataFrames
    • Querying and manipulating Big SQL data through Spark   

Related Articles:

IBM Training Blog:

Enroll

You can enroll in an instructor-led classroom at different geographic locations, instructor-led online course in any timezone or a self-paced online course.

This class has been identified by our Global Training Partner as "Guaranteed to run". View the terms and conditions for full details.

Start Date GTR Country City Duration Language Partner Action
Italy Roma 16 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Italy Torino 16 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Italy Milano 16 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Italy Roma 16 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Australia Syd 24 Hours English Global Knowledge/IT Learning Solution Pty Ltd

Enroll



Skip Sign in

Australia Mel 24 Hours English Global Knowledge/IT Learning Solution Pty Ltd

Enroll



Skip Sign in

United Kingdom London (Arrow) 8 Hours English Arrow ECS

Enroll



Skip Sign in

Nigeria Lagos, NG 8 Hours English Ingram Micro

Enroll



Skip Sign in

Botswana Gaborone, BW 8 Hours English Ingram Micro

Enroll



Skip Sign in

Malaysia Kuala Lumpur, MY 16 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Indonesia Jakarta, ID 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Indonesia Jakarta, ID 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

South Africa Addis Ababa, ET 8 Hours English Ingram Micro

Enroll



Skip Sign in

Namibia Windhoek, NA 8 Hours English Ingram Micro

Enroll



Skip Sign in

Singapore Singapore, SG 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Zimbabwe Harare, ZW 8 Hours English Ingram Micro

Enroll



Skip Sign in

Angola Luanda, AO 8 Hours English Ingram Micro

Enroll



Skip Sign in

Kenya Nairobi, KE 8 Hours English Ingram Micro

Enroll



Skip Sign in

South Africa Johannesburg, ZA 8 Hours English Ingram Micro

Enroll



Skip Sign in

Spain Arrow ECS 8 Hours Spanish Arrow ECS

Enroll



Skip Sign in

Denmark København - Ballerup 8 Hours English Arrow ECS

Enroll



Skip Sign in

Slovakia Bratislava 8 Hours Slovak Global Knowledge/GOPAS SR, a.s.

Enroll



Skip Sign in

France Paris 8 Hours French Arrow ECS

Enroll



Skip Sign in

France Paris 8 Hours French Arrow ECS

Enroll



Skip Sign in

Netherlands Arrow ECS Houten 8 Hours Dutch Arrow ECS

Enroll



Skip Sign in

Czech Republic Praha 8 Hours Czech Global Knowledge/GOPAS SR, a.s.

Enroll



Skip Sign in

Serbia Beograd, RS 8 Hours English Ingram Micro

Enroll



Skip Sign in

Spain Barcelona, ES 8 Hours Spanish Ingram Micro

Enroll



Skip Sign in

Portugal Lisboa, PT 8 Hours Portuguese Ingram Micro

Enroll



Skip Sign in

Italy Rome, IT 8 Hours Italian Ingram Micro

Enroll



Skip Sign in

Austria Vienna, AT 8 Hours German Ingram Micro

Enroll



Skip Sign in

Portugal Lisboa, PT 8 Hours Portuguese Ingram Micro

Enroll



Skip Sign in

Slovakia Bratislava, SK 8 Hours English Ingram Micro

Enroll



Skip Sign in

Czech Republic Prague, CZ 8 Hours English Ingram Micro

Enroll



Skip Sign in

Hungary Budapest, HU 8 Hours English Ingram Micro

Enroll



Skip Sign in

Italy Rome, IT 8 Hours Italian Ingram Micro

Enroll



Skip Sign in

France Paris, FR 8 Hours French Ingram Micro

Enroll



Skip Sign in

Hungary Budapest, HU 8 Hours English Ingram Micro

Enroll



Skip Sign in

Switzerland Zurich, CH 8 Hours German Ingram Micro

Enroll



Skip Sign in

Switzerland Zurich, CH 8 Hours German Ingram Micro

Enroll



Skip Sign in

Poland Warsaw, PL 8 Hours English Ingram Micro

Enroll



Skip Sign in

Germany Frankfurt 8 Hours German Ingram Micro

Enroll



Skip Sign in

Slovakia Bratislava, SK 8 Hours English Ingram Micro

Enroll



Skip Sign in

Slovenia Ljubljana, SI 8 Hours English Ingram Micro

Enroll



Skip Sign in

Slovenia Ljubljana, SI 8 Hours English Ingram Micro

Enroll



Skip Sign in

Spain Barcelona, ES 8 Hours Spanish Ingram Micro

Enroll



Skip Sign in

Germany Frankfurt 8 Hours German Ingram Micro

Enroll



Skip Sign in

Czech Republic Prague, CZ 8 Hours English Ingram Micro

Enroll



Skip Sign in

Serbia Beograd, RS 8 Hours English Ingram Micro

Enroll



Skip Sign in

Ireland Dublin 8 Hours English Ingram Micro

Enroll



Skip Sign in

Austria Vienna, AT 8 Hours German Ingram Micro

Enroll



Skip Sign in

Poland Warsaw, PL 8 Hours English Ingram Micro

Enroll



Skip Sign in

France Paris, FR 8 Hours French Ingram Micro

Enroll



Skip Sign in

France Paris 8 Hours French Global Knowledge

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

Poland Warszawa 8 Hours Polish TechData Inc.

Enroll



Skip Sign in

Poland Warszawa 8 Hours Polish TechData Inc.

Enroll



Skip Sign in

Malaysia Malaysia 8 Hours English TechData Inc.

Enroll



Skip Sign in

Germany Hannover 8 Hours German TechData Inc.

Enroll



Skip Sign in

Switzerland Genève 8 Hours French TechData Inc.

Enroll



Skip Sign in

Austria Wien 8 Hours German TechData Inc.

Enroll



Skip Sign in

Romania Bucuresti 8 Hours Romanian TechData Inc.

Enroll



Skip Sign in

Switzerland Rotkreuz 8 Hours German TechData Inc.

Enroll



Skip Sign in

India Bangalore 8 Hours English TechData Inc.

Enroll



Skip Sign in

Switzerland Genève 8 Hours French LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Switzerland Genève 8 Hours French LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Switzerland Genève 8 Hours French LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Switzerland Glattbrugg 8 Hours German LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Italy Bologna 8 Hours Italian LearnQuest/Overnet Solutions Ltd.

Enroll



Skip Sign in

Italy Roma 8 Hours Italian LearnQuest/Overnet Solutions Ltd.

Enroll



Skip Sign in

Italy Roma 8 Hours Italian Arrow ECS/Fast Lane

Enroll



Skip Sign in

United Kingdom London (Arrow) 8 Hours English Arrow ECS

Enroll



Skip Sign in

United Kingdom London (Arrow) 8 Hours English Arrow ECS

Enroll



Skip Sign in

Germany Stuttgart 8 Hours German Arrow ECS/Fast Lane

Enroll



Skip Sign in

Duration Delivery Type Language Partner Action
8 HoursSelf-paced Virtual CourseEnglishLearnQuest

Enroll



Skip Sign in

Start Date My Time Zone GTR Country Duration Language Partner Action
Worldwide8 HoursEnglishArrow ECS

Enroll



Skip Sign in

Worldwide8 HoursEnglishIngram Micro

Enroll



Skip Sign in

Worldwide8 HoursEnglishIngram Micro

Enroll



Skip Sign in

Worldwide8 HoursFrenchGlobal Knowledge

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide8 HoursEnglishTechData Inc./ExitCertified

Enroll



Skip Sign in

Worldwide8 HoursFrenchLearnQuest

Enroll



Skip Sign in

Worldwide8 HoursGermanLearnQuest

Enroll



Skip Sign in

Worldwide8 HoursEnglishLearnQuest

Enroll



Skip Sign in

Worldwide8 HoursEnglishLearnQuest

Enroll



Skip Sign in