{"id":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment","description":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment is built for career starters and switchers aged 25–34 who want a concrete, portfolio-ready result rather than abstract theory. Across 7 lessons and about 17 hours, the course focuses on course orientation and outcomes, SQL exploration, and foundations and working vocabulary; the capstone is an analytics report system built with Python and dbt.","contentLanguage":"en","coverUrl":null,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.505Z","durationSeconds":61200,"authorId":"ffe8aef0-11dd-437a-ac7b-ebc9e380578f","rating":4.738461538461539,"reviewCount":65,"expectedLessonsCount":7,"trailerUrl":null,"faq":[{"answer":"A minimal base is recommended, but the opening block still aligns terminology, tools, and expectations before practice.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 7 lessons and about 17 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with an analytics report system plus reusable materials built around Python and dbt.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["intermediate"],"firstLessonFreePreviewEnabled":false,"certificateEnabled":true,"isPlatformCourse":false,"pricingTiers":[{"id":"standard","name":"Standard","price":89,"features":[],"highlighted":true}],"minPricingTierPrice":89,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"de703103-4e90-426f-9a82-69c550df5e6a","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — course orientation and outcomes","description":"Lesson 1 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through course orientation and outcomes and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8743,"position":0,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"1ad21026-b85c-4d6a-b185-dd419dfeb360","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — SQL exploration","description":"Lesson 2 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through SQL exploration and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8743,"position":1,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"fd7f292c-070b-4647-8f80-4e4631cbf2e7","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — foundations and working vocabulary","description":"Lesson 3 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through foundations and working vocabulary and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8743,"position":2,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"72603b1f-e8f8-440f-b1b9-d90d14022efb","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — quality, review, and risk control","description":"Lesson 4 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through quality, review, and risk control and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8743,"position":3,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"80974421-879a-42aa-95f3-c3b1d39c42f7","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — handoffs and documentation","description":"Lesson 5 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through handoffs and documentation and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8743,"position":4,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"13bbbc08-5817-4842-bd16-4fb4e8bbdf70","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — workflow design and handoffs","description":"Lesson 6 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through workflow design and handoffs and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8743,"position":5,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8e38ec47-f836-4c19-b410-5a9a7ccc7156","title":"SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment — guided cases and practice","description":"Lesson 7 of 7 in SQL for Analytics: Cohort Track — Reporting, Priorities, and Alignment: work through guided cases and practice and convert the result into a reusable part of the final analytics report system using Python and dbt.","videoUrl":null,"videoFileName":null,"duration":8742,"position":6,"createdAt":"2026-05-26T07:51:27.376Z","updatedAt":"2026-05-26T07:51:27.376Z","courseId":"7e8c27b6-ab9e-4f78-b7ca-f9b26a483d3a","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"ffe8aef0-11dd-437a-ac7b-ebc9e380578f","name":"William Sutton","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/59e98f87-29b3-4dc7-ab89-42224ac46fb8.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}