Relational Database Support for Data Warehouses (Coursera)

Relational Database Support for Data Warehouses (Coursera)

Añade tu reseña
Añadir a Mis FavoritosAñadido a tus favoritosEliminado de tus favoritos 0
Añadir para comparar

Descripción de “Relational Database Support for Data Warehouses (Coursera)”

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you’ll use analytical elements of SQL for answering business intelligence questions. You’ll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting.

Because of the importance and difficulty of managing implementations of data warehouses, we’ll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts.

Relational Database Support for Data Warehouses is course 3 of 5 in the Data Warehousing for Business Intelligence Specialisation.

Evaluate business needs; design a data warehouse; and integrate, and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.

Syllabus

Week 1: DBMS Extensions and Example Data Warehouses

Week 2: SQL Subtotal Operators

Week 3: SQL Analytic Functions

Week 4: Materialized View Processing and Design

Week 5: Physical Design and Governance

Especificaciones: Relational Database Support for Data Warehouses (Coursera)

Curso ofrecido por
Disponibilidad

✔ Disponible

Plataforma

Universidad

Impartido por

Michael Mannino

País

USA

Nivel, duración y fechas
Nivel

No informado

Fecha

04/05/2020

Duración

5 semanas

Tiempo necesario

Sin información

Idioma del curso
Idioma vehicular

Inglés

Subtítulos

Inglés

Exámenes y Certificados
Certificados

Certificado de Pago

Exámenes/Proyectos

Con Examen/Proyecto Final de pago

User Reviews

0.0 fuera de 5
0
0
0
0
0
Write a review

Aún no hay reseñas.

Se el primero en opinar sobre “Relational Database Support for Data Warehouses (Coursera)”

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Antes de enviar tu opinión, has de aceptar nuestra política de cookies y privacidad

Relational Database Support for Data Warehouses (Coursera)
Relational Database Support for Data Warehouses (Coursera)

Este sitio web utiliza cookies para un correcto funcionamiento. Si continúas navegando estás dando tu consentimiento para estas cookies y aceptas nuestra política de cookies, clic para más información.

ACEPTAR
Aviso de cookies
Comparar artículos
  • Total (0)
Comparar
0