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

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Hadoop Architecture and SQL

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : HDP-120
  •  Theory : 50%
  •  Lab : 50%
  • Duration : 18 hours

PREREQUISITES:

No prior experience is required.

Scroll Up
Skip to toolbar