Hadoop Architecture and SQL

Hadoop Architecture and SQL

Bascom  Bridge  is a platform that facilitates distributed processing of large data sets across multiple computers. Architecture and SQL training class teaches students the basic and advanced concepts of Hadoop architecture and SQL.

HADOOP AND SQL TRAINING OBJECTIVES

All students will learn:

• Basic SQL Functions
• The WHERE Clause
• Distinct Vs. Group By
• Aggregation Function
• Join Functions
• Date Functions
• OLAP Functions
• Temporary Tables
• Sub-query Functions
• Strings
• Interrogating the Data
• View Functions
• Set Operators
• Data Manipulation Language (DML)
• Statistical Aggregate Functions

HADOOP AND SQL TRAINING PREREQUISITES

No prior experience is required.

HADOOP AND SQL TRAINING MATERIALS

All Hadoop training students receive comprehensive courseware.

SOFTWARE NEEDED FOR EACH PC:

Internet access via Firefox, Chrome, or Internet Explorer is required in order to access the remote environment used for this training.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

HADOOP AND SQL TRAINING OUTLINE

• Introduction
• The Concepts of Hadoop
• The Basics of SQL
• The WHERE Clause
• Distinct, Group By, Limit and Sample
• Aggregation
• Join Functions
• Sub-query Functions
• Date Functions
• OLAP Functions
• Temporary Tables
• Strings
• Interrogating the Data
• View Functions
• Creating Databases and Tables
• Data Manipulation Language (DML)
• Statistical Aggregate Functions
• Hadoop EXPLAIN
• Conclusion