Foundations for Big Data Analysis with SQL

Categories: Data Programs, Modern Big Data Analysis with SQL Specialization

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

Course Content

Module 1: Data and Databases

Welcome to the Specialization

00:00
Welcome to the Course and Week 1

00:00
What Is Data?

00:00
Why Organize Data?

00:00
What Does a DBMS Do?

00:00
Relational Databases and SQL

00:00
The Success of RDBMSs and SQL

00:00
Operational and Analytic Databases

00:00
Comparing Operational and Analytic DBs: SELECT Statements

00:00
Comparing Operational and Analytic DBs: DML Activity

00:00
Operational and Analytic Databases: Further Comparisons

00:00

4 readings

1 quiz

1 discussion prompt

Module 2: Relational Databases and SQL

Welcome to Week 2

00:00
Introducing Table Schemas

00:00
NULL Values

00:00
Data Types

00:00
Primary Keys

00:00
Foreign Keys

00:00
Two Strategies for Database Design

00:00
Database Normalization

00:00
Denormalization

00:00
Differences

00:00
Trade-offs

00:00
Database Transactions

00:00
ACID

00:00
Enforcing Business Rules: Constraints and Triggers

00:00
Business Rules and ACID for Analytics?

00:00

3 readings

1 quiz

1 discussion prompt

Module 3: Big Data

Welcome to Week 3 and the Three Vs of Big Data

00:00
How Big Is Big Data?

00:00
Distributed Storage

00:00
Distributed Processing

00:00
Structured Data

00:00
Unstructured Data

00:00
Semi-Structured Data

00:00
Strengths of Traditional RDBMSs

00:00
Limitations of Traditional RDBMSs

00:00
SQL and Structured Data

00:00
SQL and Semi-structured Data

00:00
SQL and Unstructured Data

00:00

1 reading

1 quiz

1 discussion prompt

Module 4: SQL Tools for Big Data Analysis

Welcome to Week 4

00:00
Big Data Analytic Databases (Data Warehouses)

00:00
NoSQL: Operational, Unstructured and Semi-structured

00:00
Non-transactional, Structured Systems

00:00
Big Data ACID-Compliant RDBMSs

00:00
Search Engines

00:00
Challenges

00:00
What We Keep

00:00
What We Give Up

00:00
What We Add

00:00
Where to Store Big Data

00:00
Coupling of Data and Metadata

00:00

1 reading

1 quiz

1 discussion prompt

Module 5: Introduction to the Hands-On Environment

3 readings

1 quiz

1 peer review

1 discussion prompt

Student Ratings & Reviews

No Review Yet

No Review Yet

error: Content is protected !!