{"id":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","title":"Data Warehouse Fundamentals","description":"The course Data Warehouse Fundamentals is designed for career starters and switchers aged 25–34 and turns the topic into a practical result instead of abstract theory. The program includes 7 lessons, applied work with star schema, fact tables and ETL, and a final data pipeline blueprint; the focus is core concepts and mental models, data handling and preparation and tools, setup, and learning environment.","contentLanguage":"en","coverUrl":"/course-covers/data-warehouse-fundamentals-v2.webp","createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:51:42.556Z","durationSeconds":72000,"authorId":"26b854e5-673e-49d0-861f-2b58a0e3634b","rating":4.386363636363637,"reviewCount":44,"expectedLessonsCount":7,"trailerUrl":null,"faq":[{"answer":"Basic Python or SQL will make the pace easier. The course starts with a clear ramp-up and then moves into foundations and tools.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 4–6 hours per week. In total, the course includes 7 lessons and about 20 hours of guided study.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a data pipeline blueprint plus reusable materials built around star schema, fact tables and ETL.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["advanced"],"firstLessonFreePreviewEnabled":false,"certificateEnabled":true,"isPlatformCourse":false,"pricingTiers":[{"id":"standard","name":"Standard","price":79,"features":[],"highlighted":true}],"minPricingTierPrice":79,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"bc4edd66-7b0c-44da-893c-9e4ffc8fc833","title":"Data Warehouse Fundamentals — course orientation and outcomes","description":"Lesson 1 of 7 in Data Warehouse Fundamentals: work through course orientation and outcomes in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10286,"position":0,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f4c5ff17-28c9-4918-8644-0de4af46b4ec","title":"Data Warehouse Fundamentals — core concepts and mental models","description":"Lesson 2 of 7 in Data Warehouse Fundamentals: work through core concepts and mental models in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10286,"position":1,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a6d42d19-6a16-43be-a3a4-15960c3b6071","title":"Data Warehouse Fundamentals — data handling and preparation","description":"Lesson 3 of 7 in Data Warehouse Fundamentals: work through data handling and preparation in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10286,"position":2,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"904dd6f1-339e-4b7a-ba13-54b59836e349","title":"Data Warehouse Fundamentals — tools, setup, and learning environment","description":"Lesson 4 of 7 in Data Warehouse Fundamentals: work through tools, setup, and learning environment in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10286,"position":3,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"fad593b4-32d2-4927-8728-c5ab0de7e59f","title":"Data Warehouse Fundamentals — queries, models, and structure","description":"Lesson 5 of 7 in Data Warehouse Fundamentals: work through queries, models, and structure in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10286,"position":4,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"6ee91cdf-91f3-4ebb-82fd-a103b73efa53","title":"Data Warehouse Fundamentals — project build and review","description":"Lesson 6 of 7 in Data Warehouse Fundamentals: work through project build and review in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10285,"position":5,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a9b385a3-470e-4dc4-9653-d52eb0148e40","title":"Data Warehouse Fundamentals — implementation, handoff, and next steps","description":"Lesson 7 of 7 in Data Warehouse Fundamentals: work through implementation, handoff, and next steps in the context of Data Warehouse Fundamentals, and turn the result into a reusable part of the final data pipeline blueprint using star schema and fact tables.","videoUrl":null,"videoFileName":null,"duration":10285,"position":6,"createdAt":"2026-05-26T07:45:28.688Z","updatedAt":"2026-05-26T07:45:28.688Z","courseId":"e7ecc9b7-e188-4a67-808d-4fdee6c3a582","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"26b854e5-673e-49d0-861f-2b58a0e3634b","name":"Gavin Bailey","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/92f8b421-d35c-4953-9c37-d28a8023239a.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}