Acerca de este Curso

102,231 vistas recientes
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel principiante
Aprox. 12 horas para completar
Inglés (English)

Qué aprenderás

  • 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

Habilidades que obtendrás

Database (DBMS)Data WarehousingData AnalysisBig DataSQL
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel principiante
Aprox. 12 horas para completar
Inglés (English)

Instructor

ofrecido por

Placeholder

Cloudera

Programa - Qué aprenderás en este curso

Calificación del contenidoThumbs Up97%(2,240 calificaciones)Info
Semana
1

Semana 1

2 horas para completar

Data and Databases

2 horas para completar
11 videos (Total 50 minutos), 4 lecturas, 1 cuestionario
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 lecturas
Hardware Requirements for the Exercise Environment10m
Data Extraction from Digital Images10m
Three Notes about SQL10m
References10m
1 ejercicio de práctica
Data and Databases30m
Semana
2

Semana 2

3 horas para completar

Relational Databases and SQL

3 horas para completar
15 videos (Total 80 minutos), 3 lecturas, 1 cuestionario
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 lecturas
Let There Be Third Normal Form5m
SELECT Statements in Transactions5m
Database Indexes30m
1 ejercicio de práctica
Relational Databases30m
Semana
3

Semana 3

2 horas para completar

Big Data

2 horas para completar
12 videos (Total 63 minutos), 1 lectura, 1 cuestionario
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 lectura
What about Velocity?15m
1 ejercicio de práctica
Big Data30m
Semana
4

Semana 4

2 horas para completar

SQL Tools for Big Data Analysis

2 horas para completar
12 videos (Total 53 minutos), 1 lectura, 1 cuestionario
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 lectura
Open Source and Apache15m
1 ejercicio de práctica
SQL Tools for Big Data Analysis30m

Reseñas

Principales reseñas sobre FOUNDATIONS FOR BIG DATA ANALYSIS WITH SQL

Ver todas las reseñas

Acerca de Programa especializado: Modern Big Data Analysis with SQL

Modern Big Data Analysis with SQL

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.