Software Development Basics
Fundamental principles and concepts
Getting Started with Hive for Relational Database Developers
Traditional databases focus on transactional processing, whereas Hive helps with analytical processing extracted from huge datasets. This course focuses on the similarities and differences between SQL and Hive.
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo
Why choose Core Tech?
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →Price may vary. Check latest price on provider site.
Course Insight
Suitable for beginner learners. This course serves as an entry point into Software Development, building foundational knowledge before moving on to advanced frameworks or specialized paths.
Beginner FriendlySelf-Paced Learning
SKILLS TO
MASTER
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Relevant for professionals pursuing roles within Software Development.
Quick Facts
Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.
What You’ll Learn
- Course Overview : 2mins.
- Hive vs. RDBMS : 34mins.
- Getting Started with Basic Queries in Hive : 29mins.
- Creating Databases and Tables : 39mins.
- Using Complex Data Types and Table Generating Functions : 37mins.
- Understanding Constraints in Subqueries and Views : 21mins.
- Designing Schema for Hive : 11mins.
See side-by-side differences in what you’ll learn
Description
Transactional processing focuses on accessing and updating individual records. Analytical processing works on data in bulk and deals more with summaries across the dataset, trends and insights. The difference in requirements and the kind of data they work on, lead to differences between Hive and traditional databases.
This course, Getting Started with Hive for Relational Database Developers, teaches you about several gotchas involved while using familiar SQL constructs in Hive. You'll learn about loading and parsing data from files, views, subqueries, and some cool built-in functionality such as table generating functions. The course also demonstrates the constraints imposed by Hive architecture choices such as schema on read, denormalized storage in HDFS, and high latency of operations. This serves as a guide for user choices during storage and querying. By the end of this course, you'll feel confident in using Hive for your own relational database uses.
See how this course compares with alternatives
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 4(118+ learners)