このコースについて

17,939 最近の表示

受講生の就業成果

33%

コース終了後に新しいキャリアをスタートした

17%

コースが具体的なキャリアアップにつながった

20%

昇給や昇進につながった
共有できる証明書
修了時に証明書を取得
100%オンライン
自分のスケジュールですぐに学習を始めてください。
柔軟性のある期限
スケジュールに従って期限をリセットします。
約25時間で修了
英語
字幕:英語

習得するスキル

Data WarehousingMaterialized ViewData WarehouseSQL

受講生の就業成果

33%

コース終了後に新しいキャリアをスタートした

17%

コースが具体的なキャリアアップにつながった

20%

昇給や昇進につながった
共有できる証明書
修了時に証明書を取得
100%オンライン
自分のスケジュールですぐに学習を始めてください。
柔軟性のある期限
スケジュールに従って期限をリセットします。
約25時間で修了
英語
字幕:英語

提供:

University of Colorado System ロゴ

University of Colorado System

シラバス - 本コースの学習内容

コンテンツの評価Thumbs Up95%(1,503 件の評価)Info
1

1

4時間で修了

DBMS Extensions and Example Data Warehouses

4時間で修了
7件のビデオ (合計44分), 14 readings, 1 quiz
7件のビデオ
Course objectives video lecture4 分
Course topics and assignments video lecture5 分
DBMS extensions video lecture8 分
Relational database schema patterns video lecture8 分
Colorado Education Data Warehouse video lecture7 分
Data warehouse standards in health care video lecture7 分
14件の学習用教材
Powerpoint lecture notes for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Optional textbook10 分
Powerpoint lecture notes for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Powerpoint lecture notes for lesson 610 分
Overview of software requirements10 分
Overview of database software installation10 分
Oracle installation notes10 分
Making connections to a local Oracle database10 分
SQL statements for Store Sales tables10 分
SQL statements for Inventory DW tables10 分
Optional textbook reading material10 分
1の練習問題
Module 1 quiz30 分
2

2

7時間で修了

SQL Subtotal Operators

7時間で修了
5件のビデオ (合計39分), 12 readings, 3 quizzes
5件のビデオ
SQL CUBE operator video lecture7 分
SQL ROLLUP operator video lecture7 分
SQL GROUPING SETS operator video lecture7 分
Variations of subtotal operators video lecture9 分
12件の学習用教材
Powerpoint lecture notes for lesson 110 分
Additional problems for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Additional problems for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Additional problems for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Additional problems for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Additional problems for lesson 510 分
Optional textbook reading material10 分
Assignment notes10 分
2の練習問題
Module 2 quiz20 分
Quiz for module 2 assignment2 時間 4 分
3

3

7時間で修了

SQL Analytic Functions

7時間で修了
5件のビデオ (合計47分), 12 readings, 3 quizzes
5件のビデオ
Extended Syntax and Ranking Functions video lecture7 分
Window Comparison I video lecture8 分
Window Comparisons II video lecture10 分
Functions for Ratio Comparisons video lecture10 分
12件の学習用教材
Powerpoint lecture notes for lesson 110 分
Additional problems for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Additional problems for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Additional problems for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Additional problems for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Additional problems for lesson 510 分
Optional reading material10 分
Assignment notes10 分
2の練習問題
Module 3 quiz20 分
Quiz for module 3 assignment1 時間 38 分
4

4

6時間で修了

Materialized View Processing and Design

6時間で修了
5件のビデオ (合計54分), 11 readings, 3 quizzes
5件のビデオ
Materialized view definition and processing video lecture9 分
Query Rewriting Rules video lecture8 分
Query Rewriting Examples video lecture10 分
Oracle Tools for Data Integration video lecture14 分
11件の学習用教材
Powerpoint lecture notes for lesson 110 分
Additional problems for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Additional problems for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Additional problems for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Additional problems for lesson 510 分
Optional textbook reading material10 分
Assignment notes10 分
2の練習問題
Module 4 quiz30 分
Quiz for module 4 assignment38 分

レビュー

RELATIONAL DATABASE SUPPORT FOR DATA WAREHOUSES からの人気レビュー

すべてのレビューを見る

Data Warehousing for Business Intelligence専門講座について

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....
Data Warehousing for Business Intelligence

よくある質問

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

さらに質問がある場合は、受講者向けヘルプセンターにアクセスしてください。