Skip to main content

About This Course

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. There is no learning curve here. Big SQL is about applying SQL to your existing data – there are no proprietary storage formats.

This course will help you understand the Big SQL architecture and show the different methods for working with Big SQL. The course will list and explain the Big SQL data types and show how to create Big SQL schemas and table. The course will also cover the different file formats supported by Big SQL such as parquet and ORC.

In the lab exercises, you will get a chance to learn how to connect to the Big SQL server and load in some sample data. Then you will see how easy it is to use Big SQL to work with the data.

Big Data University leverages the services of Pearson VUE Acclaim to assist in the administration of the IBM Open Badge program. By enrolling into this course, you agree to Big Data University sharing your details with Pearson VUE Acclaim for the strict use of issuing your badge upon completion of the badge criteria.

This course was tested and validated for v4 of the QSE Docker Image.

Please download the v4 Docker Image to complete the lab exercises.

https://www-01.ibm.com/marketing/iwm/iwm/web/reg/download.do?source=swg-ibmibqsevmw&S_PKG=ov14336&S_TACT=109HF71W&S_CMP=BigI_BDUBD001V2EN&lang=en_US

Course Syllabus

  • Lesson 1: Big SQL Overview
    • Big SQL features and architecture
    • Big SQL terminology and methods
  • Lesson 2: Big SQL data types
    • Understand Big SQL data types and file formats
    • Create Big SQL schemas and tables

Recommended skills prior to taking this course

  • None

Grading scheme

  • The minimum passing mark for the course is 60%, the final exam is worth 100% of the course mark.
  • You have 1 attempt to take the exam with multiple attempts per question.

Course Staff

Henry L. Quach

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.

Frequently Asked Questions

What web browser should I use?

The Open edX platform works best with current versions of Chrome, Firefox or Safari, or with Internet Explorer version 9 and above.

See our list of supported browsers for the most up-to-date information.

  1. Course Number

    BD0145EN
  2. Classes Start

    Any Time, Self-Paced
  3. Estimated Effort

    4 hours
Enroll