IBM BigInsights Big SQL

Contenuti del corso

This course is designed to help students understand and use Big SQL. Students will learn to use different BigInsights components to access Big SQL to access and analyze their Hadoop data

Next, the course will cover Big SQL data types where students will learn how to work with the data in Big SQL tables. Students will also learn how to use the EXPLAIN and ANALYZE commands to understand the performance of their queries.

The course will then go into Big SQL administration showing students how to grant and revoke authority to control access to their data, including fine grained access control.

The course will then cover data federation to allow users to be able to create queries from various data sources. Finally, this course will cover how to use Big SQL 1.0 with HBase tables.

Contenuti dettagliati del corso

• Big SQL overview and architecture
• Accessing Big SQL using: JSqsh, BigInsights Web Console, BigInsights Eclipse development environment
• Big SQL schemas and tables
• Big SQL data types
• Big SQL statistics
• Big SQL authorities and fine grained access
• Big SQL data federation
• Big SQL 1.0 HBase support