courseraАнализ данных

Relational Database Support for Data Warehouses

Курс от University of Colorado System

Уровень не указан≈ 71.5 чАнглийский

О курсе

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. In the assignments in this course, you can use either Oracle or PostgreSQL.

Навыки, которые вы освоите

SQL Business Intelligence Oracle Databases Data Integration Data Mining Database Management Systems PostgreSQL Big Data Data Warehousing Data Governance Data Storage Technologies Data Architecture Analytics Analytical Skills Data Management Query Languages Business Analytics Relational Databases

Программа курса

6 модулей · 119 учебных материалов

01DBMS Extensions and Example Data Warehouses20 материалов

Course objectives

Course introduction videoВидео Course objectives video lectureВидео Powerpoint lecture notes for lesson 1Чтение Get help and meet other learners in this course. Join your discussion forums!Чтение

Course topics and assignments

Учитесь у экспертов

Michael Mannino

Associate Professor

В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 71.5 ч

6 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Relational Database Support for Data Warehouses

О курсе

Навыки, которые вы освоите

Программа курса

Course objectives

Course topics and assignments

Учитесь у экспертов

Michael Mannino

DBMS extensions

Relational database schema patterns

Colorado Education Data Warehouse

Data warehouse standards in health care

Course software requirements

Quiz

GROUP BY clause review

SQL CUBE operator

SQL ROLLUP operator

SQL GROUPING SETS operator

Variations of subtotal operators

Quiz and Assignment

Processing Model and Basic Syntax

Extended Syntax and Ranking Functions

Window Comparisons I

Window Comparisons II

Functions for Ratio Comparisons

Quiz and Assignment

Background on Traditional Views

Materialized view definition and processing

Query Rewriting Rules

Query Rewriting Examples

Quiz and Assignment

Storage Architectures

Scalable Parallel Processing Approaches

Big data issues

Data Governance

Quiz and Assignment

Motivation and Background

SQL Coding for Simple Item Sets and Association Rules

Statement Patterns for Item Sets and Association Rules

SQL Coding to Evaluate Association Rules

SQL Coding to Generate Matrix Input for Association Rule Mining

SQL Coding to Generate Nested Input for Association Rule Mining

Overview of SQL for Training Data with Top Event History

SQL Coding to Generate Training Data with Top Event History

Closing

Quiz and Assignment