CertOcean's Data Warehousing Certification training is a self-paced online course. You learn at your own pace through 13 video lessons (27 hours in total), work through 5 curriculum modules with hands-on assignments and keep lifetime access to the video lessons.
Self-paced trainingLearn at your own pace, with in-depth coverage of every concept in the course.
Real-life case studiesToward the end of the course, you work on a project that applies the techniques you learned.
AssignmentsEach module includes practical assignments that help you apply its concepts.
Lifetime accessKeep lifetime access to all course material, including presentations, quizzes, installation guides and recordings.
24/7 expert supportOur support team is available 24x7 to answer technical questions.
CertificationComplete the final project to receive CertOcean's Data Warehousing certificate.
What you'll learn in this course
Understand data warehouse concepts and why businesses use them
Tell dimensions and facts apart and design both
Organize data with normalization and star and snowflake schemas
Gather requirements and model a data warehouse
Understand how ETL loads data into a warehouse
Apply data warehousing best practices to real projects
What is data warehousing certification training?
Data warehousing certification training is a course that teaches you to design and load a data warehouse: a central store of integrated, historical data used for reporting and analysis. CertOcean's course covers facts, dimensions, schemas, metadata, normalization, data transformation, dimensional modeling and ETL concepts, giving you the foundation for a career in this field.
What are the objectives of data warehousing training?
After this course, you will be able to:
Understand and apply fact tables and dimensions
Understand and apply schemas, normalization and data modeling
Model a data warehouse
Understand and work through ETL jobs
Who should take data warehousing training?
This course is a foundation for anyone who wants to become a data warehouse business analyst, architect or developer, including:
BI and ETL professionals
Project managers
Testing professionals
Mainframe professionals
Analytics professionals
Software developers and architects
Why learn data warehousing?
Because businesses now make decisions based on data rather than intuition, and that requires data stored in a way that supports analysis. A data warehouse does exactly that. Demand for data warehousing professionals is strong, and the skill opens many opportunities in business intelligence and analytics.
What are the prerequisites for data warehousing training?
There are no prerequisites, so anyone can take this course. Basic knowledge of databases and SQL will help you move faster.
What are the system requirements for data warehousing training?
You need a computer with a reliable internet connection. Our 24x7 support team can help with any setup questions.
How do the hands-on data warehousing practicals work?
You do all the projects in a lab environment set up for this course.
Curriculum
Data Warehousing Certification course syllabus
5 modules · 28 topics · 27 hours of video training
01Introduction to Data Warehousing9 topics
Learning goal: Learn what a data warehouse is, why businesses need one and how to approach building it.
What a data warehouse is: subject-oriented, integrated, non-volatile and time-variant
Why businesses need a data warehouse
Data warehouse vs. database
Operational (OLTP) vs. analytical (OLAP) systems
What a data mart is
Operational data store (ODS): subject-oriented, integrated, current, volatile and detailed
Benefits of an ODS
Top-down, bottom-up and federated design approaches
02Dimensions and Facts6 topics
Learning goal: Understand dimensions, facts and hierarchies, and how they differ.
What dimensions and facts are
Types of dimensions, with a focus on slowly changing dimensions (SCD Types 1, 2 and 3)
Types of facts
What hierarchies are
Types of hierarchies
03Normalization and Schemas5 topics
Learning goal: Organize data across tables with normalization, and learn the main schema types and the role of metadata.
What normalization is
What a schema is
Star, snowflake and galaxy schemas
The role of metadata
04Data Warehouse Modeling4 topics
Learning goal: Gather requirements and apply dimensional modeling to build a warehouse.
Requirement gathering
Principles of dimensional modeling
Modeling and ER diagrams
05ETL in Detail4 topics
Learning goal: Learn how data is extracted, transformed and loaded into the warehouse.
ETL concepts and architecture: source, staging, atomic and dimension layers
Transformation: data validation, data accuracy, data type conversion and business rules
Data loading techniques
Get the detailed syllabus
Receive the full module plan, access details and a call with an advisor who can answer your exam questions.
How much does the Data Warehousing Certification course cost?
The Data Warehousing Certification training costs $149, down from the regular $170 (you save 12%). It is a one-time payment in US dollars, and you can pay securely by card or PayPal.
Who can I contact if I have a problem during the course?
Contact our support team, available 24x7. Ask any question about the course and we will resolve it as quickly as possible.
Can I see a sample lesson before enrolling?
Yes. You can watch our sample videos to judge the quality and level of the teaching before you enroll.
Who are the instructors for CertOcean's data warehousing course?
Our instructors are data warehousing practitioners with more than 10 years of experience, chosen through a careful selection and training process.
Do you offer placement support?
Your LMS includes a resume builder tool with unlimited access to templates for different roles. Log in to your LMS and click "Create your resume".
Can I get help after completing the course?
Yes. Our support continues after your course ends, so you can keep asking functional and technical questions.
How long does the data warehousing course take?
The course is self-paced, so it depends on your schedule. You keep lifetime access, so you can take as long as you need and revisit any module later.
Will I get a certificate after the Data Warehousing Certification training?
Yes. You receive a CertOcean certificate of completion when you finish the training.
Free course consultation
Talk to a Data Warehousing Certification advisor
Share your details and we will send the syllabus, your course access details and the best plan for your exam date.