Code: 
DW631G
Duration: 
1-3 Day(s)

Overview

This course is designed to educate you on IBM BigInsights Big SQL. Initially you learn how to set up various BigInsights components to access Big SQL. Next, administration of Big SQL is covered. The student creates Hive tables, local, external, and partitioned, that can be accessed by Big SQL. Then, the same is done for HBase tables. The course winds up covering some query performance topics as well as defining complex structures in a table.

Skills Gained

  • Use the following to access Big SQL
    • JSqsh
    • BigInsights Console
    • BigInsights Eclipse development environment
  • Create schemas
  • Create and load Hive tables
    • Local tables
    • External tables
    • Partitioned tables
  • Create HBase tables and map Big SQL columns to that table
  • Query Big SQL tables
  • User Big SQL query hints to aid in query performance
  • Create tables that have columns made up of complex structures

Audience

This intermediate course is for anyone who might need to query or administer Big SQL tables.

Prerequisites

There are no prerequisites for this course. However, knowledge of SQL and basic knowledge of Hadoop would be beneficial.

Follow-On Courses

There are no follow-ons for this course.

Course Specifics

Course Outline

IBM BigInsights Big SQL Overview

  • Big sQL Server and Clients
  • Big SQL Administration
  • Big sQL HBase Support
  • Big sQL Query Tuning and Complex Data Types

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

a Location Cost Days Date  
Bologna 106 Dec 17
Geneva 120 Nov 17
Stuttgart 120 Nov 17
Ruschlikon 120 Nov 17
Wien 120 Nov 17
Hannover 120 Nov 17
Paris 103 Nov 17
Rome 126 Oct 17
Rome 124 Oct 17
Bristol 317 Oct 17
Birmingham 309 Oct 17
Leeds 305 Oct 17
Eschborn 125 Sep 17
Milan 114 Sep 17
Naples 114 Sep 17
Paris 107 Sep 17
Liverpool 324 Aug 17
Berlin 131 Jul 17
Manchester 326 Jul 17
Glasgow 326 Jul 17
Milan 125 Jul 17
London 318 Jul 17
Rome 113 Jul 17
Warsaw 129 Jun 17
Reading 328 Jun 17
Madrid 126 Jun 17
Exeter 323 Jun 17
Milan 122 Jun 17
Naples 122 Jun 17