Cognitive Class

SQL Access for Hadoop

Ever tried lighting a baseball stadium with a desk lamp? While all lights turn on and off, the trick is to apply the right light to the situation. This course’s content prescribes how to take the familiar workings of SQL and apply them to BIGSQL, illuminating the answers you need.

Start the Free Course

About This Course

There is no learning curve here. Big SQL is about applying SQL to your existing data – there are no proprietary storage formats.

Big SQL is another tool to work with your Hadoop data. Big SQL provides a common and familiar syntax for those that are already using SQL with their relational data to work with their big data.

  • Understand the Big SQL architecture and show the different methods for working with Big SQL.
  • Learn the Big SQL data types and show how to create Big SQL schemas and tables.
  • Learn about the different file formats supported by Big SQL, such as parquet and ORC.
  • Learn how to connect to the Big SQL server and load in some sample data in the hands-on labs.
  • See how easy it is to use Big SQL to work with the data!

Course Syllabus

  • Module 1 - Big SQL Overview
    1. Big SQL features and architecture
    2. Big SQL terminology and methods
  • Module 2 - Big SQL data types
    1. Understand Big SQL data types and file formats
    2. Create Big SQL schemas and tables

General Information

  • This course is free.
  • It is self-paced.
  • It can be taken at any time.
  • It can be audited as many times as you wish.
  • There is only ONE chance to pass the course, but multiple attempts per question (see the Grading Scheme section for details)

Recommended skills prior to taking this course

  • Working knowledge of SQL.

Requirements

Course Staff

Henry Quach, Instructor of SQL Access for Hadoop

Henry L. Quach

Henry L. Quach is the Technical Curriculum Developer Lead for Big Data. He has been with IBM for 9 years focusing on education development. Henry likes to dabble in a number of things including being part of the original team that developed and designed the concept for the IBM Open Badges program. He has a Bachelor of Science in Computer Science and a Master of Science in Software Engineering from San Jose State University.