Course outline

IBM BigInsights Big SQL

Categories: Guaranteed To Run™, IBM

GK IBM LS Partner

Duration: 1 Day

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.

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.

  • Understand how Big SQL fit into the Hadoop architecture
  • Access Big SQL using:
    • JSqsh
    • BigInsights Web Console
    • BigInsights Eclipse development environment
  • Create schemas and tables
  • Load data into Big SQL tables
  • Query Big SQL tables
  • Use Big SQL statistics (EXPLAIN / ANALYZE)
  • Grant and revoke authority and fine grained access
  • Understand how to set up and to query federated data
  • Use Big SQL 1.0 on data residing in HBase tables

Please refer to Course Overview for description information.

This intermediate course is for users who want to use Big SQL to access or administer their Hadoop data.

  • 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
This course is delivered by an authorized IBM Global Training Provider.

Feel free to contact us, if you want to know the price and location of this course. A Digital Revolver representative will contact you shortly to help you with your inquiry.
Please fill out the form below

  • Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
  • This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.
Privacy and Cookies

This website stores cookies on your computer which help us make the website work better for you.

Learn moreAccept and Close
Social media & sharing icons powered by UltimatelySocial