About this Course

102,231 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 12 hours to complete
English

What you will learn

  • Distinguish operational from analytic databases, and understand how these are applied in big data

  • Understand how database and table design provides structures for working with data

  • Appreciate how differences in volume and variety of data affects your choice of an appropriate database system

  • Recognize the features and benefits of SQL dialects designed to work with big data systems for storage and analysis

Skills you will gain

Database (DBMS)Data WarehousingData AnalysisBig DataSQL
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 12 hours to complete
English

Instructor

Offered by

Placeholder

Cloudera

Syllabus - What you will learn from this course

Content RatingThumbs Up97%(2,240 ratings)Info
Week
1

Week 1

2 hours to complete

Data and Databases

2 hours to complete
11 videos (Total 50 min), 4 readings, 1 quiz
11 videos
Welcome to the Course and Week 13m
What Is Data?3m
Why Organize Data?5m
What Does a DBMS Do?5m
Relational Databases and SQL6m
The Success of RDBMSs and SQL4m
Operational and Analytic Databases5m
Comparing Operational and Analytic DBs: SELECT Statements2m
Comparing Operational and Analytic DBs: DML Activity4m
Operational and Analytic Databases: Further Comparisons1m
4 readings
Hardware Requirements for the Exercise Environment10m
Data Extraction from Digital Images10m
Three Notes about SQL10m
References10m
1 practice exercise
Data and Databases30m
Week
2

Week 2

3 hours to complete

Relational Databases and SQL

3 hours to complete
15 videos (Total 80 min), 3 readings, 1 quiz
15 videos
Introducing Table Schemas3m
NULL Values3m
Data Types3m
Primary Keys5m
Foreign Keys6m
Two Strategies for Database Design3m
Database Normalization8m
Denormalization5m
Differences6m
Trade-offs4m
Database Transactions6m
ACID6m
Enforcing Business Rules: Constraints and Triggers7m
Business Rules and ACID for Analytics?6m
3 readings
Let There Be Third Normal Form5m
SELECT Statements in Transactions5m
Database Indexes30m
1 practice exercise
Relational Databases30m
Week
3

Week 3

2 hours to complete

Big Data

2 hours to complete
12 videos (Total 63 min), 1 reading, 1 quiz
12 videos
How Big Is Big Data?3m
Distributed Storage6m
Distributed Processing9m
Structured Data4m
Unstructured Data4m
Semi-Structured Data3m
Strengths of Traditional RDBMSs4m
Limitations of Traditional RDBMSs7m
SQL and Structured Data5m
SQL and Semi-structured Data4m
SQL and Unstructured Data7m
1 reading
What about Velocity?15m
1 practice exercise
Big Data30m
Week
4

Week 4

2 hours to complete

SQL Tools for Big Data Analysis

2 hours to complete
12 videos (Total 53 min), 1 reading, 1 quiz
12 videos
Big Data Analytic Databases (Data Warehouses)2m
NoSQL: Operational, Unstructured and Semi-structured4m
Non-transactional, Structured Systems2m
Big Data ACID-Compliant RDBMSs1m
Search Engines4m
Challenges4m
What We Keep3m
What We Give Up5m
What We Add8m
Where to Store Big Data7m
Coupling of Data and Metadata7m
1 reading
Open Source and Apache15m
1 practice exercise
SQL Tools for Big Data Analysis30m

Reviews

TOP REVIEWS FROM FOUNDATIONS FOR BIG DATA ANALYSIS WITH SQL

View all reviews

About the Modern Big Data Analysis with SQL Specialization

Modern Big Data Analysis with SQL

Frequently Asked Questions

More questions? Visit the Learner Help Center.