{"id":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","title":"SQL for Analytics: Operator — Deep Dive and Execution","description":"SQL for Analytics: Operator — Deep Dive and Execution is designed for career starters and switchers aged 25–34 who need a concrete, portfolio-ready result instead of abstract theory. Across 9 lessons and about 28 hours, the curriculum focuses on course orientation and outcomes, core concepts and mental models, and tools, setup, and learning environment; the final deliverable is a KPI dashboard assembled with query editors, Jupyter and data warehouses.","contentLanguage":"en","coverUrl":"/course-covers/sql-for-analytics-operator-deep-dive-and-execution-68c24abc-a1d.webp","createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:51:46.280Z","durationSeconds":100800,"authorId":"2dfda15a-49d5-4851-96de-6971123c37f2","rating":4.8,"reviewCount":5,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic familiarity is recommended. The opening block quickly aligns terminology and tools, then moves straight into hands-on implementation.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 9 lessons and about 28 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a KPI dashboard plus reusable materials built around query editors and Jupyter.","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":129,"features":[],"highlighted":true}],"minPricingTierPrice":129,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"63343756-243a-465d-95d8-43eff5f14b2f","title":"SQL for Analytics: Operator — Deep Dive and Execution — course orientation and outcomes","description":"Lesson 1 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through course orientation and outcomes and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":0,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0a089581-fb59-49a8-9101-aff5fa94307f","title":"SQL for Analytics: Operator — Deep Dive and Execution — core concepts and mental models","description":"Lesson 2 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through core concepts and mental models and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":1,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"fff152ea-b4de-4beb-8157-9a8d5f46f86a","title":"SQL for Analytics: Operator — Deep Dive and Execution — tools, setup, and learning environment","description":"Lesson 3 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through tools, setup, and learning environment and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":2,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2dafce61-7336-4ba0-a14a-7c88d8c8f520","title":"SQL for Analytics: Operator — Deep Dive and Execution — practical workflows and process design","description":"Lesson 4 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through practical workflows and process design and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":3,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"38ff40a3-1993-4a6b-8129-5760f646fb4d","title":"SQL for Analytics: Operator — Deep Dive and Execution — real cases and guided practice","description":"Lesson 5 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through real cases and guided practice and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":4,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8461f52e-029f-4c28-a4bd-37f3fa78dccf","title":"SQL for Analytics: Operator — Deep Dive and Execution — project build and review","description":"Lesson 6 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through project build and review and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":5,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c4d823d5-9039-4d69-9559-2ab678cd6c5e","title":"SQL for Analytics: Operator — Deep Dive and Execution — implementation, handoff, and next steps","description":"Lesson 7 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through implementation, handoff, and next steps and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":6,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"83facc64-c818-4d9d-b8ef-35da1f71953e","title":"SQL for Analytics: Operator — Deep Dive and Execution — advanced applications and extensions","description":"Lesson 8 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through advanced applications and extensions and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":7,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c089088d-5f4a-4f11-92dc-2b80f23106cd","title":"SQL for Analytics: Operator — Deep Dive and Execution — data handling and preparation","description":"Lesson 9 of 9 in SQL for Analytics: Operator — Deep Dive and Execution: work through data handling and preparation and turn the result into a reusable part of the final KPI dashboard using query editors and Jupyter.","videoUrl":null,"videoFileName":null,"duration":11200,"position":8,"createdAt":"2026-05-26T07:47:26.374Z","updatedAt":"2026-05-26T07:47:26.374Z","courseId":"f6a73e65-fa5e-486e-bceb-aa05b03ce269","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"2dfda15a-49d5-4851-96de-6971123c37f2","name":"Leo Hayes","avatarUrl":null,"bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}