Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

SQL on Hadoop - Analyzing Big Data with Hive

SQL on Hadoop - Analyzing Big Data with Hive

1425/month
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Intermediate
Login to earn ₹ 100

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Why should you choose this course?

Description

This course will teach you the Hive query language and how to apply it to solve common Big Data problems. This includes an introduction to distributed computing, Hadoop, and MapReduce fundamentals and the latest features released with Hive 0.11

Syllabus

Introduction
Motivation for Hadoop
Distributed Computing Challenges
Hadoop File System (HDFS)
MapReduce
Word Count Example
Demo: Basic Hadoop Commands and Environment Setup
Summary
Introduction
Hive Motivation
Hive Architecture
Hive Principles - Schema on Read
Hive Principles - The Hive Warehouse
Hive Query Language Basics - SELECT and Sub Queries
Creating Databases and Tables with HiveQL
Demo: Working with Hive Tables and Loading Data into Warehouse
Loading Data - Hive Managed and External Tables
Demo: External Tables and Create Table Alternatives
Summary
Introduction
Data Types
Type Conversions
Managed Partitioned Tables
External Partitioned Tables
Demo: Table Partitioning
Multi Inserts and Dynamic Partition Inserts
Demo: Loading Data Use Case
Data Retrieval - Group By and Functions
Sorting and Controlling Data Flow
The CLI and Variable Substitution
Summary
Introduction
Bucketing
Bucket and Block Sampling
Joins
Joins in Depth and Join Optimizations
Map-side Joins for Bucketed Tables
Distributed Cache
UDTFs, Explode and Lateral View
Demo: Extending Hive - Creating Your own UDF
Demo: Extending Hive - Compiling and Testing Custom UDF
Extending Hive - Custom UDF Recap
Demo: Hive Initialization File
Accessing The Distributed Cache
Hadoop Streaming and Transform()
Windowing and Analytics Functions
Demo: Putting it All Together Using Transform
Demo: Analytics Functions
Demo: Ranking Functions
Summary
Create Table Statement - File Formats and SerDes
HCatalog
Sqoop
DistCP
Hadoop Eco-System Projects
References and Resources
Summary

What others say about this course

FAQs

What is SQL?

Structured Query Language (SQL) is a domain-specific language designed for data management for RDBMS. SQL comes particularly handy in managing structured data and offers certain advantages, such as allowing the access of multiple records through a single command and eliminating the need to specify how to access a record. In simpler words, SQL provides tools to the programmer to define, control and manipulate data in a relational model including tables, rows, and columns.

What are the Prerequisites for learning SQL?

If you wish to learn SQL programming, know the prerequisites well for a smooth learning journey. SQL is a basic query language used primarily for databases, coming with no prerequisites as such. With a simple syntax, there aren't many specific requirements, but it would be helpful to learn database concepts, calculus theories, and basic RDBMS concepts. Once you get a hold of these concepts, you are good to go.

Why should you learn SQL?

SQL query is purely a text message application which can help you access data. SQL is used for most relational storage systems, and it is more of a query language than a programming language. Learning SQL helps the programmers in accessing data with greater efficiency through basic queries. It is predominantly effectual for data manipulation, and the data stored in SQL is dynamic, which means it can be manipulated and modified at any point of time using a set of basic queries. These features make SQL fully equipped to manage datasets of all shapes and sizes.

How can Edvicer help you find the best SQL courses?

Edvicer is a great place to learn SQL with a large number of SQL courses, both free and paid, and projects, both for practice and freelancing. Edvicer has helped a large number of people learn SQL online through the best courses from the top providers like Coursera, Udemy, Udacity, and Pluralsight.

What are the top jobs that I can get from learning SQL?

The top job profile for SQL experts are Dotnet Developer with an average salary of INR 5 LPA, Software Engineer with an average salary of INR 7 LPA, and Database Administrator with an average salary of INR 7 LPA. Get your career map for your skills here.

What can I learn after learning SQL?

After learning SQL, the top skills you can learn to open highest number of job profiles for you are Python, Java, and Data Analytics. The top skills that can get you jobs with highest salaries are Node.js, Data Mining, and Statistical Modeling

Write your review of SQL on Hadoop - Analyzing Big Data with Hive

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer