IBM BigInsights Big SQL - WBT


Preis auf Anfrage
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Kurs
  • Wann:

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

Wichtige informationen

Wo und wann

Beginn Lage

Häufig gestellte Fragen

· Voraussetzungen

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


This course is designed to educate the student on IBM BigInsights Big SQL. Initially, the student learns 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.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

Training Paths that reference this course are:

  • Streams & BigInsights
  • Streams & BigInsights

Zusätzliche Informationen

  • 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
  • Use Big SQL query hints to aid in query performance
  • Create tables that have columns made up of complex structures

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen