This course is part of the Key Technologies in Data Analytics Specialization

3.9

stars

44 ratings

Erik Herman

Offered By

Key Technologies in Data Analytics SpecializationLearnQuest

About this Course

3,005 recent views

Welcome to Fundamentals of Data Warehousing, the third course of the Key Technologies of Data Analytics specialization. By enrolling in this course, you are taking the next step in your career in data analytics. This course is the third of a series that aims to prepare you for a role working in data analytics. In this course, you will be introduced to many of the core concepts of data warehousing. You will learn about the primary components of data warehousing. We’ll go through the common data warehousing architectures. The hands-on material offers to add storage to your cloud environment and configure a database. This course covers a wide variety of topics that are critical for understanding data warehousing and are designed to give you an introduction and overview as you begin to build relevant knowledge and skills.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 3 of 4 in the

Key Technologies in Data Analytics Specialization

Beginner Level

Approx. 14 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 3 of 4 in the

Key Technologies in Data Analytics Specialization

Beginner Level

Approx. 14 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

3.91/5 (13 Ratings)

Erik Herman

5,781 Learners

10 Courses

Offered by

LearnQuest

LearnQuest is the preferred training partner to the world’s leading companies, organizations, and government agencies. Our team boasts 20+ years of experience designing, developing and delivering a full suite industry-leading technology education classes and training solutions across the globe. Our trainers, equipped with expert industry experience and an unparalleled commitment to quality, facilitate classes that are offered in various delivery formats so our clients can obtain the training they need when and where they need it.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

5 hours to complete

Concepts

5 hours to complete

11 videos (Total 8 min), 4 readings, 5 quizzes

11 videos

Course Introduction And Objectives1mModule Introduction And Objectives36sIntroduction To Subject-Oriented1mSubject-Oriented In Your Reading17sIntroduction To Integrated54sIntegrated In Your Reading21sIntroduction To Time-Variant1mTime-Variant In Your Reading13sIntroduction To Nonvolatile1mNonvolatile In Your Reading11sModule 1 Summary16s

4 readings

Data Warehousing - Overview10mWhich Data Integration Approach Is Right For You?10mTime-Variant System10mNonvolatile Data10m

5 practice exercises

Subject-Oriented30mIntegrated30mTime-Variant30mNonvolatile30mModule 1 Graded Quiz30m

Week2

Week 2

5 hours to complete

Components

5 hours to complete

11 videos (Total 11 min), 5 readings, 5 quizzes

11 videos

Module Introduction And Objectives29sIntroduction To Database Structures1mDatabase Structures In Your Reading14sIntroduction To ETL and ELT1mETL and ELT In Your Reading23sIntroduction To Metadata56sMetadata In Your Reading13sIntroduction To Tools34sTools In Your Reading12sHands-On Demonstration4mModule 2 Summary18s

5 readings

Database Structure And Design Tutorial10mETL vs ELT: 5 Critical Differences10mWhat Is Metadata (With Examples)10mQuerying and Reporting Tools for Data Warehousing10mHands-On Exercise: Add Storage To Your AWS Environment10m

5 practice exercises

Database Structures30mETL and ELT30mMetadata30mTools30mModule 2 Graded Quiz30m

Week3

Week 3

5 hours to complete

Design and Architecture

5 hours to complete

10 videos (Total 7 min), 4 readings, 5 quizzes

10 videos

Module Introduction And Objectives34sIntroduction To Design Approach50sDesign Approach In Your Reading25sIntroduction To Single Tier Architecture59sSingle Tier Architecture In Your Reading21sIntroduction To Two Tier Architecture1mTwo Tier Architecture In Your Reading20sIntroduction To Three Tier Architecture1mThree Tier Architecture In Your Reading17sModule 3 Summary17s

4 readings

Various Data Warehouse Design Approaches:Top-Down and Bottom-Up10mDatabase Architecture in DBMS: 1-Tier, 2-Tier and 3-Tier10mTwo-Tier vs Three-Tier Architecture10m3-Tier Architecture: A Complete Overview10m

5 practice exercises

Design Approach30mSingle Tier Architecture30mTwo-Tier Architecture30mThree Tier Architecture30mModule 3 Graded Quiz30m

About the Key Technologies in Data Analytics Specialization

This specialization aims to prepare you for a role working in data analytics. The first course is Fundamentals of Data Analysis. You’ll be introduced to core concepts and you’ll learn about the tools and skills required to conduct data analysis.

The second course, Fundamentals of Cloud Computing, will introduce you to core concepts of cloud computing and the primary deployment and service models. The hands on material offers the opportunity to review and configure a cloud account. In Fundamentals of Data Warehousing, you will learn core concepts of data warehousing. You will learn about the primary components and architectures of data warehousing. The hands on material offers the opportunity to review and configure cloud storage options. In Fundamentals of Big Data, you will be introduced to concepts, systems and life cycles of big data. The hands on material offers you the opportunity to load data into your cloud account.

Frequently Asked Questions

When will I have access to the lectures and assignments?
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.
What will I get if I subscribe to this Specialization?
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.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Fundamentals of Data Warehousing

About this Course