Data and Databases-Introduction
Welcome to the Specialization
()
Welcome to the Course and Week 1
()
Hardware Requirements for the Exercise Environment
Data and Databases-Organizing Data
What Is Data?
()
Why Organize Data?
()
Data Extraction from Digital Images
Data and Databases-Working with Database Systems
What Does a DBMS Do?
()
Relational Databases and SQL
()
Three Notes about SQL
The Success of RDBMSs and SQL
()
References
Data and Databases-Operational and Analytic Databases
Operational and Analytic Databases
()
Comparing Operational and Analytic DBs: SELECT Statements
()
Comparing Operational and Analytic DBs: DML Activity
()
Operational and Analytic Databases: Further Comparisons
()
Relational Databases and SQL-Introduction to Week 2
Welcome to Week 2
()
Relational Databases and SQL-Table and Column Design
Introducing Table Schemas
()
NULL Values
()
Data Types
()
Relational Databases and SQL-Relational Database Design
Primary Keys
()
Foreign Keys
()
Two Strategies for Database Design
()
Database Normalization
()
Denormalization
()
Differences
()
Trade-offs
()
Let There Be Third Normal Form
Relational Databases and SQL-Database Transactions
Database Transactions
()
ACID
()
SELECT Statements in Transactions
Enforcing Business Rules: Constraints and Triggers
()
Business Rules and ACID for Analytics?
()
Database Indexes
Big Data-Introduction to Week 3
Welcome to Week 3 and the Three Vs of Big Data
()
Big Data-Volume
How Big Is Big Data?
()
Distributed Storage
()
Distributed Processing
()
Big Data-Variety (and Velocity)
Structured Data
()
Unstructured Data
()
Semi-Structured Data
()
What about Velocity?
Big Data-Big Data Systems: How do they differ from traditional systems?
Strengths of Traditional RDBMSs
()
Limitations of Traditional RDBMSs
()
Big Data-How Structure Affects What You Can Do
SQL and Structured Data
()
SQL and Semi-structured Data
()
SQL and Unstructured Data
()
SQL Tools for Big Data Analysis-Introduction to Week 4
Welcome to Week 4
()
Open Source and Apache
SQL Tools for Big Data Analysis-Big Databases, Big Data Stores, and SQL
Big Data Analytic Databases (Data Warehouses)
()
NoSQL: Operational, Unstructured and Semi-structured
()
Non-transactional, Structured Systems
()
Big Data ACID-Compliant RDBMSs
()
Search Engines
()
SQL Tools for Big Data Analysis-Features of SQL for Big Data Analysis
Challenges
()
What We Keep
()
What We Give Up
()
What We Add
()
SQL Tools for Big Data Analysis-Different Big Data Stores
Where to Store Big Data
()
Coupling of Data and Metadata
()
Introduction to the Hands-On Environment-Introduction to Week 5
Welcome to Week 5
()
Instructions for Downloading and Installing the Exercise Environment
Troubleshooting the VM
Introduction to the Hands-On Environment-Operation of Apache Hive and Apache Impala
Apache Hive
()
Apache Impala
()
Introduction to the Hands-On Environment-Exploring Databases and Tables with Hue
Exploring Structured Data in Hue
()
Introduction to the Hands-On Environment-Cloudera Certified Associate Data Analyst Certification
Welcome to the Honors Track
()
Preparation for the Quiz
Honors Track Conclusion
()