- Welcome to the Course
- Review and Preparation
- Using the Hue Query Editors
- Running SQL Utility Statements
- Running SQL SELECT Statements
- Understanding Different SQL Interfaces
- Overview of Beeline and Impala Shell
- Using Beeline
- Using Impala Shell
Beginner
Online
6 Weeks
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
Analyzing Big Data with SQL Certification by Coursera offers its learners an extensive analysis of the SQL SELECT statement and its main clauses. Candidates will have the opportunity to study big data SQL engines Apache Impala and Apache Hive. Additionally, their acquired learning can be implemented to SQL with traditional RDBMS as well. The experienced instructor from Cloudera comprehensively deals with the differences between MySQL and PostgreSQL.
This beginner-level, free-flowing course has been made for a wider audience who wish to learn about querying big data with modern distributed SQL engines. Now that traditional relational databases have become insufficient for large packets of data, the data cannot be stored in commercial data warehouses anymore. As a result, the concepts of distributed clusters and cloud storage have started to gain momentum.
Learning about the cost-efficient and infinitely scalable data stores in Analyzing Big Data with SQL Certification Syllabus will expose them to newer concepts of the SQL engine. Course modules have holistically covered open-source SQL engines capable of querying enormous datasets. All in all, this course proves to be highly relevant for data analysts.
The highlights
- 18 hours of interactive online learning
- 24*7 access to course material
- Self-paced format
- Free trial for seven days
- Offered by Cloudera
Course and certificate fees
Analyzing Big Data with SQL Certification Fee after the free trial will be levied as follows-
- The above provision shall not be applicable to those who are studying on financial aid.
Fee Details for Analyzing Big Data with SQL
Particulars | Fee Amount in INR |
Analyzing Big Data with SQL - Audit course | Free |
Analyzing Big Data with SQL - 1 month | Rs.4,015/- |
Analyzing Big Data with SQL - 3 months | Rs.8,031/- |
Analyzing Big Data with SQL - 6 months | Rs.12,046/- |
certificate availability
certificate providing authority
Eligibility criteria
Certification qualifying details
Analyzing Big Data with SQL Certification Programme is part of a specialisation. However, candidates can receive Analyzing Big Data with SQL Certification by completing this course successfully. It not only includes passing all required assignments but also paying for the certificate after account verification.
What you will learn
Analyzing Big Data with SQL Certification Course has been designed to help candidates get a theory-based and practical experience of handling big data with SQL. It amplifies the following concepts-
- Learners will explore grouping and aggregation to answer analytical questions.
- They will start working with sorting and limiting results.
- This course will teach them how to combine multiple tables in different ways.
- They shall understand how and why to filter results.
- They will get first-hand experience of Apache Hive and Apache Impala.
- They will also understand the basics of SELECT statements.
- They shall get an insight into common aggregate functions.
- They will navigate through and explore databases and tables using different tools.
Admission details
Anyone can enrol for the Analyzing Big Data with SQL Certification Training by following the simple steps-
Step 1: Go to the official course webpage and click on “Enroll for Free.”
Step 2: Depending upon whether you choose to audit the course or take a trial, it will lead you to the course dashboard.
Step 3: If you choose the latter, you need to provide your card information.
The syllabus
Week 1: Orientation to SQL on Big Data
Videos
Readings
- Instructions for Downloading and Installing the Exercise Environment
- Troubleshooting the VM
- (Optional) What about Spark SQL?
- Expectations for Learners
- (Optional) Using Other SQL Engines
Practice exercises
- Week 1 Core Quiz
- Week 1 Honors Quiz
Week 2: SQL SELECT essentials
Videos
- Introduction
- SQL SELECT Building Blocks
- Introduction to the SELECT List
- Expressions and Operators
- Data Types
- Column Aliases
- Built-In Functions
- Data Type Conversion
- The DISTINCT Keyword
- Introduction to the FROM Clause
- Identifiers
- Formatting SELECT Statements
- Using Beeline in Non-Interactive Mode
- Using Impala Shell in Non-Interactive Mode
- Formatting the Output of Beeline and Impala Shell
- Saving Hive and Impala Query Results to a File
Readings
- Order of Operations
- Division and Modulo Operators
- Common String Functions
- Case (In)Sensitivity in SQL
Practice exercises
- Week 2 Core Quiz
- Week 2 Honors Quiz
Week 3: Filtering data
Videos
- Introduction1m
- About the Datasets
- Introduction to the WHERE Clause
- Using Expressions in the WHERE Clause
- Comparison Operators
- Data Types and Precision
- Logical Operators
- Other Relational Operators
- Understanding Missing Values
- Handling Missing Values
- Conditional Functions
- Using Variables with Beeline and Impala Shell
- Calling Beeline and Impala Shell from Scripts
- Querying Hive and Impala in Scripts and Applications
Readings
- Data Reference
- (Optional) Unicode Characters
- Working with Literal Strings
- Missing Values with Logical Operators
- Missing Values in String Columns
- (Optional Exercise) Change VM Desktop Color
Practice exercises
- Week 3 Core Quiz
- Week 3 Honors Quiz
Week 4: Grouping and Aggregating Data
Videos
- Introduction
- Introduction to Aggregation
- Common Aggregate Functions
- Using Aggregate Functions in the SELECT Statement
- Introduction to the GROUP BY Clause
- Choosing an Aggregate Function and Grouping Column
- Grouping Expressions
- Grouping and Aggregation, Together and Separately
- NULL Values in Grouping and Aggregation
- The COUNT Function
- Tips for Applying Grouping and Aggregation
- Filtering on Aggregates
- The HAVING Clause
- Understanding Hive and Impala Version Differences
- Understanding Hue Version Differences
Readings
- COUNT(*) and SUM(1)
- Interpreting Aggregates: Populations and Samples
- The least and greatest Functions
- Why Aggregate Expressions Ignore NULL Values
- (Optional) Shortcuts for Grouping
- How Grouping and Aggregation Can Mislead
Practice exercises
- Week 4 Core Quiz
- Week 4 Honors Quiz
Week 5: Sorting and Limiting Data
Videos
- Introduction
- Introduction to the ORDER BY Clause
- Controlling Sort Order
- Ordering Expressions
- Missing Values in Ordered Results
- Using ORDER BY with Hive and Impala
- Introduction to the LIMIT Clause
- When to Use the LIMIT Clause
- Using LIMIT with ORDER BY
- Using LIMIT for Pagination
- Review
- How to Effectively Use the Hive and Impala Documentation
- Tips for Using the Hive Documentation
- Tips for Using the Impala Documentation
Reading
Ordering by string column
Practice exercises
- Week 5 Core Quiz
- Week 5 Honors Quiz
Week 6: Combining data
Videos
- Introduction
- Combining Query Results with the UNION Operator
- Using ORDER BY and LIMIT with UNION
- Introduction to Joins
- Join Syntax
- Inner Joins
- Outer Joins
- Conclusion
- Handling NULL Values in Join Key Columns
- Non-Equijoins
- Cross Joins
- Left Semi-Joins
Readings
- Missing or Truncated Values from Type Conversion
- Using UNION to Combine Three or More Results
- Alternative Join Syntax
- Joining Three or More Tables
- Specifying Two or More Join Conditions
Practice exercises
- Week 6 Core Quiz
- Week 6 Honors Quiz
Scholarship Details
You can apply on the course page to avail of the financial aid for Analyzing Big Data with SQL Certification Online Course. The mode of application is online and requires the participant to answer some essay-based questions. If the application gets approved within 15 days, the participant can pursue the certification for free.
How it helps
Analyzing Big Data with SQL Certification benefits its learners with hands-on experience in transforming complex data into clear insights. Cloudera is known to deliver enterprise data clouds for data of any kind and anywhere from the Edge to AI. Powered by constant innovation, Cloudera is known to spike digital transformation for some of the world’s largest enterprises.
Analyzing Big Data with SQL Certification Training deals with two of the most widely deployed query engines-Hive and Impala. As a specialization course, it will widen their knowledge and skills to help them prepare for the Cloudera Certified Associate (CCA) Data Analyst Certification exam that will prepare them for relevant jobs. This certification can be earned by taking a hands-on practical exam on Hive and Impala covered in this course.
Pursuing this course will prepare candidates for handling large-scale data using SQL and make their mark in their organisation. Whether the learner is new to SQL and wants to learn the basics or possesses prior experience using SQL, this course will benefit everyone. Exposure to smaller-scale data with relational databases in a hands-on environment will require working on virtual machines and software.
Instructors
Mr Ian Cook
Staff Curriculum Developer
Cloudera
FAQs
This course will majorly benefit data analysts, but it can be pursued by anyone who wants to know more about SQL.
The candidate will have to cancel their trial before the seven-day limit.
No, this course is merely for learning. It helps enhance a candidate’s professional portfolio.
It means that the assignment will not contribute to the candidate’s final grade for certification.
An assignment could be locked if its deadline has not yet arrived. The deadline is mentioned on the course page, and the assignment will only be accessible on that day.
No, learners need to ensure that they access the course on a desktop only.
Candidates need to ensure their software/hardware has 8 GB RAM and at least 25GB of free disk space.
Honors quizzes are additional exercises to help candidates prepare for the certification and other professional exams.
Yes. If a candidate pre-pays for the specialization, he will have to pay less than what he would pay for each course separately.
Articles
Popular Articles
Similar Courses
Computational Thinking and Big Data
The University of Adelaide, Adelaide via Edx
Big Data and Language 1
Korea Advanced Institute of Science and Technology, Daejeon via Coursera
Security and Privacy for Big Data-Part 2
EIT Digital via Coursera
Big Data Foundation
Board Infinity
Big Data and Language 2
Korea Advanced Institute of Science and Technology, Daejeon via Coursera
Foundations for Big Data Analysis with SQL
Cloudera via Coursera
Managing Big Data in Clusters and Cloud Storage
Cloudera via Coursera
Foundations of Mining Non-Structured Medical Data
EIT via Coursera
Biostatistics for Big Data Applications
The University of Texas Medical Branch, Galveston via Edx
Knowledge Management and Big Data in Business
The Hong Kong Polytechnic University, Hong Kong via Edx
Courses of your interest
C++ Foundation
PW Skills
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Data Analysis with Excel for Complete Beginners
CloudSwyft Global Systems, Inc via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
Data Science Fundamentals on Microsoft Azure
CloudSwyft Global Systems, Inc via Futurelearn
Artificial Intelligence Projects
Great Learning