Online Course – Cloudera Certified Professional Specialization in Modern Big Data Analytics

Learn data analysis for big data. Master the use of SQL to analyze data in distributed large data sets.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת בניתוח נתונים גדול מודרני של Cloudera

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Working with large-scale data using SQL
  • Understanding of traditional relational databases
  • Working with distributed databases and cloud storage
  • Using distributed SQL engines like Hive, Impala, Presto, and Drill
  • Cloudera Certified Data Analyst (CCA) Certification Exam Preparation
  • Performing practical handwork tasks
  • Obtaining a certificate of specialization

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • SQL key
  • Database Administrator
  • Data Engineer
  • Big Data Expert
  • Data Analyst
  • BI developer
  • Data programmer
  • Data storage specialist
  • Data Project Manager

Internship – 3-part course series

This specialization teaches the essential skills for working with large-scale data using SQL. Whether you’re new to SQL or already have experience, this specialization is for you.

Most SQL courses focus on traditional relational databases, but today more and more data is stored in distributed clusters and cloud storage. These data stores are cost-effective and infinitely scalable.

Distributed SQL engines

  • Hive
  • Impala
  • Hurry
  • Drill

This specialization focuses on Hive and Impala, which are the most widely deployed query engines on the market.

Certification

This specialization is designed to prepare you for the Cloudera Certified Data Analyst (CCA) certification exam. You can earn this certification by passing a hands-on exam on the same SQL engines that this specialization teaches.

Hands-on Learning Project

Each course in the specialization includes a peer-reviewed hands-on assignment. To earn the Internship Certificate, you must successfully complete the hands-on assignment in each course.

Details of the courses that make up the specialization

Big Data Analysis Basics with SQL

Course 1

Duration: 11 hours

Rating: 4.7 (1,081 ratings)

What you’ll learn

  • Distinguish between operational and analytical databases.
  • Understand how database and table design provides structures for working with data.
  • Appreciate the impact of differences in the quantity and variety of data on the selection of the appropriate database system.
  • Get to know the features and benefits of the SQL dialect for working with large data systems.

Skills you will develop

  • Big data
  • Data Analytics
  • Data storage
  • Database (DBMS)
  • SQL

Big Data Analysis with SQL

Course 2

Duration: 17 hours

Rating: 4.8 (525 ratings)

What you’ll learn

  • Understand the basics of SELECT commands.
  • Understand how and why to filter results.
  • Explore grouping and aggregation to answer analytical questions.
  • Work with sorting and limiting results.

Skills you will develop

  • Big data
  • Data Analytics
  • Apache Impala
  • SQL
  • Apache Hive

Managing big data in clusters and cloud storage

Course 3

Duration: 20 hours

Rating: 4.7 (295 ratings)

What you’ll learn

  • Use various tools to browse databases and tables in large data sets.
  • Use various tools to explore files in distributed file systems and cloud storage.
  • Create and manage databases and tables in big data using Apache Hive and Apache Impala.
  • Describe and choose between different data types and formats for large data systems.

Skills you will develop

  • Big data
  • Distributed file systems
  • SQL
  • Cloud storage
  • Data Management

Related products